//gets events from the database as a JSONResult
public JsonResult GetEvents()
{
using (EventDBEntities1 dc = new EventDBEntities1())
{
var events = dc.Events.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult SaveEvent(Event evnt)
{
var status = false;
using (EventDBEntities1 dc = new EventDBEntities1())
{
//this runs if you are updating an event instead of adding a new event
if (evnt.EventId > 0)
{
//Update the event
var temp = dc.Events.Where(a => a.EventId == evnt.EventId).FirstOrDefault();
if (temp != null)
{
temp.endTime = evnt.endTime;
temp.IsFullDay = evnt.IsFullDay;
temp.Organization = evnt.Organization;
temp.Organization_Division = evnt.Organization_Division;
temp.Requestor = evnt.Requestor;
temp.Purpose = evnt.Purpose;
temp.Tentative = evnt.Tentative;
if (temp.Tentative == null)
{
temp.Tentative = false;
}
// temp.requestorDepartment = evnt.requestorDepartment;
// temp.requestorPhone = evnt.requestorPhone;
temp.start = evnt.start;
temp.ThemeColor = evnt.ThemeColor;
}
}
else
{
evnt.Tentative = false;
dc.Events.Add(evnt);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult
{
Data = new { status = status }
});
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (EventDBEntities1 dc = new EventDBEntities1())
{
var temp = dc.Events.Where(a => a.EventId == eventID).FirstOrDefault();
if (temp != null)
{
dc.Events.Remove(temp);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult
{
Data = new { status = status }
});
}
