I am debugging the reason for my schedule not saving to the table record, i will share my code below. What could be the reason for this? Problem is on the Controller on this method
[HttpPost]
public JsonResult eNtsaUpdateEventsDetails(EditParams param)
{
// this condition for update from the events on the calendar.
if(param.action == "insert" || (param.action == "batch" && param.added != null))
{
var events = (param.action == "insert") ? param.events : param.added[0];
DateTime startTime = Convert.ToDateTime(events.StartTime);
DateTime endTime = Convert.ToDateTime(events.EndTime);
eNtsaCalendarEvents eNtsaCalendar = new eNtsaCalendarEvents
{
ID = Guid.NewGuid(),
StartTime = startTime.ToLocalTime(),
EndTime = endTime.ToLocalTime(),
Subject = events.Subject,
IsAllDay = events.IsAllDay,
StartTimeZone = events.StartTimeZone,
EndTimeZone = events.EndTimeZone,
RecurrenceRule = events.RecurrenceRule,
RecurrenceException = events.RecurrenceException,
ConferenceId = events.ConferenceId
};
//cb.Events.Include(eNtsaCalendar);
cb.SaveChanges();
}
if(param.action == "update" || (param.action == "batch" && param.changed != null))
{
var myevent = (param.action == "update") ? param.events : param.added[0];
var filterData = cb.Events.Where(b => b.ID == myevent.ID);
if(filterData.Count() > 0)
{
DateTime startTime = Convert.ToDateTime(myevent.StartTime);
DateTime endTime = Convert.ToDateTime(myevent.EndTime);
eNtsaCalendarEvents eNtsaCalendar = cb.Events.Single(A=>A.ID == (myevent.ID));
eNtsaCalendar.StartTime = startTime.ToLocalTime();
eNtsaCalendar.EndTime = endTime.ToLocalTime();
eNtsaCalendar.EndTimeZone = myevent.EndTimeZone;
eNtsaCalendar.StartTimeZone = myevent.StartTimeZone;
eNtsaCalendar.Subject = myevent.Subject;
eNtsaCalendar.IsAllDay = myevent.IsAllDay;
eNtsaCalendar.RecurrenceRule = myevent.RecurrenceRule;
eNtsaCalendar.RecurrenceException = myevent.RecurrenceException;
eNtsaCalendar.ConferenceId = myevent.ConferenceId;
}
cb.SaveChanges();
}
if(param.action == "remove" || (param.action == "batch" && param.deleted != null))
{
if(param.action == "remove")
{
eNtsaCalendarEvents eNtsaCalendar = cb.Events.Where(c => c.ID == Guid.Parse(param.key)).FirstOrDefault();
//if (eNtsaCalendar != null) cb.Events.DeleteOnSubmit(eNtsaCalendar);
}
else
{
foreach (var apps in param.deleted)
{
eNtsaCalendarEvents eNtsaCalendar = cb.Events.Where(c => c.ID == apps.ID).FirstOrDefault();
//if (apps != null) cb.Events.DeleteOnSubmit(eNtsaCalendar);
}
}
cb.SubmitChanges(); // Does submit but not saving any event to the table record.
}
var eNtsaData = cb.Events.ToList();
return Json(eNtsaData, JsonRequestBehavior.AllowGet); // Return as empty list.
}