public static List <FinanceCardInfo> GetByPaymentInPeriod(DateTime fromDate, DateTime toDate, List <int> lstBranhces,
List <int> lstInsuranceCompanies, List <int> lstInsuranceSubTypes, List <int> lstUsers, List <int> lstMarketingAgents)
{
decimal totSaldo = 0;
List <FinanceCardInfo> retList = new List <FinanceCardInfo>();
List <Payment> lstPayments = Payment.GetInPeriod(fromDate, toDate, lstBranhces, lstInsuranceCompanies, lstInsuranceSubTypes, lstUsers, lstMarketingAgents);
foreach (Payment payment in lstPayments)
{
FinanceCardInfo fciPayment = new FinanceCardInfo();
fciPayment.PolicyNumber = payment.Rate.PolicyItem.PolicyNumber;
fciPayment.PolicyItemID = payment.Rate.PolicyItemID;
fciPayment.DocumentDate = payment.Date;
fciPayment.PaidDate = payment.Rate.Date;
if (lstPayments.Count == 1)
{
fciPayment.Description = "Уплата по полиса " + payment.Rate.PolicyItem.PolicyNumber;
}
else
{
fciPayment.Description = "Уплата за " + payment.Rate.Number + "-ва рата по полиса " + payment.Rate.PolicyItem.PolicyNumber;
}
fciPayment.DebtValue = 0;
fciPayment.DemandValue = payment.Value;
fciPayment.SaldoValue = totSaldo + (fciPayment.DebtValue - fciPayment.DemandValue);
totSaldo = fciPayment.SaldoValue;
retList.Add(fciPayment);
}
return(retList);
}
public static List <FinanceCardInfo> GetByRateInPeriod(DateTime fromDate, DateTime toDate, List <int> lstBranhces,
List <int> lstInsuranceCompanies, List <int> lstInsuranceSubTypes, List <int> lstUsers, List <int> lstMarketingAgents)
{
decimal totSaldo = 0;
List <FinanceCardInfo> retList = new List <FinanceCardInfo>();
List <Rate> lstRates = Rate.GetInPeriod(fromDate, toDate, lstBranhces, lstInsuranceCompanies, lstInsuranceSubTypes, lstUsers, lstMarketingAgents);
foreach (Rate r in lstRates)
{
FinanceCardInfo fciRate = new FinanceCardInfo();
fciRate.PolicyNumber = r.PolicyItem.PolicyNumber;
fciRate.PolicyItemID = r.PolicyItemID;
fciRate.DocumentDate = r.PolicyItem.Policy.ApplicationDate;
fciRate.PaidDate = r.Date;
if (lstRates.Count == 1)
{
fciRate.Description = "Продадена полиса " + r.PolicyItem.PolicyNumber;
}
else
{
fciRate.Description = r.Number.ToString() + "-ва рата по полиса " + r.PolicyItem.PolicyNumber;
}
fciRate.DebtValue = r.Value;
fciRate.DemandValue = 0;
fciRate.SaldoValue = totSaldo + (fciRate.DebtValue - fciRate.DemandValue);
totSaldo = fciRate.SaldoValue;
retList.Add(fciRate);
}
return(retList);
}
public static List <FinanceCardInfo> GetByPolicy(Policy p, decimal totSaldo)
{
List <FinanceCardInfo> retList = new List <FinanceCardInfo>();
List <PolicyItem> lstPI = PolicyItem.GetByPolicy(p.ID);
foreach (PolicyItem pi in lstPI)
{
List <Rate> lstRates = Rate.GetByPolicyItemID(pi.ID);
List <Payment> lstPayment = Payment.GetByPolicyItemID(pi.ID);
foreach (Rate r in lstRates)
{
FinanceCardInfo fciRate = new FinanceCardInfo();
fciRate.DocumentDate = pi.Policy.ApplicationDate;
fciRate.PaidDate = r.Date;
if (lstRates.Count == 1)
{
fciRate.Description = "Продадена полиса " + pi.PolicyNumber;
}
else
{
fciRate.Description = r.Number.ToString() + "-ва рата по полиса " + pi.PolicyNumber;
}
fciRate.DebtValue = r.Value;
fciRate.DemandValue = 0;
fciRate.SaldoValue = totSaldo + (fciRate.DebtValue - fciRate.DemandValue);
totSaldo = fciRate.SaldoValue;
retList.Add(fciRate);
}
foreach (Payment payment in lstPayment)
{
FinanceCardInfo fciPayment = new FinanceCardInfo();
fciPayment.DocumentDate = payment.Date;
fciPayment.PaidDate = payment.Rate.Date;
if (lstRates.Count == 1)
{
fciPayment.Description = "Уплата по полиса " + pi.PolicyNumber;
}
else
{
fciPayment.Description = "Уплата за " + payment.Rate.Number + "-ва рата по полиса " + pi.PolicyNumber;
}
fciPayment.DebtValue = 0;
fciPayment.DemandValue = payment.Value;
fciPayment.SaldoValue = totSaldo + (fciPayment.DebtValue - fciPayment.DemandValue);
totSaldo = fciPayment.SaldoValue;
retList.Add(fciPayment);
}
}
return(retList);
}