public ActionResult DeleteTest(string ID) { try { REF_TEST_TB test = _uow.Repository <REF_TEST_TB>().GetById(Convert.ToInt32(ID)); TestDeleteViewModel testDeleteViewModel = new TestDeleteViewModel() { AnalysisMethod = test.SZ_ANALYSIS_METHOD, Description = test.SZ_DESCRIPTION, EffectiveDate = test.DT_EFFECTIVE == null ? "" : test.DT_EFFECTIVE.Value.ToShortDateString(), ExpiredDate = test.DT_EXPIRED == null ? "" : test.DT_EXPIRED.Value.ToShortDateString(), SampleMedia = test.SZ_SAMPLE_MEDIA, SampleType = test.SZ_SAMPLE_TYPE, TestID = test.N_TEST_SYSID, Unit = test.SZ_TITLE, Message = "", ShowMessage = false }; return(View(testDeleteViewModel)); } catch (Exception ex) { if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.DeleteTest_GET\n\nError: " + ex.Message; } else { ViewBag.Message = "Function: TestController.DeleteTest_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message); }; Session["ErrorMessage"] = ViewBag.Message; return(RedirectToAction("InternalServerError", "Error")); }; }
public ActionResult Create(int ID, int?TestGroupID) { try { REF_TEST_TB test = _uow.Repository <REF_TEST_TB>().GetById(ID); TestCreateGroupViewModel model = new TestCreateGroupViewModel() { ID = ID, SelectedTestGroup = 0, TestDescription = test.SZ_DESCRIPTION, TestGroups = (List <SelectListItem>)_testRepo.GetTestGroupsSelectListByTestID(ID) }; return(View(model)); } catch (Exception ex) { if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.Create_GET\n\nError: " + ex.Message; } else { ViewBag.Message = "Function: TestController.Create_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message); }; Session["ErrorMessage"] = ViewBag.Message; return(RedirectToAction("InternalServerError", "Error")); }; }
public ActionResult Edit(int ID) { try { var testEditViewModel = new TestEditViewModel(); if (ID > 0) { REF_TEST_TB test = _uow.Repository <REF_TEST_TB>().GetById(ID); testEditViewModel.AnalysisMethod = test.SZ_ANALYSIS_METHOD; testEditViewModel.Description = test.SZ_DESCRIPTION; testEditViewModel.EffectiveDate = test.DT_EFFECTIVE == null ? "" : test.DT_EFFECTIVE.Value.ToShortDateString(); testEditViewModel.ExpiredDate = test.DT_EXPIRED == null ? "" : test.DT_EXPIRED.Value.ToShortDateString(); testEditViewModel.SampleMedia = test.SZ_SAMPLE_MEDIA; testEditViewModel.SampleType = test.SZ_SAMPLE_TYPE; testEditViewModel.TestID = test.N_TEST_SYSID; testEditViewModel.Unit = test.SZ_TITLE; } else { testEditViewModel.AnalysisMethod = ""; testEditViewModel.Description = ""; testEditViewModel.EffectiveDate = ""; testEditViewModel.ExpiredDate = ""; testEditViewModel.SampleMedia = ""; testEditViewModel.SampleType = ""; testEditViewModel.TestID = ID; testEditViewModel.Unit = ""; } return(View("Edit", testEditViewModel)); } catch (Exception ex) { if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.Edit_GET\n\nError: " + ex.Message; } else { ViewBag.Message = "Function: TestController.Edit_GET\n\nError: " + (ex.Message + "\n\nInnerException: " + ex.InnerException.Message); }; Session["ErrorMessage"] = ViewBag.Message; return(RedirectToAction("InternalServerError", "Error")); }; }
public ActionResult Edit(TestEditViewModel Model) { bool saveFailed; do { saveFailed = false; try { if (ModelState.IsValid) { int id = 0; if (Model.TestID == 0) //new { REF_TEST_TB test = new REF_TEST_TB() { B_INACTIVE = false, DT_EFFECTIVE = Model.EffectiveDate == "" ? (DateTime?)null : Convert.ToDateTime(Model.EffectiveDate), DT_ENTERED = DateTime.UtcNow, DT_EXPIRED = Model.ExpiredDate == "" ? (DateTime?)null : Convert.ToDateTime(Model.ExpiredDate), DT_MODIFIED = DateTime.UtcNow, SZ_DESCRIPTION = Model.Description, SZ_ENTERED_BY = _modifiedBy, SZ_MODIFIED_BY = _modifiedBy, SZ_ANALYSIS_METHOD = Model.AnalysisMethod, SZ_SAMPLE_MEDIA = Model.SampleMedia, SZ_SAMPLE_TYPE = Model.SampleType, SZ_TITLE = Model.Unit }; _uow.Repository <REF_TEST_TB>().Add(test); _uow.SaveChanges(); DateTime effectiveDate = Convert.ToDateTime(Model.EffectiveDate); DateTime expiredDate = Convert.ToDateTime(Model.ExpiredDate); REF_TEST_TB testFound = _uow.Repository <REF_TEST_TB>().Find(u => u.SZ_ENTERED_BY == _modifiedBy && u.SZ_MODIFIED_BY == _modifiedBy && u.DT_EFFECTIVE == effectiveDate && u.DT_EXPIRED == expiredDate && u.SZ_DESCRIPTION == Model.Description && u.SZ_ANALYSIS_METHOD == Model.AnalysisMethod && u.SZ_SAMPLE_MEDIA == Model.SampleMedia && u.SZ_SAMPLE_TYPE == Model.SampleType && u.SZ_TITLE == Model.Unit).FirstOrDefault(); id = testFound.N_TEST_SYSID; } else //edit { REF_TEST_TB test = _uow.Repository <REF_TEST_TB>().GetById(Model.TestID); test.DT_EFFECTIVE = Convert.ToDateTime(Model.EffectiveDate); test.DT_EXPIRED = Convert.ToDateTime(Model.ExpiredDate); test.DT_MODIFIED = DateTime.UtcNow; test.SZ_ANALYSIS_METHOD = Model.AnalysisMethod; test.SZ_DESCRIPTION = Model.Description; test.SZ_MODIFIED_BY = _modifiedBy; test.SZ_SAMPLE_MEDIA = Model.SampleMedia; test.SZ_SAMPLE_TYPE = Model.SampleType; test.SZ_TITLE = Model.Unit; _uow.Repository <REF_TEST_TB>().Update(test); _uow.SaveChanges(); id = Model.TestID; } return(RedirectToAction("Index", new { ID = id })); } return(View(Model)); } catch (DbEntityValidationException ex) { StringBuilder sb = new StringBuilder(); foreach (var failure in ex.EntityValidationErrors) { sb.AppendFormat("{0} failed validation:\n\n", failure.Entry.Entity.GetType()); foreach (var error in failure.ValidationErrors) { sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage); sb.AppendLine(); } } if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message + "\n\n" + sb; } else { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message + "\n\n" + sb + "\n\n" + ex.InnerException.Message; }; } catch (DbUpdateConcurrencyException ex) { saveFailed = true; var entry = ex.Entries.Single(); entry.OriginalValues.SetValues(entry.GetDatabaseValues()); } catch (DataException ex) { if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.GetBaseException().Message; } else { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.GetBaseException().Message + "\n\nInnerException: " + ex.InnerException.Message; }; } catch (Exception ex) { if (ex.InnerException == null) { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message; } else { ViewBag.Message = "Function: TestController.Edit_POST\n\nError: " + ex.Message + "\n\nBaseException: " + ex.InnerException.Message; }; }; } while (saveFailed); Session["ErrorMessage"] = ViewBag.Message; return(RedirectToAction("InternalServerError", "Error")); }