Hi,
Could you please let me know how to skip recurring appointments? Assume the cases like holidays I want the recurrence to be skipped on the holidays. Could you please provide the guidance on achieving this? Its very urgent looking forward for the help.
Thanks in advance!!
Do anyone know about this? Does Infragistics supports these functionalities?
Please let me know, looking forward for the replies!!
Hello email2prasan ,
Thank you for posting in our forum.
For exceptions to the rule of a recurring activity you can use variances. For a in-depth explanation on how the variances work you can refer to the following page from our documentation:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=WebSchedule_How_Recurrence_Logic_is_Executed.html
You can also refer to the following forum post that contains information on how to use the variances:
http://forums.infragistics.com/forums/p/33904/301079.aspx#301079
Let me know if you have any further need of assistance.
Best Regards,
Maya Kirova
Developer Support Engineer
Infragistics, Inc.
http://es.infragistics.com/support
Thanks for your reply Maya!!
you mean to say with the help of variance do I need to feed holiday records in appointments table?
However If I feed Holiday start datetime and end datetime It will show as a separate appointments in the webdayview calander. could you please clarify me?
You need to create a separate table to contain your variances. Please refer to the Data Model for the Activity and/or Variance Table.
http://help.infragistics.com/NetAdvantage/ASPNET/2011.1?page=WebSchedule_Data_Model_for_the_Activity_Table.html
The only difference between the Activity and Variance table is the OriginalStartDateTimeUtc field for the Variance data cannot be null.
If you’re using a WebScheduleGenericDataProvider you need to set the VarianceDataSource/VarianceDataSourceID to the corresponding source. For further information you can refer to the data model for that provider:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=WebScheduleGenericDataProvider_About_WebScheduleGenericDataProvider.html
Let me know if you have any questions.
Thank for your reply!!
I understand the activity and variance table datamodels however I want to make sure and clarify with you the below.
As per my understanding,
Consider I am scheduling recurring appointment from 03/20/2012 to 03/28/2012 and I will store the same in activity table with recurrence pattern. Assume there is a holiday say 03/26/12 falls in between 03/20/2012 to 03/28/2012. And now I will break the end dates of the recurring pattern and store as two entries in variance table. Is that correct? So I need to insert two records starting from 03/20/12 with recurrence pattern enddate as 03/23/12 and another record starting from 03/25/12 with recurrence pattern enddate as 03/28/12.
Could you please confirm me? Please correct me if my understanding is wrong.
Hello email2prasan,
You don’t need to break the recurrence. You just need to store the variance (which is the specific occurance for that date) which will reflect the change for that occurrence.Let’s say that you have one table that contains your Activities. You can set a recurrence to this activity in the same table.
There’s also a data source for the variances which contain all changes made to the original recurring appointments.
Now let’s say you have a recurring appointment from 03/20/2012 to 03/28/2012 and the date 03/26/12 should be an exception from the recurrence. You’ll need to add a new variance to the variance data source with the specification explained here by Derek Harmon:
http://forums.infragistics.com/forums/p/33675/183534.aspx#183534
Let me know if you have any further questions or concerns.