public JsonResult SaveEvent(CALENDAR e) { var status = false; using (cyjdatabaseEntities dc = new cyjdatabaseEntities()) { if (e.eventID > 0) { //Update the event var v = dc.CALENDARs.Where(a => a.eventID == e.eventID).FirstOrDefault(); if (v != null) { v.eventHeader = e.eventHeader; v.eventStart = e.eventStart; v.eventEnd = e.eventEnd; v.eventDescription = e.eventDescription; } } else { dc.CALENDARs.Add(e); } dc.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult GetEvents() { using (cyjdatabaseEntities dc = new cyjdatabaseEntities()) { var events = dc.CALENDARs.ToList(); return(new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult DeleteEvent(int eventID) { var status = false; using (cyjdatabaseEntities dc = new cyjdatabaseEntities()) { var v = dc.CALENDARs.Where(a => a.eventID == eventID).FirstOrDefault(); if (v != null) { dc.CALENDARs.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public CategoryServices() { _dbContext = new cyjdatabaseEntities(); }
public WorkstreamServices() { _dbContext = new cyjdatabaseEntities(); }
public GoalServices() { _dbContext = new cyjdatabaseEntities(); }