public ActionResult DeleteConfirmed(int id) { ass_reminder ass_reminder = db.ass_reminder.Find(id); db.ass_reminder.Remove(ass_reminder); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: AssMtReminder/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ass_reminder ass_reminder = db.ass_reminder.Find(id); if (ass_reminder == null) { return(HttpNotFound()); } return(View(ass_reminder)); }
// GET: AssMtReminder/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ass_reminder ass_reminder = db.ass_reminder.Find(id); if (ass_reminder == null) { return(HttpNotFound()); } ass_reminder.isOnlyMe = ass_reminder.getIsOnlyMe; return(View(ass_reminder)); }
public ActionResult ReminderUnit(int remId) { ass_reminder reminder = db.ass_reminder .Where(a => a.id == remId) .FirstOrDefault(); List <ass_complaint_dtl> dtlLs = db.ass_complaint_dtl .Where(a => a.curr_status_id == null || !a.ass_status.name.Contains("CLOSED")) .ToList(); List <ViewReminderUnitProgress> result = new List <ViewReminderUnitProgress>(); if (reminder.start_day == null) { dtlLs = dtlLs.Where(a => a.dueDateDiff <= reminder.end_day).ToList(); } else if (reminder.end_day == null) { dtlLs = dtlLs.Where(a => a.dueDateDiff >= reminder.start_day).ToList(); } else { dtlLs = dtlLs.Where(a => a.dueDateDiff >= reminder.start_day && a.dueDateDiff <= reminder.end_day).ToList(); } result = dtlLs .GroupBy(a => new { entCd = a.ass_complaint.entity_cd, projectNo = a.ass_complaint.project_no, lotNo = a.ass_complaint.lot_no }) .Select(a => new ViewReminderUnitProgress { progrssId = remId, progressName = reminder.descs, entCd = a.Key.entCd, projectNo = a.Key.projectNo, lotNo = a.Key.lotNo, checkDate = a.OrderBy(x => x.ass_complaint.check_date).FirstOrDefault().ass_complaint.check_date, countProgress = a.Count() }).ToList(); return(View("ReminderUnitProgress", result)); }
public ActionResult Edit([Bind(Include = "id,descs,clases,start_day,end_day,isOnlyMe")] ass_reminder ass_reminder) { if (ModelState.IsValid) { ass_reminder.audit_date = DateTime.Now; ass_reminder.user_id = int.Parse(User.Identity.Name); if (ass_reminder.isOnlyMe) { ass_reminder.owner_user = int.Parse(User.Identity.Name); } else { ass_reminder.owner_user = null; } db.Entry(ass_reminder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ass_reminder)); }