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();
}
