//Add PolicyOtherGroupHeaderColumnName public void Add(PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertPolicyOtherGroupHeaderColumnName_v1( policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderTableName.PolicyOtherGroupHeaderTableNameId, policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName.ColumnName, adminUserGuid ); }
public ActionResult Delete(int id) { //Get Item From Database PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName(); policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnName(id); //Check Exists if (policyOtherGroupHeaderColumnName == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Get Table Name PolicyOtherGroupHeaderTableName policyOtherGroupHeaderTableName = new PolicyOtherGroupHeaderTableName(); policyOtherGroupHeaderTableName = policyOtherGroupHeaderTableNameRepository.GetPolicyOtherGroupHeaderTableNameByPolicyOtherGroupHeaderTableNameId(policyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderTableNameId); //Check Exists if (policyOtherGroupHeaderTableName == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Get Item From Database PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderTableName.PolicyOtherGroupHeaderId); //Check Exists if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM = new PolicyOtherGroupHeaderColumnNameVM(); policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnName; policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderTableName = policyOtherGroupHeaderTableName; policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeader = policyOtherGroupHeader; return(View(policyOtherGroupHeaderColumnNameVM)); }
public ActionResult Delete(PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM) { //Check Valid Item passed in Form if (policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Get Item From Database PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName(); policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnName(policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderColumnNameId); //Check Exists if (policyOtherGroupHeaderColumnName == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Delete Form Item try { policyOtherGroupHeaderColumnNameRepository.Delete(policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyOtherGroupHeaderColumnName.mvc/Delete/" + policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderColumnNameId; return(View("VersionError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("List", new { id = policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId })); }
public ActionResult Edit(PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM, FormCollection formCollection) { //Get Item PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName(); policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnName(policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderColumnNameId); //Check Exists if (policyOtherGroupHeaderColumnName == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model From Form + Validate against DB try { UpdateModel <PolicyOtherGroupHeaderColumnName>(policyOtherGroupHeaderColumnName, "PolicyOtherGroupHeaderColumnName"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { policyOtherGroupHeaderColumnNameRepository.Edit(policyOtherGroupHeaderColumnName); } catch (SqlException ex) { //Non-Unique Name if (ex.Message == "NonUniqueName") { return(View("NonUniqueNameError")); } //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyOtherGroupHeaderColumnName.mvc/Edit/" + policyOtherGroupHeaderColumnName.PolicyOtherGroupHeaderColumnNameId; return(View("VersionError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("List", new { id = policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId })); }
public ActionResult Create(PolicyOtherGroupHeaderColumnNameVM policyOtherGroupHeaderColumnNameVM, FormCollection formCollection) { //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //We need to extract group from groupVM PolicyOtherGroupHeaderColumnName policyOtherGroupHeaderColumnName = new PolicyOtherGroupHeaderColumnName(); policyOtherGroupHeaderColumnName = policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeaderColumnName; if (policyOtherGroupHeaderColumnName == null) { ViewData["Message"] = "ValidationError : missing item";; return(View("Error")); } //Update Model From Form + Validate against DB try { UpdateModel <PolicyOtherGroupHeaderColumnName>(policyOtherGroupHeaderColumnName, "PolicyOtherGroupHeaderColumnName"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { policyOtherGroupHeaderColumnNameRepository.Add(policyOtherGroupHeaderColumnNameVM); } catch (SqlException ex) { //Non-Unique Name if (ex.Message == "NonUniqueName") { return(View("NonUniqueNameError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } ViewData["NewSortOrder"] = 0; return(RedirectToAction("List", new { id = policyOtherGroupHeaderColumnNameVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId })); }