public JsonResult Projects()
{
using (TaskTimerDbContext context = new TaskTimerDbContext())
{
return(Json(context.Projects.ToList(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult EventHistory()
{
using (TaskTimerDbContext context = new TaskTimerDbContext())
{
var vrlEvents = (from vrlEvent in context.Events
where vrlEvent.FinishDate != null
select new { StartDate = vrlEvent.StartDate, FinishDate = vrlEvent.FinishDate, vrlEvent.Id, vrlEvent.Description }).
ToList();
return(Json(vrlEvents, JsonRequestBehavior.AllowGet));
}
}
public JsonResult CurrenEvent()
{
using (TaskTimerDbContext context = new TaskTimerDbContext())
{
var vrlEvents = (from vrlEvent in context.Events
where vrlEvent.FinishDate == null
select new { StartDate = vrlEvent.StartDate, FinishDate = vrlEvent.FinishDate, vrlEvent.Id, vrlEvent.Description }).
ToList();
var vrlLastNotFinishedTask = vrlEvents.LastOrDefault();
return(Json(vrlLastNotFinishedTask, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Events(Event newEvent)
{
using (TaskTimerDbContext context = new TaskTimerDbContext())
{
if (newEvent.Id > 0)
{
context.Events.Attach(newEvent);
context.ChangeTracker.DetectChanges();
context.Entry(newEvent).State = EntityState.Modified;
context.SaveChanges();
}
else
{
context.Events.Add(newEvent);
context.SaveChanges();
}
return(Json(newEvent.Id));
}
}
