public JsonResult DeleteEvent(Table t)
{
var status = false;
//System.Diagnostics.Debug.WriteLine("event ID to delete is: "+ e.EventID);
try
{
using (var ecm = new EventCalendarModel())
{
var entry = ecm.Tables.Where(e => e.EventID == t.EventID).FirstOrDefault();
if (entry != null)
{
ecm.Tables.Remove(entry);
ecm.SaveChanges();
status = true;
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Delete exception message is: " + ex.ToString());
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult SaveEvent(Table t)
{
var status = false;
try
{
using (EventCalendarModel ecm = new EventCalendarModel())
{
//System.Diagnostics.Debug.WriteLine("event id is: " + e.EventID);
// if >0, then this entry is already in our db
if (t.EventID > 0) // 0 is the default, which is not allowed in our db
{
//Update the event
var entry = ecm.Tables.Where(e => e.EventID == t.EventID).FirstOrDefault();
if (entry != null)
{
entry.Subject = t.Subject;
entry.Start = t.Start;
entry.End = t.End;
entry.Description = t.Description;
entry.EventColor = t.EventColor;
}
// else, something unexpected occured.
}
else
{
t.EventID = 1;
// if table is not empty
if (ecm.Tables.Any())
{
t.EventID = ecm.Tables.Max(e => e.EventID) + 1;
}
ecm.Tables.Add(t);
/* System.Diagnostics.Debug.WriteLine("start is: " + e.Start.ToString());
* System.Diagnostics.Debug.WriteLine("end is: " + e.End.ToString());*/
}
ecm.SaveChanges();
status = true;
}
}
catch (Exception ex) //Catch Other Exception
{
System.Diagnostics.Debug.WriteLine("Exception message is: " + ex.ToString());
}
return(new JsonResult {
Data = new { status = status }
});
}