Inge Wandsvik
Top achievements
Rank 1
Rank 1
Inge Wandsvik
asked on 02 Jun 2008, 08:12 AM
I have 2 questions about the RadScheduler, that I can not find a solution for in the documentation. I'm using Stored Procedures for databinding, insert, update and delete.
- When I ad a new event to my RadScheduler, it allways shows as Recurrent. I guess this has something to do with what I insert into the tablefields RecurranceParentId and RecurrenceRule. What is the default value for those 2 fields if an event is nonreccurrent, and What is the default value for RecurranceParentId if an event is recurrant?
- If I have a recurrent event but I want to delete one of the occurences in the series, what will the SQL statement look like? The same goes for updating an occurence in a series.
Examples would be much appreciated.
3 Answers, 1 is accepted
0
Hi Inge,
Both fields default to NULL for non-recurring events. Returning non-null values might lead to the problem you are experiencing. You can take a look at the reference database schema for detailed information.
The RecurrenceParentID defaults to NULL for recurring appointments. Once you modify an occurrence a new appointment is inserted and its RecurrenceParentID is set to the ID of the original recurring appointment (the "master"). The new appointment becomes a "recurrence exception". It is still associated to the series, but it's content is modified.
When you delete an occurrence, the master's recurrence rule is modified to include an exception for the date of the deleted appointment. On the next data binding RadScheduler parses the rule and does not generate an occurrence for the specified exception dates.
Updating the recurrence series modifies the master appointment. Updating only a single occurrence creates an exception.
More information about the recurring events can be found here.
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Both fields default to NULL for non-recurring events. Returning non-null values might lead to the problem you are experiencing. You can take a look at the reference database schema for detailed information.
The RecurrenceParentID defaults to NULL for recurring appointments. Once you modify an occurrence a new appointment is inserted and its RecurrenceParentID is set to the ID of the original recurring appointment (the "master"). The new appointment becomes a "recurrence exception". It is still associated to the series, but it's content is modified.
When you delete an occurrence, the master's recurrence rule is modified to include an exception for the date of the deleted appointment. On the next data binding RadScheduler parses the rule and does not generate an occurrence for the specified exception dates.
Updating the recurrence series modifies the master appointment. Updating only a single occurrence creates an exception.
More information about the recurring events can be found here.
Greetings,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Inge Wandsvik
Top achievements
Rank 1
Rank 1
answered on 03 Jun 2008, 10:33 AM
Thanks, but i can not find out what event handlers i have to use in the codebehind for the different operations (such as insert new, update, delete). I am also missing the SQL statements to use for the different operations. I can not find any of this in the Live Demos Section that is included with the download. For instance, what event handlers is used and what SQL statement is used when updating or deleting an occurance. I am using the DataSource property.
0
Inge Wandsvik
Top achievements
Rank 1
Rank 1
answered on 03 Jun 2008, 01:02 PM
Never mind. I found out i dont need to do nothing... The control does all the stuff itself :-) Very nice!!
Case Closed
Case Closed