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