//Get items
public List <PolicyPriceTrackingOtherGroupItemDataTableItem> GetPolicyPriceTrackingOtherGroupItemDataTableItems(int policyGroupId, int policyOtherGroupHeaderId)
{
List <PolicyPriceTrackingOtherGroupItemDataTableItem> PolicyPriceTrackingOtherGroupItemDataTableItems = new List <PolicyPriceTrackingOtherGroupItemDataTableItem>();
PolicyPriceTrackingOtherGroupItem PolicyPriceTrackingOtherGroupItem = new PolicyPriceTrackingOtherGroupItem();
PolicyPriceTrackingOtherGroupItemRepository PolicyPriceTrackingOtherGroupItemRepository = new PolicyPriceTrackingOtherGroupItemRepository();
PolicyPriceTrackingOtherGroupItem = PolicyPriceTrackingOtherGroupItemRepository.GetPolicyPriceTrackingOtherGroupItem(policyGroupId, policyOtherGroupHeaderId);
//Get Columns
List <PolicyOtherGroupHeaderColumnName> policyOtherGroupHeaderColumnNames = new List <PolicyOtherGroupHeaderColumnName>();
PolicyOtherGroupHeaderColumnNameRepository policyOtherGroupHeaderColumnNameRepository = new PolicyOtherGroupHeaderColumnNameRepository();
policyOtherGroupHeaderColumnNames = policyOtherGroupHeaderColumnNameRepository.GetPolicyOtherGroupHeaderColumnNames(policyOtherGroupHeaderId);
if (policyOtherGroupHeaderColumnNames != null)
{
foreach (PolicyOtherGroupHeaderColumnName item in policyOtherGroupHeaderColumnNames)
{
PolicyPriceTrackingOtherGroupItemDataTableItem PolicyPriceTrackingOtherGroupItemDataTableItem = new PolicyPriceTrackingOtherGroupItemDataTableItem()
{
PolicyOtherGroupHeaderColumnNameId = item.PolicyOtherGroupHeaderColumnNameId,
PolicyOtherGroupHeaderColumnName = item
};
PolicyPriceTrackingOtherGroupItemDataTableItems.Add(PolicyPriceTrackingOtherGroupItemDataTableItem);
}
}
return(PolicyPriceTrackingOtherGroupItemDataTableItems);
}
//Get items
public List <PolicyPriceTrackingOtherGroupItemDataTableItem> GetPolicyPriceTrackingOtherGroupItemDataTableItems(int PolicyPriceTrackingOtherGroupItemDataTableRowId, int policyOtherGroupHeaderId)
{
List <PolicyPriceTrackingOtherGroupItemDataTableItem> PolicyPriceTrackingOtherGroupItemDataTableItems = new List <PolicyPriceTrackingOtherGroupItemDataTableItem>();
List <int> policyOtherGroupHeaderColumnNameIds = new List <int>();
//Get Completed Columns
List <PolicyPriceTrackingOtherGroupItemDataTableItem> PolicyPriceTrackingOtherGroupItemDataTableItemsCompleted = new List <PolicyPriceTrackingOtherGroupItemDataTableItem>();
PolicyPriceTrackingOtherGroupItemDataTableItemsCompleted = db.PolicyPriceTrackingOtherGroupItemDataTableItems.Where(
c => c.PolicyPriceTrackingOtherGroupItemDataTableRowId == PolicyPriceTrackingOtherGroupItemDataTableRowId
).ToList();
foreach (PolicyPriceTrackingOtherGroupItemDataTableItem PolicyPriceTrackingOtherGroupItemDataTableItem in PolicyPriceTrackingOtherGroupItemDataTableItemsCompleted)
{
PolicyPriceTrackingOtherGroupItemDataTableItems.Add(PolicyPriceTrackingOtherGroupItemDataTableItem);
policyOtherGroupHeaderColumnNameIds.Add(PolicyPriceTrackingOtherGroupItemDataTableItem.PolicyOtherGroupHeaderColumnNameId);
}
//Get Empty Columns
List <PolicyOtherGroupHeaderColumnName> policyOtherGroupHeaderColumnNames = new List <PolicyOtherGroupHeaderColumnName>();
PolicyOtherGroupHeaderColumnNameRepository policyOtherGroupHeaderColumnNameRepository = new PolicyOtherGroupHeaderColumnNameRepository();
policyOtherGroupHeaderColumnNames = policyOtherGroupHeaderColumnNameRepository.GetIncompletePolicyOtherGroupHeaderColumnNames(
policyOtherGroupHeaderId,
policyOtherGroupHeaderColumnNameIds);
foreach (PolicyOtherGroupHeaderColumnName item in policyOtherGroupHeaderColumnNames)
{
PolicyPriceTrackingOtherGroupItemDataTableItem PolicyPriceTrackingOtherGroupItemDataTableItem = new PolicyPriceTrackingOtherGroupItemDataTableItem()
{
PolicyOtherGroupHeaderColumnNameId = item.PolicyOtherGroupHeaderColumnNameId,
PolicyOtherGroupHeaderColumnName = item
};
PolicyPriceTrackingOtherGroupItemDataTableItems.Add(PolicyPriceTrackingOtherGroupItemDataTableItem);
}
PolicyPriceTrackingOtherGroupItemDataTableItems = PolicyPriceTrackingOtherGroupItemDataTableItems.OrderBy(x => x.PolicyOtherGroupHeaderColumnName.DisplayOrder).ToList();
return(PolicyPriceTrackingOtherGroupItemDataTableItems);
}
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 }));
}
