Hi,
I am new to this Infragistics - Web schedule, Need to create a new appointment in such way that it should not overlap with other appointments or recurrences i.e.) should be linear. Appointment should not clashes with other appointment. How can I check this property? Is there any Events to do this?
Please guide me in doing this...
Regards,
Nagendran
Hi
In Order to avoid Recurrence appointement overlapping you need to do some Extra work.
First you need to Send your Recurrence Id to your Procedure and need to Check type of Recurrence
i.e(Daily,weekly,Yearly)and then need to fetch the set of Dates for that Recurrence type and after that you can check your overlapping appointment from these Dates.
I already achived by using this Method.
For Refrence take help from this Article
http://www.codeproject.com/KB/database/sqlscheduleselector.aspx
Thanks
Yashkant
Ahh I see, I don't personally use the recurrence feature at all as of yet but I would assume you could check it much the same way unless the recurrence appointment doesnt store a record in the database for each seperate recurrance of that appointment
Thanks Heran for the Reply. Yes you are right, But I want to know how to check the Recurrence Appointments?
Nagendran C
The best way to do this is to make a query against the data you are using and check to see if there are any appointments that fall within your time frame already there. Do this before the appointment gets added so that you can stop the process of adding the appointment or make a change to the appointment before its finished being added. I had done this with my own WebDayView. Its not too difficult just pass the start, end, and date of the new appointment as parameters in the query and select any appointments where end > start or start < end and date = date. Then in your code you can say this.
if (Overlap Check Query Rows Count > 0)
{
some code to either end the process of adding or change the new appointment before continuing.
}
else
finish adding appointment.