[Solved] Interrogating RecurranceRule Column

[Joe]

Hi,

We are in the process of developing an appointment scheduling application using RadSchedular and we are very pleased with the results so far.  We have build screens for the staff to maintain their own calendars and we using sql server as a back end.

We have to create a customer facing application where the customer will select the date and staff type they wish to make an booking with and  will be presented with a list of appointments times for example they would enter the date 8 Jan 2008 and select the staff as  “Mechanic” . They would then get a list of available appointment times to select  from

                                10:00 Joe Bloggs

                                11:30 Joe Bloggs

                                10:30 James Jones

 

We do this by using a stored procedure to search for free slots in all the calendars for that StaffType . This is easy enough to do for regular appointments  by using the Start and End Date however I would like to be able to do this for recurring appointments. Is there any SQL or .NET code available which would allow us to interrogate the RecurranceRule columns

 

I hope this make sense

 

Thanks

Joe

 

 

 

 

 

[Peter]

Hello Joe,

Please, review the article on How to display all RadScheduler appointments in GridView. It will help you get started. For more information you can refer to the online help  recurring events overview and the
recurrence engine.

Let us know if you need further assistance.


Kind regards,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center