public ActionResult Modify([Bind(Prefix = "")] Models.EquipmentRepairRequest model) { var db = new CodeFirst.CodeFirst(); if (ModelState.IsValid) { var request = db.Repair_Request.Where(v => v.RequestID == model.RequestID).SingleOrDefault(); if (request != null) { request.RequestID = model.RequestID; request.Approved = model.Approved; request.Repaired = model.Repaired; request.Reason = model.Reason; request.EquipmentID = model.EquipmentID; request.RepPersonID = model.RepPersonID; db.SaveChanges(); } TempData["js"] = "myUpdateSuccess()"; return(RedirectToAction("Index", "EquipmentRepairRequests")); } model.repairPeople = db.RepairPersons.ToList(); return(View("Index", model)); }
// GET: AddRepairRequest public ActionResult Index(string equipmentID) { var db = new CodeFirst.CodeFirst(); var requests = new Models.EquipmentRepairRequest(); requests.EquipmentID = Int32.Parse(equipmentID); requests.repairPeople = db.RepairPersons.ToList(); return(View(requests)); }
// GET: EquipmentRepairRequests public ActionResult Index() { Models.EquipmentRepairRequest myModel = new Models.EquipmentRepairRequest(); if (TempData["model"] != null) { myModel = (Models.EquipmentRepairRequest)TempData["model"]; TempData.Remove("model"); } return(View(myModel)); }
public ActionResult Create([Bind(Prefix = "")] Models.EquipmentRepairRequest model) { var db = new CodeFirst.CodeFirst(); if (ModelState.IsValid) { if (db.Repair_Request.Count() > 0) { var item = db.Repair_Request.OrderByDescending(a => a.RequestID).FirstOrDefault(); db.Repair_Request.Add(new CodeFirst.Repair_Request { RequestID = item.RequestID + 1, Approved = false, Repaired = false, Reason = model.Reason, EquipmentID = model.EquipmentID, RepPersonID = model.RepPersonID }); } else { db.Repair_Request.Add(new CodeFirst.Repair_Request { RequestID = 1, Approved = false, Repaired = false, Reason = model.Reason, EquipmentID = model.EquipmentID, RepPersonID = model.RepPersonID }); } db.SaveChanges(); model.JavaScriptToRun = "mySuccess()"; TempData["model"] = model; return(RedirectToAction("Index", "EquipmentRepairRequests")); } model.repairPeople = db.RepairPersons.ToList(); return(View("Index", model)); }
// GET: ModifyEquipmentRepairRequest public ActionResult Index(string requestID) { CodeFirst.CodeFirst db = new CodeFirst.CodeFirst(); Models.EquipmentRepairRequest myModel = new Models.EquipmentRepairRequest(); if (requestID != null) { var intRequestID = Int32.Parse(requestID); var myRequest = db.Repair_Request.Where(i => i.RequestID == intRequestID).FirstOrDefault(); myModel.RequestID = myRequest.RequestID; myModel.Approved = myRequest.Approved; myModel.Repaired = myRequest.Repaired; myModel.Reason = myRequest.Reason; myModel.EquipmentID = myRequest.EquipmentID; myModel.RepPersonID = myRequest.RepPersonID; myModel.repairPeople = db.RepairPersons.ToList(); return(View(myModel)); } myModel.repairPeople = db.RepairPersons.ToList(); return(View(myModel)); }
// GET: EquipmentRepairRequestDetails public ActionResult Index(string requestID) { Models.EquipmentRepairRequest myModel = new Models.EquipmentRepairRequest(); CodeFirst.CodeFirst db = new CodeFirst.CodeFirst(); if (requestID != null) { var intRequestID = Int32.Parse(requestID); var myRequest = db.Repair_Request.Where(r => r.RequestID == intRequestID).FirstOrDefault(); var myEquipment = db.Equipments.Where(e => e.EquipmentID == myRequest.EquipmentID).FirstOrDefault(); var myPerson = db.RepairPersons.Where(rp => rp.RepPersonID == myRequest.RepPersonID).FirstOrDefault(); myModel.RequestID = myRequest.RequestID; myModel.Approved = myRequest.Approved; myModel.Repaired = myRequest.Repaired; myModel.Reason = myRequest.Reason; myModel.EquipmentID = myRequest.EquipmentID; myModel.EquipmentName = myEquipment.ManufacturerName + " " + myEquipment.ModelNumber; myModel.RepPersonID = myRequest.RepPersonID; myModel.RepairPersonName = myPerson.Name; } myModel.repairPeople = db.RepairPersons.ToList(); return(View(myModel)); }