public PCMDiversionViewModel GetUpdateDiversion_M(int mId) { PCMDiversionViewModel vm = new PCMDiversionViewModel(); using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { int?id = (from m in db.PCM_Diversion_M where (m.M_Id == mId) select m.M_Id).FirstOrDefault(); PCM_Diversion_M mm = db.PCM_Diversion_M.Find(id); if (mm != null) { vm.M_Id = db.PCM_Diversion_M.Find(mm.M_Id).M_Id; vm.P_Id = mm.P_Id; vm.Modules_Id = mm.Modules_Id; vm.No_Module = mm.No_Module; vm.Sessions = mm.Sessions; vm.No_Sessions = mm.No_Sessions; vm.Session_StartDate = mm.Session_StartDate; vm.Session_EndDate = mm.Session_EndDate; db.SaveChanges(); } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } return(vm); } }
public void UpdateDiversion_M(PCMDiversionViewModel vm, int mId) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion_M mm = db.PCM_Diversion_M.Find(mId); mm.P_Id = vm.P_Id; mm.Modules_Id = vm.Modules_Id; mm.No_Module = vm.No_Module; mm.Sessions = vm.Sessions; mm.No_Sessions = vm.No_Sessions; mm.Session_StartDate = vm.Session_StartDate; mm.Session_EndDate = vm.Session_EndDate; db.SaveChanges(); } catch { } } }
public void CreateDiversion_M(PCMDiversionViewModel vm) { using (SDIIS_DatabaseEntities db = new SDIIS_DatabaseEntities()) { try { PCM_Diversion_M m = new PCM_Diversion_M(); m.P_Id = vm.P_Id; m.Modules_Id = vm.Modules_Id; m.No_Module = vm.No_Module; m.Sessions = vm.Sessions; m.No_Sessions = vm.No_Sessions; m.Session_StartDate = vm.Session_StartDate; m.Session_EndDate = vm.Session_EndDate; db.PCM_Diversion_M.Add(m); db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } } }