This is a migrated thread and some comments may be shown as answers.

[Solved] How to deal with the Recurrence data when trying to show the schedules in a Telerik Report.?

8 Answers 259 Views

Scheduler

This is a migrated thread and some comments may be shown as answers.

karthik asked on 12 Jan 2009, 03:55 PM

Hi,

I have implemented a scheduler and the schedules contains recurrence data.

Now I need to show these schedules created, in a telerik report.

My report page would not contain a scheduler. I just want to connect to the database, get the schedules data from the table and show it in a telerik report.

My question is, the recurrence field in the database, contains a string like this:

"DTSTART:20090106T150000Z DTEND:20090106T190000Z RRULE:FREQ=DAILY;COUNT=10;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU ".

How to parse this and show it in the report ?

Should I follow this logic or is there a better way to do it ?

1. Read data from the database.

2. Create new instances of "Appointment" based on the data read from the database, for each row.

3. Use "RecurrenceRule" to parse the recurrence, if recurrence field is not empty.

4. Add the result to a datatable and bind it to the report.

Is the above logic the way to go ? Please advice.

Thanks in advance.

-Karthik Selvaraj

8 Answers, 1 is accepted

Accepted

answered on 12 Jan 2009, 04:32 PM

Hi Peter,

Thanks and I appreciate your fast reply.

I have implemented the following code based on the link you suggested:

private DataTable GetGridDataSource()

{

//Create a dynamic table to store the appointments' information:

DataTable table1 = new DataTable();

table1.Columns.Add("Subject");

table1.Columns.Add("StartDate");

table1.Columns.Add("EndDate");

SchedulesService schedulesService = new SchedulesService(); //Our custom service to get the schedules info from database

TList<Schedules> schedulesList = schedulesService.GetAll(); //This will be a list of all schedules as it exists in database.

foreach (Schedules schedule in schedulesList) //Each schedule as it exists in database

{

if (string.IsNullOrEmpty(schedule.RecurrenceRule)) //No recurrence rule

{

table1.Rows.Add(new string[] { schedule.Subject.ToString()

, schedule.StartTime.ToString()

, schedule.EndTime.ToString() });

}

else //Recurrence rule exists

{

RecurrenceRule parsedRule;

RecurrenceRule.TryParse(schedule.RecurrenceRule,out parsedRule);

foreach (DateTime occurrence in parsedRule.Occurrences)

{

table1.Rows.Add(new string[] { schedule.Subject.ToString()

, occurrence.ToString()

, occurrence.AddHours(1).ToString() });

}

return table1;

}

This code works fine. However please look at the bold line in the code to get the end time of the recurrence schedule. (I am just adding one hour to the start time).

Is there any way to get the end time of that schedule (without having to create instances of "Appointment" object as mentioned in the link you had suggested)..

Thanks for your invaluable help..

- Karthik