This is a migrated thread and some comments may be shown as answers.

[Solved] Inserting with custom data source

5 Answers 231 Views

Scheduler

This is a migrated thread and some comments may be shown as answers.

5 Answers, 1 is accepted

answered on 27 May 2008, 02:23 PM

Hello,
I have defined just the "Insert" routine in my custom data source and found out something interesting. If I open the advanced edit dialog (either on a new or existing record), and then click on "Insert" (or "Update"), the corresponding routines in my datasource are never called. However, if I pick an existing appointment and drag-and-drop it to a new date, then the "Update" routine is executed. Since by default it's implemented to throw an exception, that's what it does but that's fine with me.
So, is there anything special I need to do when I use the advanced dialog?

Here's the source for the definition of the RadScheduler control:

telerik:radscheduler id="RadScheduler1" runat="server" skin="Outlook" OverflowBehavior="Expand" OnClientAppointmentContextMenu="appointmentContextMenu"
DataKeyField="ID" DataEndField = "End" DataRecurrenceField = "RecurrenceRule" DataRecurrenceParentKeyField = "RecurrenceParentID" DataStartField = "Start" DataSubjectField = "Subject" StartInsertingInAdvancedForm="true" StartEditingInAdvancedForm="true" ><AppointmentTemplate><div style="background-color:Aqua"><%# Eval("Subject") %><asp:Image ID="harmonyIcon" runat="server" /></div> </AppointmentTemplate>
</telerik:radscheduler>

answered on 29 May 2008, 01:40 PM

Hello Tsvetomir,

We defined the custome datasource as follows:
(This is in Page_Load)

MyDbSchedulerProvider schedulerProvider = new MyDbSchedulerProvider();

RadScheduler1.Provider = schedulerProvider;

RadScheduler1.Rebind();

Here is the code for MyDbSchedulerProvider:

public

class MyDbSchedulerProvider : DbSchedulerProviderBase

{

public override void Delete(RadScheduler owner, Appointment appointmentToDelete)

{

throw new System.Exception("The method or operation is not implemented.");

}

// loading appointments

public override IEnumerable<Appointment> GetAppointments(RadScheduler owner)

{

List<Appointment> appointments = new List<Appointment>();

Database db = Harmony.Data.DataFactoryBase.GetHarmonyDatabase();

DBCommandWrapper dbCommandWrapper = db.GetStoredProcCommandWrapper("p_WH_AppointmentListFetch");