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