public bool UpdateClientPolocyBudget(ClientPolicyBudget budget)
{
var data = _hanysContext.ClientPolicieBudgets.FirstOrDefault(c => c.ClientId == budget.ClientId &&
c.PolicyId == budget.PolicyId &&
c.BudgetYear == budget.BudgetYear &&
c.BudgetMonth == budget.BudgetMonth);
if (data != null)
{
data.IsActive = budget.IsActive;
data.BudgetValue = budget.BudgetValue;
data.RevDate = budget.RevDate;
data.RevUser = budget.RevUser;
_hanysContext.SaveChanges();
}
return(true);
}
public bool AddClientPolocyBudget(AddPolicyBudget budget)
{
var cpDetails = _commonRepository.GetAllClientPolicies().Where(c => c.ClientId == budget.ClientId).OrderByDescending(cp => cp.Id);
var pDetails = _policyRepository.GetById(budget.PolicyId);
var carrierProduct = _commonRepository.GetAllCorporateXProducts().FirstOrDefault(cp => cp.ProductId == pDetails.ProductId);
cpDetails.ToList().ForEach(cp =>
{
var pDetailsChild = _policyRepository.GetById(cp.PolicieId);
var carrierProductChild = _commonRepository.GetAllCorporateXProducts()
.FirstOrDefault(cpp => cpp.ProductId == pDetailsChild.ProductId);
if (carrierProductChild != null && carrierProduct.CorporateProductId == carrierProductChild.CorporateProductId &&
pDetailsChild.PolicyNumber == pDetails.PolicyNumber &&
pDetailsChild.CarId == pDetails.CarId)
{
budget.PolicyId = pDetailsChild.Id;
}
});
foreach (var month in DateUtil.GetMonths())
{
var entity = new ClientPolicyBudget()
{
ClientId = budget.ClientId,
PolicyId = budget.PolicyId,
ClientPolicyId = budget.ClientPolicyId,
IsActive = true,
AddUser = LoginUserDetails.GetWindowsLoginUserName(),
AddDate = DateUtil.GetCurrentDate(),
BudgetYear = budget.Year,
BudgetMonth = month
};
switch (entity.BudgetMonth.ToLower())
{
case "jan":
entity.BudgetValue = budget.JanBudget;
break;
case "feb":
entity.BudgetValue = budget.FebBudget;
break;
case "mar":
entity.BudgetValue = budget.MarchBudget;
break;
case "apr":
entity.BudgetValue = budget.AprilBudget;
break;
case "may":
entity.BudgetValue = budget.MayBudget;
break;
case "jun":
entity.BudgetValue = budget.JunBudget;
break;
case "jul":
entity.BudgetValue = budget.JulyBudget;
break;
case "aug":
entity.BudgetValue = budget.AugBudget;
break;
case "sep":
entity.BudgetValue = budget.SepBudget;
break;
case "oct":
entity.BudgetValue = budget.OctBudget;
break;
case "nov":
entity.BudgetValue = budget.NovBudget;
break;
case "dec":
entity.BudgetValue = budget.DecBudget;
break;
}
_commonRepository.AddClientPolocyBudget(entity);
}
return(true);
}
