Delete Occurrence in a appointment recurrence

[Robi]

Hi,
In my scheduleviewer you can create an appointment recurrence and this will be saved in the database (see attached file). it will save all needed information from the recurrence in the db. Now the problem is, if someone deletes an occurrence during the appointment recurrence, it will appear again in the scheduleview, beacause in the database the series is saved as one entity. my solution is, to split the saved recurrence in two. But for this I need the start and end date from the deleted occurrence. now my question is, how can I get the start and end date from the deleted occurrence, to create two (or more) reccurrences..?? Maybe with an scheduleView_Event.. ??

Regards,
Rob

[Yana]

Hello Rob,

I would suggest that you save the exceptions in a separate tables as in our Database example, you can check the used in the example schema in this help topic. Note that the exceptions can be of two types:

• when an occurrence of a recurrent appointment is deleted -in this case you could save only the exception date.
• when an occurrence of a recurrent appointment is edited - you should save all the properties of the exception separately, that is why we have in the example SqlExceptionAppointments, SqlExceptionResources tables.

When an occurrence is edited/deleted, the AppointmentEditing/Edited events of the parent appointment are fired, so you could use them to update the database. More information on the ScheduleView events can be found here.

I hope this helps.

 
Regards,
Yana
Telerik