public bool UpdateCommissionReconsilation(CommisionModel commission) { try { var data = _hanysContext.Commisions.Where(c => c.Id == commission.Id).ToList(); if (data != null) { data.ForEach(d => { d.CommisionValue = commission.CommisionValue; d.ReconcilationDate = commission.AppliedDate; d.ReconcilationStatus = commission.ReconsilationStatus; d.RevDate = commission.RevDate; d.RevUser = commission.RevUser; _hanysContext.SaveChanges(); }); return(true); } } catch (Exception ex) { return(false); } return(true); }
public List <ExceptionCommissionModel> GetAllExceptionCommissionsForCarrier(int?carrierId) { if (carrierId == null) { return(new List <ExceptionCommissionModel>()); } var x = new CommisionModel(); var commissionModel = new List <ExceptionCommissionModel>(); var commissions = _commissionRepository.GetExceptionCommissionsForCarrier((int)carrierId); commissions.ForEach(dc => { var clientDetails = _clientRepository.GetById(dc.ClientId); commissionModel.Add(new ExceptionCommissionModel() { Id = dc.Id, ClientId = dc.ClientId, ClientName = dc.ClientId == 0?"":clientDetails.Name, PolicyNumber = dc.PolicyNumber, ProductType = dc.ProductType, ClientPolicyId = dc.ClientPolicyId, CarrierId = dc.CarrierId, CommissionValue = dc.CommissionValue, CommissionString = dc.CommissionValue != null ? Convert.ToString(dc.CommissionValue) : null, StatementDateAsString = GetDateFormat(dc.StatementDate), AppliedDate = dc.AppliedDate, AppliedDateAsString = GetDateFormatMMYYYY(dc.AppliedDate), PaymentId = dc.PaymentId, CoverageType = dc.CoverageType, PolicyId = dc.PolicyId }); }); return(commissionModel); }
public static void MapMonthlySummaryActual(this CommisionModel model, MonthSummary summary, ICommonService service) { int month = Convert.ToDateTime(model.AppliedDate).Month; switch (month) { case 1: summary.JanA = model.CommisionValue ?? 0; break; case 2: summary.FebA = model.CommisionValue ?? 0; break; case 3: summary.MarA = model.CommisionValue ?? 0; break; case 4: summary.AprA = model.CommisionValue ?? 0; break; case 5: summary.MayA = model.CommisionValue ?? 0; break; case 6: summary.JunA = model.CommisionValue ?? 0; break; case 7: summary.JulA = model.CommisionValue ?? 0; break; case 8: summary.AugA = model.CommisionValue ?? 0; break; case 9: summary.SepA = model.CommisionValue ?? 0; break; case 10: summary.OctA = model.CommisionValue ?? 0; break; case 11: summary.NovA = model.CommisionValue ?? 0; break; case 12: summary.DecA = model.CommisionValue ?? 0; break; } }
public bool Update(CommisionModel commission) { var data = _hanysContext.Commisions.FirstOrDefault(c => c.ClientPolicyId == commission.ClientPolicyId); if (data != null) { data.CommisionValue = commission.CommisionValue; data.CommisionString = commission.CommisionString; //data.PaymentId = commission.PaymentId; //data.StatementDate = commission.StatementDate; data.AppliedDate = commission.AppliedDate; data.RevDate = commission.RevDate; data.RevUser = commission.RevUser; //data.Status = commission.Status; _hanysContext.SaveChanges(); } return(true); }
public static void MapMonthlySummaryBudget(this CommisionModel model, MonthSummary summary, ICommonService service) { int month = Convert.ToDateTime(model.AppliedDate).Month; int year = Convert.ToDateTime(model.AppliedDate).Year; var bud = service.GetAllPolicyBudgetsForPolicyYearMonth(model.PolicyId, year, GetMonth(month)); if (bud == null) { return; } switch (month) { case 1: summary.JanB = bud.BudgetValue; break; case 2: summary.FebB = bud.BudgetValue; break; case 3: summary.MarB = bud.BudgetValue; break; case 4: summary.AprB = bud.BudgetValue; break; case 5: summary.MayB = bud.BudgetValue; break; case 6: summary.JunB = bud.BudgetValue; break; case 7: summary.JulB = bud.BudgetValue; break; case 8: summary.AugB = bud.BudgetValue; break; case 9: summary.SepB = bud.BudgetValue; break; case 10: summary.OctB = bud.BudgetValue; break; case 11: summary.NovB = bud.BudgetValue; break; case 12: summary.DecB = bud.BudgetValue; break; } }
public List <CommisionModel> GetCarrierPoliciesById(int carrierId) { var commisions = new List <CommisionModel>(); var clientPolicies = _commonRepository.GetAllClientPolicies().Where(cp => cp.IsActive); clientPolicies.ToList().ForEach(cp => { var policyDetails = _policyRepository.GetById(cp.PolicieId); if (policyDetails.CarId == carrierId) { var commisionMode = new CommisionModel(); var product = _commonRepository.GetProductById(policyDetails.ProductId); var coverage = _commonRepository.GetCoverageById(policyDetails.CoverageId); var clientDetails = _clientRepository.GetById(cp.ClientId); commisionMode.CoverageId = coverage.Id; commisionMode.CoverageName = coverage.Name; commisionMode.PolicyId = policyDetails.Id; commisionMode.PolicyNumber = policyDetails.PolicyNumber; commisionMode.ProductId = product.Id; commisionMode.ProductName = product.Name; commisionMode.ClientId = clientDetails.Id; commisionMode.CleintName = clientDetails.Name; if (!string.IsNullOrEmpty(clientDetails.Division)) { if (clientDetails.Division == "HBS") { commisionMode.DivisionId = 1; commisionMode.DivisionName = clientDetails.Division; } if (clientDetails.Division == "SBS") { commisionMode.DivisionId = 2; commisionMode.DivisionName = clientDetails.Division; } } commisionMode.Git = policyDetails.IsGroupInsurance; //commisionMode.DivisionId = Convert.ToInt32(clientDetails.Division); //commisionMode.DivisionName = commisionMode.DivisionId == 1 ? "Division 1" : "Division 2"; commisionMode.ClientPolicyId = cp.Id; commisionMode.CarrierId = carrierId; var isExist = commisions.FirstOrDefault(c => c.ClientId == commisionMode.ClientId && c.PolicyNumber == commisionMode.PolicyNumber); if (isExist != null) { isExist.Products.Add(new Product() { Id = commisionMode.ProductId, Name = commisionMode.ProductName }); } if (isExist == null) { commisionMode.Products.Add(new Product() { Id = commisionMode.ProductId, Name = commisionMode.ProductName }); commisions.Add(commisionMode); } } }); //Product management commisions.ForEach(c => { c.Products.ForEach(cp => { var cpProduct = _commonRepository.GetAllCorporateXProducts().FirstOrDefault(cxp => cxp.ProductId == cp.Id); if (cpProduct != null) { var cProduct = _commonRepository.GetAllCorporateProducts().FirstOrDefault(p => p.Id == cpProduct.CorporateProductId); if (cProduct != null) { var isExit = c.CorporateProducts.FirstOrDefault(cpp => cpp.Id == cProduct.Id); if (isExit == null) { c.CorporateProducts.Add(cProduct); } } } }); //if (c.SelectedCoverage != null && c.SelectedCoverage.Id > 0) //{ //var products = GetProductsOfPolicy(Convert.ToString(c.ClientId), c.PolicyNumber, Convert.ToString(c.CoverageId)); // c.Products = products; //} }); return(commisions); }