public ActionResult InsertFirstResponderAnnotation(Event_Equipment_RootCauseModelView model, FormCollection collection) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { try { var result = UpdateMasterDowntimeTable(model.eventModelView.uniqueID); var annotation = new tbl_factMaintenanceAnnotations(); annotation.UniqueID = model.eventModelView.uniqueID; annotation.FailureTypeDescription = model.rootCauseModelView.contType; annotation.FailureDescription = model.rootCauseModelView.contRootCause; annotation.EquipmentType = model.equipModelView.equipType; annotation.EquipmentName = model.equipModelView.equipName; annotation.EquipmentNumber = model.equipModelView.equipNumber; annotation.ModifyStamp = DateTime.Now; db.tbl_factMaintenanceAnnotations.Add(annotation); db.SaveChanges(); } catch (Exception ex) { throw ex; } return(RedirectToAction("Events")); } }
public ActionResult SetFirstResponderPartial(string EventID, string Site) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { //ViewBag.equipTypeList = new SelectList(GetEquipmentTypeList(Site), "elementID", "equipType"); //ViewBag.contCategoryList = new SelectList(GetContributingDowntimeCategoryList(), "", "contCategory"); var dtEvent = db.tbl_factFailureDowntimeCMMS.SingleOrDefault(x => x.UniqueID == EventID); Event_Equipment_RootCauseModelView parent = new Event_Equipment_RootCauseModelView { eventModelView = new EventModelView(), equipModelView = new EquipmentModelView(), rootCauseModelView = new RootCauseModelView() }; parent.equipModelView.equipTypeList = new SelectList(GetEquipmentTypeList(Site), "", "equipType"); parent.rootCauseModelView.contCategoryList = new SelectList(GetContributingDowntimeCategoryList(), "", "contCategory"); parent.equipModelView.equipNumberList = new SelectList(""); parent.equipModelView.equipNameList = new SelectList(""); parent.rootCauseModelView.contTypeList = new SelectList(""); parent.rootCauseModelView.contRootCauseList = new SelectList(""); parent.eventModelView.uniqueID = dtEvent.UniqueID; parent.eventModelView.equipmentName = dtEvent.EquipmentName; parent.eventModelView.equipmentNumber = dtEvent.EquipmentNumber; parent.eventModelView.startTime = dtEvent.StartTime; parent.eventModelView.endTime = dtEvent.EndTime; parent.eventModelView.duration = dtEvent.Duration; parent.eventModelView.site = dtEvent.Site; return(PartialView("EventAndRootCausePartialGrid", parent)); } }
public List <RootCauseModelView> GetContributingDowntimeCategoryList() { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { List <RootCauseModelView> contDowntimeCategoryList = db.tbl_DimNonWorkOrderDowntimeAnnnotations.Select(x => new RootCauseModelView { contCategory = x.Category }).Distinct().ToList(); return(contDowntimeCategoryList); } }
//public ActionResult GetEquipmentNameList(string EquipmentNumber) //{ // using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) // { // List<EquipmentModelView> equipmentNameList = db.tbl_DimSiteEquipment.Where(x => x.EquipmentNumber== EquipmentNumber).Select(x => new EquipmentModelView { equipName = x.EquipmentName }).Distinct().ToList(); // //ViewBag.equipmentNameList = new SelectList(equipmentNameList, "equipNumber", "equipName"); // Event_Equipment_RootCauseModelView parent = new Event_Equipment_RootCauseModelView(); // parent.equipModelView = new EquipmentModelView(); // parent.equipModelView.equipNameList = new SelectList(equipmentNameList, "equipNumber", "equipName"); // return PartialView("EquipmentNamePartial"); // } //} public JsonResult GetEquipmentNameList(string EquipmentNumber) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { List <EquipmentModelView> equipmentNameList = db.tbl_DimSiteEquipment.Where(x => x.EquipmentNumber == EquipmentNumber).Select(x => new EquipmentModelView { equipName = x.EquipmentName }).Distinct().ToList(); return(Json(equipmentNameList, JsonRequestBehavior.AllowGet)); } }
public List <EquipmentModelView> GetEquipmentTypeList(string Site) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { List <EquipmentModelView> equipType = db.tbl_DimSiteEquipment.Where(x => x.Site == Site).Select(x => new EquipmentModelView { equipType = x.EquipmentType }).Distinct().ToList(); return(equipType); } }
public ActionResult GetEvents() //All the events which have not been escalated { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { List <EventModelView> dtList = db.tbl_factFailureDowntimeCMMS.Where(x => x.IsEscalated == false).OrderByDescending(x => x.StartTime).Select(x => new EventModelView { equipmentName = x.EquipmentName, startTime = x.StartTime, endTime = x.EndTime, duration = x.Duration, equipmentNumber = x.EquipmentNumber, site = x.Site, uniqueID = x.UniqueID }).ToList(); return(Json(new { data = dtList }, JsonRequestBehavior.AllowGet)); } }
public int UpdateMasterDowntimeTable(string uniqueId) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { try { var eventToUpdate = db.tbl_factFailureDowntimeCMMS.Find(uniqueId); db.SaveChanges(); } catch (Exception ex) { throw ex; } return(0); } }
public ActionResult GetContributingDowntimeRootCauseList(string ContDowntimeCategory, string ContDowntimeType) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { List <RootCauseModelView> contDowntimeRootCauseList = db.tbl_DimNonWorkOrderDowntimeAnnnotations.Where(x => x.Category == ContDowntimeCategory && x.DowntimeType == ContDowntimeType).Select(x => new RootCauseModelView { contRootCause = x.RootCause }).Distinct().ToList(); //ViewBag.contDowntimeRootCauseList = new SelectList(contDowntimeRootCauseList, "contCkey", "contRootCause"); //Event_Equipment_RootCauseModelView parent = new Event_Equipment_RootCauseModelView(); //parent.rootCauseModelView = new RootCauseModelView(); //parent.rootCauseModelView.contRootCauseList = new SelectList(contDowntimeRootCauseList, "", "contRootCause"); return(Json(contDowntimeRootCauseList, JsonRequestBehavior.AllowGet)); } }
public ActionResult SetWorkOrderPartial(string EventID, string Site) { using (MOMSEventFrameInterfaceEntities db = new MOMSEventFrameInterfaceEntities()) { Event_Equipment_RootCauseModelView parent = new Event_Equipment_RootCauseModelView(); ViewBag.equipTypeList = new SelectList(GetEquipmentTypeList(Site), "equipNumber", "equipType"); parent.eventModelView = new EventModelView(); tbl_factFailureDowntimeCMMS dtEvent = db.tbl_factFailureDowntimeCMMS.SingleOrDefault(x => x.UniqueID == EventID); parent.eventModelView.uniqueID = dtEvent.UniqueID; parent.eventModelView.equipmentName = dtEvent.EquipmentName; parent.eventModelView.equipmentNumber = dtEvent.EquipmentNumber; parent.eventModelView.startTime = dtEvent.StartTime; parent.eventModelView.endTime = dtEvent.EndTime; parent.eventModelView.duration = dtEvent.Duration; parent.eventModelView.site = dtEvent.Site; return(PartialView("AnnotationWorkOrderPartial", parent)); } }