public ActionResult SaveEvent(Event e) { var status = false; using (ClassroomAllocationSystemEntities1 dc = new ClassroomAllocationSystemEntities1()) { if (e.EventID > 0) { //Update the event var v = dc.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.ClassRoomId = e.ClassRoomId; v.Employeeid = e.Employeeid; dc.SaveChanges(); status = true; } } else { var count = dc.ValidateBookingClassroom(e.Start, e.End, e.ClassRoomId).ToList(); int? save = count.FirstOrDefault(); Int32 insert = save.HasValue ? save.Value : 0; if (insert == 0) { dc.Events.Add(e); dc.SaveChanges(); status = true; } else { status = false; } } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult DeleteEvent(int eventID) { var status = false; using (ClassroomAllocationSystemEntities1 dc = new ClassroomAllocationSystemEntities1()) { 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 = status } }); }