public JsonResult GetAppointments() { // Return all the records from the Calendar in JSON format using (KnEntitiesDB dc = new KnEntitiesDB()) { var v = dc.CalendarEvents.OrderBy(a => a.StartDay).ToList(); return(new JsonResult { Data = v, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult CalendarDeleteAppointment(int eventID) { bool status = false; using (KnEntitiesDB dc = new KnEntitiesDB()) { var v = dc.CalendarEvents.Where(a => a.CalendarID.Equals(eventID)).FirstOrDefault(); if (v != null) { dc.CalendarEvents.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult CalendarSaveAppointment(CalendarEvent evt) { bool status = false; using (KnEntitiesDB dc = new KnEntitiesDB()) { if (evt.EndDay != null && evt.StartDay.TimeOfDay == new TimeSpan(0, 0, 0) && evt.EndDay.TimeOfDay == new TimeSpan(0, 0, 0)) { evt.isFullDay = true; } else { evt.isFullDay = false; } if (evt.CalendarID > 0) { var v = dc.CalendarEvents.Where(a => a.CalendarID.Equals(evt.CalendarID)).FirstOrDefault(); if (v != null) { v.CalendarTitle = evt.CalendarTitle; v.CalendarDesc = evt.CalendarDesc; v.StartDay = evt.StartDay; v.EndDay = evt.EndDay; v.isFullDay = evt.isFullDay; } } else { dc.CalendarEvents.Add(evt); } dc.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }