public ActionResult Create()
{
ViewBag.Employees = db.Employees.Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber });
ViewBag.Grievances = db.GrievanceTypes.Select(p => new { p.Code, p.Description });
ViewBag.EmployeeNumber = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.OffenderCode = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.GrievanceCode = new SelectList(db.GrievanceTypes, "Code", "Description");
var model = new GrievanceReport();
model.No = "GR" + (db.GrievanceReports.Count() + 1);
model.DateCreated = DateTime.UtcNow;
model.DateApproved = DateTime.UtcNow;
return(View(model));
}
public ActionResult Create(GrievanceReport model)
{
if (model.EmployeeNumber == "?" || model.OffenderCode == "?")
{
ViewBag.Employees = db.Employees.Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber });
ViewBag.Grievances = db.GrievanceTypes.Select(p => new { p.Code, p.Description });
ViewBag.EmployeeNumber = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.OffenderCode = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.GrievanceCode = new SelectList(db.GrievanceTypes, "Code", "Description");
ViewBag.Error = "Please Fill Missing Field(s)";
if (model.EmployeeNumber == "")
{
ModelState.AddModelError("EmployeeNumber", "Choose a Valid Employee Number");
}
if (model.OffenderCode == "")
{
ModelState.AddModelError("EmployeeNumber", "Choose a Valid Employee Number");
}
return(View(model));
}
if (model.GrievanceCode == "?")
{
ViewBag.Employees = db.Employees.Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber });
ViewBag.Grievances = db.GrievanceTypes.Select(p => new { p.Code, p.Description });
ViewBag.EmployeeNumber = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.OffenderCode = new SelectList(db.Employees, "EmployeeNumber", "EmployeeNumber");
ViewBag.GrievanceCode = new SelectList(db.GrievanceTypes, "Code", "Description");
ViewBag.Error = "Please Fill Missing Field(s)";
ModelState.AddModelError("GrievanceCode", "Choose a Valid Grievance Type");
return(View(model));
}
try
{
if (ModelState.IsValid)
{
db.GrievanceReports.Add(model);
db.SaveChanges();
return(RedirectToAction("Grievance/All", "Complaint"));
}
ViewBag.Error = "Incomplete Form! Please Fill All Fields Appropriately";
return(RedirectToAction("Grievance/Create", "Complaint"));
}
catch
{
return(View(model));
}
}
public ActionResult ManageGrievance(string id, GrievanceReport model)
{
var modeldb = db.GrievanceReports.Where(x => x.No == id).First();
if (model.IsApproved && !modeldb.IsApproved)
{
modeldb.IsApproved = true;
modeldb.DateApproved = DateTime.UtcNow;
db.SaveChanges();
}
if (model.IsClosed && !modeldb.IsClosed)
{
modeldb.IsClosed = true;
db.SaveChanges();
}
//var model = db.GrievanceReports.Where(x => x.No == id).First();
return(View(modeldb));
}
