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

Recurrence Overlapping

1 Answer 58 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
EZNet Support
Top achievements
Rank 1
EZNet Support asked on 25 Apr 2012, 03:31 PM
This will be a hard explanation, but here goes:

Scenario:

We are using RadScheduler as a resource scheduler with Resource Grouping. We are having issues validating in a timely fashion with large recurring appointments and our assignment count logic.

Our Resources have an assignment count: (Example: Room #1, has an max occupancy of 100, Room #2 has an max occupancy of 2, so for a particular timeslot it can have 100 appointments in it.)

Scenario Example:

Room #1 has 100 Recurring Appointments that have a frequency of every weekday for 2 weeks, Monday-Friday 8:00 AM - 9:00 AM. Therefore the Assignment count max has been reached @ 100.

End User wants to schedule an appointment that reoccurs everyday other Tuesday @ 8 AM and it falls in one of these timeslots.
Right now we expand out the occurrences of all the reoccurring appointments to validate using SQL server and UDF, this becomes super inefficient when each of the reoccurring appointments can have 100-1000 occurrences each.

What we are looking for is there a way to take the recurrence string and compare say 2 strings, and get a return value that says that they overlap here this many times. So we can count up the amount and if its < than the assignment count then its valid.

Any ideas/help would be greatly appreciated.

Thanks,


1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 26 Apr 2012, 02:52 PM
Hi,

Please, review this code library entry - Occupied time slots and recurring appointments.

Also, this kb article shows how to expand the recurrence rule from code - How to display all RadScheduler appointments in GridView.

Kind regards,
Peter
the Telerik team
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 their blog feed now.
Tags
Scheduler
Asked by
EZNet Support
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or