public ActionResult Delete(PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM) { //Check PolicyPriceTrackingOtherGroupItemDataTableRow Exists PolicyPriceTrackingOtherGroupItemDataTableRow PolicyPriceTrackingOtherGroupItemDataTableRow = new PolicyPriceTrackingOtherGroupItemDataTableRow(); PolicyPriceTrackingOtherGroupItemDataTableRow = PolicyPriceTrackingOtherGroupItemDataTableRowRepository.GetPolicyPriceTrackingOtherGroupItemDataTableRow( PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableRow.PolicyPriceTrackingOtherGroupItemDataTableRowId ); if (PolicyPriceTrackingOtherGroupItemDataTableRow == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check Policy Exists PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Check PolicyOtherGroupHeader Exists PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader( PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId ); if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "DeletePost"; return(View("RecordDoesNotExistError")); } //Delete Form Item try { PolicyPriceTrackingOtherGroupItemDataTableItemRepository.Delete(PolicyPriceTrackingOtherGroupItemDataTableRow); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicyPriceTrackingOtherGroupItemDataTableItem.mvc/Delete/" + PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableRow.PolicyPriceTrackingOtherGroupItemDataTableRowId; 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 = PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, policyGroupId = PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId })); }
//Edit public void Edit(PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; XmlDocument doc = ConvertPolicyPriceTrackingOtherGroupItemDataTableItemsToXML(PolicyPriceTrackingOtherGroupItemDataTableItemVM); db.spDesktopDataAdmin_UpdatePolicyPriceTrackingOtherGroupItemDataTableItem_v1( PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableRow.PolicyPriceTrackingOtherGroupItemDataTableRowId, System.Xml.Linq.XElement.Parse(doc.OuterXml), adminUserGuid, PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableRow.VersionNumber ); }
//Add public void Add(PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; XmlDocument doc = ConvertPolicyPriceTrackingOtherGroupItemDataTableItemsToXML(PolicyPriceTrackingOtherGroupItemDataTableItemVM); db.spDesktopDataAdmin_InsertPolicyPriceTrackingOtherGroupItemDataTableItem_v1( PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId, PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, System.Xml.Linq.XElement.Parse(doc.OuterXml), adminUserGuid ); }
public ActionResult Delete(int id, int policyGroupId, int policyOtherGroupHeaderId) { PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM = new PolicyPriceTrackingOtherGroupItemDataTableItemVM(); //Check PolicyPriceTrackingOtherGroupItemDataTableRow Exists PolicyPriceTrackingOtherGroupItemDataTableRow PolicyPriceTrackingOtherGroupItemDataTableRow = new PolicyPriceTrackingOtherGroupItemDataTableRow(); PolicyPriceTrackingOtherGroupItemDataTableRow = PolicyPriceTrackingOtherGroupItemDataTableRowRepository.GetPolicyPriceTrackingOtherGroupItemDataTableRow(id); if (PolicyPriceTrackingOtherGroupItemDataTableRow == 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")); } PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader = policyOtherGroupHeader; policyGroupRepository.EditGroupForDisplay(policyGroup); PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup = policyGroup; PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableRow = PolicyPriceTrackingOtherGroupItemDataTableRow; List <PolicyPriceTrackingOtherGroupItemDataTableItem> PolicyPriceTrackingOtherGroupItemDataTableItems = new List <PolicyPriceTrackingOtherGroupItemDataTableItem>(); PolicyPriceTrackingOtherGroupItemDataTableItems = PolicyPriceTrackingOtherGroupItemDataTableRowRepository.GetPolicyPriceTrackingOtherGroupItemDataTableItems(id, policyOtherGroupHeaderId); if (PolicyPriceTrackingOtherGroupItemDataTableItems != null) { PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableItems = PolicyPriceTrackingOtherGroupItemDataTableItems; } return(View(PolicyPriceTrackingOtherGroupItemDataTableItemVM)); }
//Loop through PolicyPriceTrackingOtherGroupItemDataTableItems into XML public XmlDocument ConvertPolicyPriceTrackingOtherGroupItemDataTableItemsToXML(PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM) { XmlDocument doc = new XmlDocument(); XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null); doc.AppendChild(dec); XmlElement root = doc.CreateElement("PolicyPriceTrackingOtherGroupItemDataTableItems"); doc.AppendChild(root); if (PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableItems != null) { if (PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableItems.Count > 0) { XmlElement xmlPolicyPriceTrackingOtherGroupItemDataTableItems = doc.CreateElement("PolicyPriceTrackingOtherGroupItemDataTableItems"); foreach (PolicyPriceTrackingOtherGroupItemDataTableItem item in PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableItems) { if (item != null && !string.IsNullOrEmpty(item.TableDataItem)) { XmlElement xmlPolicyPriceTrackingOtherGroupItemDataTableItem = doc.CreateElement("PolicyPriceTrackingOtherGroupItemDataTableItem"); XmlElement xmlPolicyPriceTrackingOtherGroupItemDataTableItem_TableDataItem = doc.CreateElement("TableDataItem"); xmlPolicyPriceTrackingOtherGroupItemDataTableItem_TableDataItem.InnerText = item.TableDataItem; xmlPolicyPriceTrackingOtherGroupItemDataTableItem.AppendChild(xmlPolicyPriceTrackingOtherGroupItemDataTableItem_TableDataItem); XmlElement xmlPolicyPriceTrackingOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId = doc.CreateElement("PolicyOtherGroupHeaderColumnNameId"); xmlPolicyPriceTrackingOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId.InnerText = item.PolicyOtherGroupHeaderColumnNameId.ToString(); xmlPolicyPriceTrackingOtherGroupItemDataTableItem.AppendChild(xmlPolicyPriceTrackingOtherGroupItemDataTableItem_PolicyOtherGroupHeaderColumnNameId); xmlPolicyPriceTrackingOtherGroupItemDataTableItems.AppendChild(xmlPolicyPriceTrackingOtherGroupItemDataTableItem); } } root.AppendChild(xmlPolicyPriceTrackingOtherGroupItemDataTableItems); } } return(doc); }
public ActionResult Edit(PolicyPriceTrackingOtherGroupItemDataTableItemVM PolicyPriceTrackingOtherGroupItemDataTableItemVM, FormCollection formCollection) { //Check Policy Exists PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId); if (policyGroup == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //Check PolicyOtherGroupHeader Exists PolicyOtherGroupHeader policyOtherGroupHeader = new PolicyOtherGroupHeader(); policyOtherGroupHeader = policyOtherGroupHeaderRepository.GetPolicyOtherGroupHeader(PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId); if (policyOtherGroupHeader == null) { ViewData["ActionMethod"] = "CreatePost"; return(View("RecordDoesNotExistError")); } //We need to extract group from groupVM List <PolicyPriceTrackingOtherGroupItemDataTableItem> PolicyPriceTrackingOtherGroupItemDataTableItems = new List <PolicyPriceTrackingOtherGroupItemDataTableItem>(); foreach (string item in formCollection) { if (item.StartsWith("PolicyOtherGroupHeaderColumnNameId")) { PolicyPriceTrackingOtherGroupItemDataTableItem PolicyPriceTrackingOtherGroupItemDataTableItem = new PolicyPriceTrackingOtherGroupItemDataTableItem() { PolicyOtherGroupHeaderColumnNameId = Int32.Parse(item.Replace("PolicyOtherGroupHeaderColumnNameId_", "")), TableDataItem = formCollection[item] }; PolicyPriceTrackingOtherGroupItemDataTableItems.Add(PolicyPriceTrackingOtherGroupItemDataTableItem); } } if (PolicyPriceTrackingOtherGroupItemDataTableItems.Count() <= 0) { ViewData["Message"] = "ValidationError : missing item";; return(View("Error")); } PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyPriceTrackingOtherGroupItemDataTableItems = PolicyPriceTrackingOtherGroupItemDataTableItems; //Update Model From Form + Validate against DB try { UpdateModel <PolicyPriceTrackingOtherGroupItemDataTableItemVM>(PolicyPriceTrackingOtherGroupItemDataTableItemVM, "PolicyPriceTrackingOtherGroupItemDataTableItemVM"); } 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 { PolicyPriceTrackingOtherGroupItemDataTableItemRepository.Edit(PolicyPriceTrackingOtherGroupItemDataTableItemVM); } 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 = PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyOtherGroupHeader.PolicyOtherGroupHeaderId, policyGroupId = PolicyPriceTrackingOtherGroupItemDataTableItemVM.PolicyGroup.PolicyGroupId })); }