Actually I am using scheduler where I can track child activities, child will attend the activities or if he doesn't attend we can delete that task on that day.
As of now my I am able to do all these tasks using the scheduler control.
My problem is :
Per task we will charge some amount based on child age, I need to do these calculations in a database based on child attendance.
I need a database query to get child completed tasks based on date wise. If I can get these in table format in the database and I can do above logic.
As of now In Appointments table has a data in single line format (DTSTART:20130916T093000Z
DTEND:20130916T103000Z
RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
EXDATE:20131008T093000Z,20131010T093000Z ). I need a query where I can get same gird data in the database.
As of now my I am able to do all these tasks using the scheduler control.
My problem is :
Per task we will charge some amount based on child age, I need to do these calculations in a database based on child attendance.
I need a database query to get child completed tasks based on date wise. If I can get these in table format in the database and I can do above logic.
As of now In Appointments table has a data in single line format (DTSTART:20130916T093000Z
DTEND:20130916T103000Z
RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
EXDATE:20131008T093000Z,20131010T093000Z ). I need a query where I can get same gird data in the database.
1 Answer, 1 is accepted
0
Hello Ashok,
Plamen
Telerik
You can refer to this blog post where is shown how you can work with recurrence Appointments on the SQL.
Hope this will be helpful.
Plamen
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.