コード例 #1
0
        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"));
            }
        }
コード例 #2
0
        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);
            }
        }