private SACAAEContext db = new SACAAEContext(); // Database context #endregion Fields #region Methods // GET: Alerts public ActionResult Index() { var today = DateTime.Now; today.AddDays(1); var viewModel = new AlertViewModel() { Commissions = db.Commissions.Where(p => p.End < today && p.State.Name == "En proceso").ToList(), Projects = db.Projects.Where(p => p.End < today && p.State.Name == "En proceso").ToList() }; if ((viewModel.Commissions.Count + viewModel.Projects.Count) == 0) { Request.Cookies["alerts"].Value = "false"; Response.Cookies["alerts"].Value = "false"; } return View(viewModel); }
public ActionResult ResolveProjects(AlertViewModel viewModel) { if (ModelState.IsValid) { for (int i = 0; i < viewModel.Projects.Count; i++) { var project = db.Projects.Find(viewModel.Projects[i].ID); db.Entry(project).Property(c => c.StateID).CurrentValue = 2; db.SaveChanges(); if (project.ProjectsXProfessors.Count > 0) { var projectProfessors = project.ProjectsXProfessors.ToList(); foreach (var projectProfessor in projectProfessors) { db.ProjectsXProfessors.Remove(projectProfessor); db.SaveChanges(); } } } } return RedirectToAction("Index"); }
public ActionResult ResolveCommissions(AlertViewModel viewModel) { if (ModelState.IsValid) { for (int i = 0; i < viewModel.Commissions.Count; i++) { var commission = db.Commissions.Find(viewModel.Commissions[i].ID); db.Entry(commission).Property(c => c.StateID).CurrentValue = 2; db.SaveChanges(); if (commission.CommissionsXProfessors.Count > 0) { var commissionProfessors = commission.CommissionsXProfessors.ToList(); foreach (var commissionProfessor in commissionProfessors) { db.CommissionsXProfessors.Remove(commissionProfessor); db.SaveChanges(); } } } } return RedirectToAction("Index"); }