Schedule Appointment mismatch with database

[Campbell Wray]

Hi,

I am currently using a Syncfusion Schedule to add events to a database. 

When I create a new appointment the Schedule sends an CRUD request to an MVC Controller on my sever.

The Schedule includes a "dId" field, which is used as an identifier for the appointment

The MVC Controller then creates an "appointment" and adds it to the database, however because the dId field is not necessarily unique (multiple users could be sending requests at any given time) the server chooses a new, unique, ID for the appointment.

On the client-end the scheduler then adds an appointment, however it uses the dId that it initially sent to the server.

If the user then deletes or edits this appointment (without refreshing the page) the server will be unable to find the dId, as the appointment in the database has a completely different ID.

What is the recommended method for resolving this?

I have tried to send the database ID back to the scheduler (as a response to the CRUD request), however I cannot find a way to do anything with this information client-side.

Also the scheduler doesn't wait for this response before creating the client-side appointment, so even if I was able to add a custom response handler it would be too late, as the event would have already been added.

Thanks,

Campbell

[Vinitha Devi Murugan]

Hi Campbell, 

 

Thanks for your patience. 

 

In Scheduler, Id field is mandatory and should be unique. We request you to follow any one of the below methods to perform CRUD actions correctly. 

 

1. In the below sample, Id field is used as auto increment.

http://www.syncfusion.com/downloads/support/forum/143608/ze/Autoincrement1109701655​​​​​​​ 

 

 

 

Controller.cs 

if (param.action == "insert" || (param.action == "batch" && param.added != null))          // this block of code will execute while inserting the appointments 

            { 

                var value = param.action == "insert" ? param.value : param.added[0]; 

                DateTime startTime = Convert.ToDateTime(value.StartTime); 

                DateTime endTime = Convert.ToDateTime(value.EndTime); 

                var currentTimeZone = TimeZone.CurrentTimeZone; 

                Appointment appoint = new Appointment() 

                { 

                    StartTime = startTime, 

                    EndTime = endTime, 

                    Subject = value.Subject, 

                    Description = value.Description, 

                    Recurrence = value.Recurrence, 

                    AllDay = value.AllDay, 

                    RecurrenceRule = value.RecurrenceRule, 

                }; 

                db.Appointments.InsertOnSubmit(appoint); 

                db.SubmitChanges(); 

            } 

 

 

2. In the below sample, Id field is used as normal field and only unique value is assigned.

  http://www.syncfusion.com/downloads/support/forum/143608/ze/ScheduleCRUD1028455407​​​​​​​  

Controller.cs 

if (param.action == "insert" || (param.action == "batch" && param.added != null))          // this block of code will execute while inserting the appointments 

            { 

                var value = param.action == "insert" ? param.value : param.added[0]; 

                //int intMax = db.Appointments.ToList().Count > 0 ? db.Appointments.ToList().Max(p => p.Id) : 1; 

                DateTime startTime = Convert.ToDateTime(value.StartTime); 

                DateTime endTime = Convert.ToDateTime(value.EndTime); 

                var currentTimeZone = TimeZone.CurrentTimeZone; 

                Appointment appoint = new Appointment() 

                { 

                    Id = value.Id, 

                    StartTime = startTime, 

                    EndTime = endTime, 

                    Subject = value.Subject, 

                    Description = value.Description, 

                    Recurrence = value.Recurrence, 

                    AllDay = value.AllDay, 

                    RecurrenceRule = value.RecurrenceRule, 

                }; 

                db.Appointments.InsertOnSubmit(appoint); 

                db.SubmitChanges(); 

            } 

 

 

 

Regards, 

M.Vinitha devi. 

 

[Campbell Wray]

Hi Vinitha,

Number 1 is exactly how I am doing it now, however the JSON returned by: 

return Json(data, JsonRequestBehavior.AllowGet);

Doesn't actually get handled by the Schedule, in my application it just ignores the response.

Is there some sort of configuration needed to make this happen?

Here is my code:

    @(Html.EJ().Schedule("Schedule1")

                                    .Width("100%")

                                    .Height("525px")

                                    .CurrentDate(DateTime.Today)

                                    .EnableLoadOnDemand(true)

                                    .ShowTimeZoneFields(false)

                                    .CurrentView(CurrentView.Agenda)

                                    .AgendaViewSettings(a => a.DaysInAgenda(365))

                                    .AppointmentSettings(fields => fields.Datasource(ds => ds.URL("/Calendar/GetCalendar").CrudURL("/Calendar/CrudResult").Adaptor(AdaptorType.UrlAdaptor))

                                            .Id("dId")

                                            .Subject("dName")

                                            .StartTime("startTime")

                                            .EndTime("endTime")

                                            .Description("descr")

                                            .AllDay("isAllDay")

                                            .Recurrence("recurs")

                                            .RecurrenceRule("recurrenceRule")

                                            .ApplyTimeOffset(false)

                                            .Categorize("categorize")

                                        )

                                    

    )

Thanks,

Campbell

[Karthigeyan Krishnamurthi]

Hi Campbell,  

 

Thanks for your update. 

 

In our previous auto id increment sample, appointments are shown both at initial load and after the CRUD action. We suspect that field mapping mismatch could be the cause for the issue, kindly share the below details to proceed further. 

 

1. DB fields information.
2. The data collection information.
3. Controller code example.

 

Note: There is no specific configuration, to display the appointments in Scheduler for auto id increment sample. 

 

Regards, 

Karthi 

[Campbell Wray]

Hi Vinitha,

Thanks for the last message, just letting you know that I did eventually manage to solve this. I am not sure exactly what the cause was but I ended up stripping out all of the extra client-side events and re-added them until things started to break.

Thanks,

Campbell

[Karthigeyan Krishnamurthi]

Hi Campbell, 

 

We are happy to hear that issue has been resolved at your end. 

 

Regards, 

Karthi