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