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