Hi,
I've a question with recurring appointments while editing or cancelling.
Here is my question,
whenever the user is editing/cancelling the recurring appointment, how to perform cancellation of series and only this occurence? Could you please provide some guidance on this?
Looking for the reply.
Thanks in advance!!
Hello email2prasan ,
Please refer to the following overview of the names, descriptions, parameter lists and result sets of the stored procedures required by the WebSchedule data providers. This should be helpful in seeing what type of parameters the procedures need.
http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=WebSchedule_Overview_of_the_Stored_Procedures_Used_by_the_WebSchedule_Data_Providers.html
Regarding the originalstartdatetimeutc and the status. The originalstartdatetimeutc returns or sets the original start date/time of the Activity in a recurring series. It’s saved as a DateTime in the data base.
The status indicates the state of the activity. It could be normal,expired or deleted (http://help.infragistics.com/NetAdvantage/ASPNET/2011.1/CLR4.0/?page=Infragistics4.WebUI.WebSchedule.v11.1~Infragistics.WebUI.WebSchedule.Activity~Status.html) . It is saved as an Int32 in the data base.
Here’s a link to a thread with a description and a sample on how to set up a web schedule with sql data source:
http://forums.infragistics.com/forums/p/64931/328583.aspx#328583
It should be helpful in creating your own data base .
Let me know if you need further assistance.
Best Regards,
Maya Kirova
Developer Support Engineer
Infragistics, Inc.
http://ko.infragistics.com/support
Thanks for your reply maya!!
Could you please let me know what value required to be stored DB - Status and originalstartdatetimeutc fields? I really dont have any clue how the things needs to be stored in database. It will be helpful if you let me know some sample entries in database to explain how the recurring appointments has been edited and cancelled.
Generally when you try and open a recurring appointment if you’re using the sample IG forms and scripts you’ll be presented with a dialog window that gives you a choice whether to open the specific occurrence or open the series. If you open the occurrence any changes you make to it (including deleting it) will be applied only to this single occurrence and it will be considered a variance (and update the variance data source with the new variance). If you open the series the changes will be made to all occurrences associates with the recurring activity and the activity data source will be updated. For such an example you can refer to:
http://samples.infragistics.com/aspnet/Samples/WebSchedule/Data/BindGDProviderToICollection/Default.aspx?cn=schedule&sid=83f14168-3433-4463-a660-ce8258db47ea
Let me know if you have any questions.