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,
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,