public ActionResult Delete(Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM) { //Check Policy24HSCOtherGroupItemDataTableRow Exists Policy24HSCOtherGroupItemDataTableRow policy24HSCOtherGroupItemDataTableRow = new Policy24HSCOtherGroupItemDataTableRow(); policy24HSCOtherGroupItemDataTableRow = policy24HSCOtherGroupItemDataTableRowRepository.GetPolicy24HSCOtherGroupItemDataTableRow( policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableRow.Policy24HSCOtherGroupItemDataTableRowId ); if (policy24HSCOtherGroupItemDataTableRow == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check Policy Exists PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check PolicyOtherGroupHeader Exists PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader( policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId ); if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Delete Form Item try { policy24HSCOtherGroupItemDataTableItemRepository.Delete(policy24HSCOtherGroupItemDataTableRow); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/Policy24HSCOtherGroupItemDataTableItem.mvc/Delete/" + policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableRow.Policy24HSCOtherGroupItemDataTableRowId; 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 = policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, policyGroupId = policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId })); }
//Edit public void Edit(Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; XmlDocument doc = ConvertPolicy24HSCOtherGroupItemDataTableItemsToXML(policy24HSCOtherGroupItemDataTableItemVM); db.spDesktopDataAdmin_UpdatePolicy24HSCOtherGroupItemDataTableItem_v1( policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableRow.Policy24HSCOtherGroupItemDataTableRowId, System.Xml.Linq.XElement.Parse(doc.OuterXml), adminUserGuid, policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableRow.VersionNumber ); }
//Add public void Add(Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; XmlDocument doc = ConvertPolicy24HSCOtherGroupItemDataTableItemsToXML(policy24HSCOtherGroupItemDataTableItemVM); db.spDesktopDataAdmin_InsertPolicy24HSCOtherGroupItemDataTableItem_v1( policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId, policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, System.Xml.Linq.XElement.Parse(doc.OuterXml), adminUserGuid ); }
public ActionResult Delete(int id, int policyGroupId, int policyOtherGroupHeaderId) { Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM = new Policy24HSCOtherGroupItemDataTableItemVM(); //Check Policy24HSCOtherGroupItemDataTableRow Exists Policy24HSCOtherGroupItemDataTableRow policy24HSCOtherGroupItemDataTableRow = new Policy24HSCOtherGroupItemDataTableRow(); policy24HSCOtherGroupItemDataTableRow = policy24HSCOtherGroupItemDataTableRowRepository.GetPolicy24HSCOtherGroupItemDataTableRow(id); if (policy24HSCOtherGroupItemDataTableRow == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check Policy Exists PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } //Check PolicyOtherGroupHeader Exists PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policyOtherGroupHeaderId); if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "EditGet"; return(View("RecordDoesNotExistError")); } policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader = policyOtherGroupHeader; policyGroupRepository.EditGroupForDisplay(policyGroup); policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup = policyGroup; policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableRow = policy24HSCOtherGroupItemDataTableRow; List <Policy24HSCOtherGroupItemDataTableItem> policy24HSCOtherGroupItemDataTableItems = new List <Policy24HSCOtherGroupItemDataTableItem>(); policy24HSCOtherGroupItemDataTableItems = policy24HSCOtherGroupItemDataTableRowRepository.GetPolicy24HSCOtherGroupItemDataTableItems(id, policyOtherGroupHeaderId); if (policy24HSCOtherGroupItemDataTableItems != null) { policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableItems = policy24HSCOtherGroupItemDataTableItems; } return(View(policy24HSCOtherGroupItemDataTableItemVM)); }
//Loop through Policy24HSCOtherGroupItemDataTableItems into XML public XmlDocument ConvertPolicy24HSCOtherGroupItemDataTableItemsToXML(Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM) { XmlDocument doc = new XmlDocument(); XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null); doc.AppendChild(dec); XmlElement root = doc.CreateElement("Policy24HSCOtherGroupItemDataTableItems"); doc.AppendChild(root); if (policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableItems != null) { if (policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableItems.Count > 0) { XmlElement xmlPolicy24HSCOtherGroupItemDataTableItems = doc.CreateElement("Policy24HSCOtherGroupItemDataTableItems"); foreach (Policy24HSCOtherGroupItemDataTableItem item in policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableItems) { if (item != null && !string.IsNullOrEmpty(item.TableDataItem)) { XmlElement xmlPolicy24HSCOtherGroupItemDataTableItem = doc.CreateElement("Policy24HSCOtherGroupItemDataTableItem"); XmlElement xmlPolicy24HSCOtherGroupItemDataTableItem_TableDataItem = doc.CreateElement("TableDataItem"); xmlPolicy24HSCOtherGroupItemDataTableItem_TableDataItem.InnerText = item.TableDataItem; xmlPolicy24HSCOtherGroupItemDataTableItem.AppendChild(xmlPolicy24HSCOtherGroupItemDataTableItem_TableDataItem); XmlElement xmlPolicy24HSCOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId = doc.CreateElement("PolicyOtherGroupHeaderColumnNameId"); xmlPolicy24HSCOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId.InnerText = item.PolicyOtherGroupHeaderColumnNameId.ToString(); xmlPolicy24HSCOtherGroupItemDataTableItem.AppendChild(xmlPolicy24HSCOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId); xmlPolicy24HSCOtherGroupItemDataTableItems.AppendChild(xmlPolicy24HSCOtherGroupItemDataTableItem); } } root.AppendChild(xmlPolicy24HSCOtherGroupItemDataTableItems); } } return(doc); }
public ActionResult Edit(Policy24HSCOtherGroupItemDataTableItemVM policy24HSCOtherGroupItemDataTableItemVM, FormCollection formCollection) { //Check Policy Exists PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Check PolicyOtherGroupHeader Exists PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId); if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //We need to extract group from groupVM List <Policy24HSCOtherGroupItemDataTableItem> policy24HSCOtherGroupItemDataTableItems = new List <Policy24HSCOtherGroupItemDataTableItem>(); foreach (string item in formCollection) { if (item.StartsWith("PolicyOtherGroupHeaderColumnNameId")) { Policy24HSCOtherGroupItemDataTableItem policy24HSCOtherGroupItemDataTableItem = new Policy24HSCOtherGroupItemDataTableItem() { PolicyOtherGroupHeaderColumnNameId = Int32.Parse(item.Replace("PolicyOtherGroupHeaderColumnNameId_", "")), TableDataItem = formCollection[item] }; policy24HSCOtherGroupItemDataTableItems.Add(policy24HSCOtherGroupItemDataTableItem); } } if (policy24HSCOtherGroupItemDataTableItems.Count() <= 0) { ViewData["Message"] = "ValidationError : missing item";; return(View("Error")); } policy24HSCOtherGroupItemDataTableItemVM.Policy24HSCOtherGroupItemDataTableItems = policy24HSCOtherGroupItemDataTableItems; //Update Model From Form + Validate against DB try { UpdateModel <Policy24HSCOtherGroupItemDataTableItemVM>(policy24HSCOtherGroupItemDataTableItemVM, "Policy24HSCOtherGroupItemDataTableItemVM"); } 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 { policy24HSCOtherGroupItemDataTableItemRepository.Edit(policy24HSCOtherGroupItemDataTableItemVM); } 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 = policy24HSCOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, policyGroupId = policy24HSCOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId })); }