public JsonResult SaveUrlaub(Events e) { var status = false; using (EventsEntities dc = new EventsEntities()) { 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.ThemeColor = e.ThemeColor; } } else { dc.Events.Add(e); } dc.SaveChanges(); SendVerificationLinkEmail(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult SaveEvent(Events a) { var status = false; using (EventsEntities db = new EventsEntities()) { if (a.EventId > 0) { var evnt = db.Events.Where(b => b.EventId == a.EventId).FirstOrDefault(); if (evnt != null) { evnt.EventName = a.EventName; evnt.StartTime = a.StartTime; evnt.EndTime = a.EndTime; } } else { db.Events.Add(a); } db.SaveChanges(); status = true; } return(new JsonResult { Data = new { status } }); }
public JsonResult GetUrlaubs() { using (EventsEntities dc = new EventsEntities()) { var urlaubs = dc.Events.ToList(); return(new JsonResult { Data = urlaubs, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
/// <summary> /// Load Events /// </summary> /// <returns></returns> public JsonResult GetEvents() { using (EventsEntities db = new EventsEntities()) { var data = db.Events.ToList(); return(new JsonResult { Data = data, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public frmNewEdit(EventsTable obj) { InitializeComponent(); db = new EventsEntities(); if (obj == null) { eventsTableBindingSource.DataSource = new EventsTable(); db.EventsTable.Add(eventsTableBindingSource.Current as EventsTable); } else { eventsTableBindingSource.DataSource = obj; db.EventsTable.Attach(eventsTableBindingSource.Current as EventsTable); } }
public JsonResult DeleteEvent(int eventId) { var status = false; using (EventsEntities db = new EventsEntities()) { var ev = db.Events.Where(a => a.EventId == eventId).FirstOrDefault(); if (ev != null) { db.Events.Remove(ev); db.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status } }); }
public JsonResult DeleteUrlaub(int EventID) { /// <summary> /// Implements the DeleteEvent method. /// </summary> /// <returns>Memeful Comments</returns> /// <image url="https://media.giphy.com/media/Ca7gy6EZqdH32/giphy.gif" scale="0.3" /> var status = false; using (EventsEntities dc = new EventsEntities()) { 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 } }); }
// set all records in the table( closest date first and so on) // used when opening the app // also used for date filtering in filter buttons region private void RefreshEvents() { db = new EventsEntities(); eventsTableBindingSource.DataSource = db.EventsTable.OrderBy(d => d.Date).ToList(); }
public StatusController() { _db = new EventsEntities(); }
public FirstPageController() { _db = new EventsEntities(); }