public JsonResult GetEvents() { using (CalendarAppDatabaseEntities1 context = new CalendarAppDatabaseEntities1()) { var events = context.Events.ToList(); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult DeleteEvent(int eventID) { var status = false; using (CalendarAppDatabaseEntities1 dc = new CalendarAppDatabaseEntities1()) { var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault(); if (v != null) { dc.Events.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status } }); }
public JsonResult SaveEvent(User user, Event e) { var status = false; using (CalendarAppDatabaseEntities1 context = new CalendarAppDatabaseEntities1()) { if (e.EventID > 0) { //Update the event var v = context.Events.Where(a => a.EventID == e.EventID).FirstOrDefault(); if (v != null) { v.Subject = e.Subject; v.Start = e.Start; v.End = e.End; v.Description = e.Description; v.IsFullDay = e.IsFullDay; v.ThemeColor = e.ThemeColor; } } else { context.Events.Add(e); } context.SaveChanges(); status = true; using (DBManager db = new DBManager()) { db.SaveChanges(); SendReminder(user.Email, e.Subject, e.Start); } } return(new JsonResult { Data = new { status } }); }