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 }));
}
