// GET: MaintanenceComplaint/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } int quoteint = (int)id; complaint complaint = db.complaint.Find(id); ViewBag.StatusList = GetStatus(); int sessionControl = Convert.ToInt32(HttpContext.Session["UserDatabaseID"]); ComplaintHistoryModel model = new ComplaintHistoryModel() { CompID = quoteint, CategoryUser = sessionControl, }; if (complaint == null) { return(HttpNotFound()); } ViewBag.FK_CATEGORY_ID = new SelectList(db.category, "ID", "CATEGORY_NAME", complaint.FK_CATEGORY_ID); ViewBag.FK_ITEM_ID = new SelectList(db.item, "ID", "ITEM_NAME", complaint.FK_ITEM_ID); ViewBag.FK_Location_ID = new SelectList(db.location, "ID", "ROOM_ID", complaint.FK_Location_ID); ViewBag.FK_USER_ID = new SelectList(db.user, "ID", "FIRST_NAME", complaint.FK_USER_ID); return(View(model)); }
// GET: MaintanenceComplaint/Create public ActionResult Create(int?id) { var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]); if (SessionControl != 7) { TempData["warning"] = "Un Authorized Action"; return(RedirectToAction("Index", "Home")); } int sessionControl = Convert.ToInt32(HttpContext.Session["UserDatabaseID"]); complaint model = db.complaint.Find(id); ComplaintHistoryModel cmhmodel = new ComplaintHistoryModel() { CategoryID = model.FK_CATEGORY_ID, CompID = model.ID, CategoryUser = sessionControl, }; var query = db.complaint_history.Distinct().Select(x => x.STATUS); ViewBag.StatusList = GetStatus(); var categoryList = db.category.ToList(); ViewBag.FK_CATEGORY_ID = categoryList; var types = new List <ComplaintHistoryStatus>(); types.Add(new ComplaintHistoryStatus() { Id = 0, ComplaintStatus = "On Progress" }); types.Add(new ComplaintHistoryStatus() { Id = 1, ComplaintStatus = "Solved" }); types.Add(new ComplaintHistoryStatus() { Id = 2, ComplaintStatus = "UnSolved" }); ViewBag.PartialTypes = types; return(View(cmhmodel)); }
public ActionResult Edit(ComplaintHistoryModel model, int?id) { return(View(model)); }
public ActionResult Create(ComplaintHistoryModel model, int?id) { // complaint status string statusc = ""; int sessionControl = Convert.ToInt32(HttpContext.Session["UserDatabaseID"]); complaint_history comphist = new complaint_history(); int quote = (int)id; complaint complaint = db.complaint.Find(id); if (model != null) { try { if (Convert.ToInt32(model.Status) == 0) { comphist.STATUS = statusc = "On Progress".Trim().ToUpper(); } if (Convert.ToInt32(model.Status) == 1) { comphist.STATUS = statusc = "SOLVED".Trim().ToUpper(); } else if (Convert.ToInt32(model.Status) == 2) { comphist.STATUS = statusc = "UNSOLVED".Trim().ToUpper(); } comphist.MODIFIED_TIME = DateTime.Now; comphist.COMMENT = model.Comment; comphist.FK_CATEGORYUSER_ID = sessionControl; comphist.FK_COMPLAINT_ID = quote; comphist.FK_CATEGORY_ID = model.CategoryID; db.complaint_history.Add(comphist); db.SaveChanges(); if (Convert.ToInt32(model.Status) == 0) { complaint.STATUS = statusc = "ON PROGRESS".Trim().ToUpper(); } if (Convert.ToInt32(model.Status) == 1) { complaint.STATUS = statusc = "SOLVED".Trim().ToUpper(); } else if (Convert.ToInt32(model.Status) == 2) { complaint.STATUS = statusc = "UNSOLVED".Trim().ToUpper(); } db.complaint.Attach(complaint); var entry = db.Entry(complaint); entry.Property(x => x.STATUS).IsModified = true; db.SaveChanges(); TempData["Info"] = "Complaint " + comphist.ID + " of status successfuly changed to " + comphist.STATUS; return(RedirectToAction("Index")); } catch { TempData["error"] = "Error occured while modifying complaint"; return(View(model)); } } var types = new List <ComplaintHistoryStatus>(); types.Add(new ComplaintHistoryStatus() { Id = 0, ComplaintStatus = "On Progress" }); types.Add(new ComplaintHistoryStatus() { Id = 1, ComplaintStatus = "Solved" }); types.Add(new ComplaintHistoryStatus() { Id = 2, ComplaintStatus = "UnSolved" }); ViewBag.PartialTypes = types; ViewBag.FK_CATEGORY_ID = new SelectList(db.category, "ID", "CATEGORY_NAME", complaint.FK_CATEGORY_ID); return(View(model)); }