Telerik RadScheduler With Database CRUD Internal

Telerik RadScheduler Logic

Update One of Recursive Appointments (Update to exclude date+Insert New)

exec sp_executesql N'update [dbo].[Appointments]
set [RecurrenceRule] = @0
where ([ID] = @1)
',N'@0 nvarchar(1024),@1 int',@0=N'DTSTART:20111101T063000Z
DTEND:20111101T073000Z
RRULE:FREQ=DAILY;UNTIL=20111120T210000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
EXDATE:20111116T063000Z,20111102T063000Z,20111101T063000Z,20111108T063000Z
',@1=5

exec sp_executesql N'insert [dbo].[Appointments]([Subject], [Description], [Start], [End], [RecurrenceRule], [RecurrenceParentID], [Reminder], [Annotations], [TestResourceId])
values (@0, @1, @2, @3, @4, @5, @6, null, @7)
select [ID]
from [dbo].[Appointments]
where @@ROWCOUNT > 0 and [ID] = scope_identity()',N'@0 nvarchar(255),@1 nvarchar(1024),@2 datetime2(7),@3 datetime2(7),@4 nvarchar(1024),@5 int,@6 nvarchar(255),@7 int',@0=N'DevMedia conference',@1=N'',@2='2011-10-30 06:30:00',@3='2011-10-30 07:30:00',@4=N'',@5=5,@6=N'',@7=3

Delete Appointment

exec sp_executesql N'delete [dbo].[Appointments]
where ([ID] = @0)',N'@0 int',@0=14

Update Appointment

exec sp_executesql N'update [dbo].[Appointments]
set [Subject] = @0, [RecurrenceRule] = @1
where ([ID] = @2)
',N'@0 nvarchar(255),@1 nvarchar(1024),@2 int',@0=N'DevMedia conference!!!!!!!!!!!!!!!!!!',@1=N'DTSTART:20111101T063000Z
DTEND:20111101T073000Z
RRULE:FREQ=DAILY;UNTIL=20111120T000000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
EXDATE:20111116T063000Z,20111102T063000Z,20111101T063000Z,20111108T063000Z
',@2=5

Dismiss normal appointment

exec sp_executesql N'update [dbo].[Appointments]
set [Reminder] = @0
where ([ID] = @1)
',N'@0 nvarchar(255),@1 int',@0=N'',@1=10

Dismiss One of Recursive Appointments  (Update to exclude date and Insert New)