public JsonResult UpdatePlan(AcPlanViewModel plan)
{
AcPlanEntry entry = db.AcPlanEntries.FirstOrDefault(x => x.TeamId == plan.TeamId && x.Date.Id == plan.DateId);
if (entry != null) {
entry.Activity = plan.Activity;
entry.Remember = plan.Remember;
} else {
entry = new AcPlanEntry {
Date = db.AcDates.Find(plan.DateId),
TeamId = plan.TeamId,
Activity = plan.Activity,
Remember = plan.Remember
};
db.AcPlanEntries.Add(entry);
}
db.SaveChanges();
return Json(new { success = true });
}
public JsonResult GetAcPlan([DataSourceRequest] DataSourceRequest request, int teamId)
{
List<AcDate> dates = db.AcDates.Where(x => x.Date >= DateTime.Today).OrderBy(x => x.Date).ToList();
List<AcPlanViewModel> list = new List<AcPlanViewModel>();
foreach (AcDate date in dates) {
AcPlanViewModel vm = new AcPlanViewModel {
TeamId = teamId,
Date = date.Date,
DateId = date.Id
};
AcPlanEntry entry = db.AcPlanEntries.FirstOrDefault(x => x.TeamId == teamId && x.Date.Date == date.Date);
if (entry != null) {
vm.Activity = entry.Activity;
vm.Remember = entry.Remember;
}
list.Add(vm);
}
return Json(list.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
private AcPlanViewModel GetNextActivity(int teamId)
{
AcDate date = db.AcDates.Where(x => x.Date >= DateTime.Today).OrderBy(x => x.Date).FirstOrDefault();
if (date == null)
return null;
AcPlanEntry entry = db.AcPlanEntries.Where(x => x.Date.Date == date.Date && x.TeamId == teamId).FirstOrDefault();
AcPlanViewModel m = new AcPlanViewModel { Date = date.Date };
if (entry != null) {
m.Activity = entry.Activity;
m.Remember = entry.Remember;
}
return m;
}