/// <summary>
/// Updates the argued QuoteSummary object with MultiRate data.
/// </summary>
/// <param name="header">BusinessLogic.Header</param>
/// <param name="quote">BusinessLogic.Quote</param>
/// <param name="coverage">BusinessLogic.Coverage</param>
/// <param name="qSummary">reference of the QuoteSummary object to update</param>
private static void BindMultiRateForForm3(Header header, Quote quote, Coverage coverage, ref QuoteSummary qSummary)
{
DataTable table = DirectWebDAC.GetMultirate(header.SessionID);
for (var i = 0; i < table.Rows.Count; i++)
{
string totalPremium = table.Rows[i]["PolicyPremiumAmt"].ToString().Trim().Replace("$", "");
string deductible = table.Rows[i]["Deductible"].ToString().Trim();
string windHailOrHurricane = (table.Rows[i]["WindHailOrHurricane"] == null) ? string.Empty : table.Rows[i]["WindHailOrHurricane"].ToString().Trim();
decimal? covEAmount = (table.Rows[i]["CovEAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovEAmount"];
decimal? covFAmount = (table.Rows[i]["CovFAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovFAmount"];
decimal? covCAmount = (table.Rows[i]["CovCAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovCAmount"];
decimal? covAAmount = (table.Rows[i]["CovAAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovAAmount"];
decimal? increasedCovAAmount = (table.Rows[i]["IncreasedCovAAmount"] == null) ? 0 : (decimal?)table.Rows[i]["IncreasedCovAAmount"];
int coveredPerils = (table.Rows[i]["coveredPerils"] == null) ? 0 : (int)table.Rows[i]["coveredPerils"];
string multirateOptions = table.Rows[i]["MultirateOptions"].ToString().Trim();
DateTime ratingDate = DirectWebDAC.GetRatingDate(DateTime.Parse(coverage.PolicyEffDate),
quote.InitialQuoteRequestDt.HasValue ? quote.InitialQuoteRequestDt.Value : DateTime.Now,
header.State);
DataSet premiumDisplay = DirectWebDAC.GetPremiumDisplay(
Convert.ToInt32(table.Rows[i]["RatingCaseNumber"]),
header.PartnerID ?? -1,
header.State ?? "",
ratingDate,
(int)header.UnderwritingNumber);
var premiumDiscounts = (ISODataProvider.GetPremiumDiscountsDataTable)premiumDisplay.Tables["GetPremiumDiscounts"];
var discounts = new ControlDataSource(premiumDiscounts, "display", "premium", "Discounts");
double totalDiscount = 0;
foreach (var discount in discounts.Items)
{
if (discount.Value == "" || discount.Key == "Total Discounts and Surcharges" || discount.Key == "ACV Roof Loss Settlement (Wind/Hail) for roofs older than 10 years")
{
continue;
}
double val = Convert.ToDouble(discount.Value);
if (val < 0)
{
totalDiscount = totalDiscount - val;
}
}
DirectWebDAC.InsertOrUpdateMultirate(header.SessionID, deductible, (Convert.ToInt32(table.Rows[i]["IsDeductibleSelected"]) == 1) ? 1 : 0, table.Rows[i]["RatingCaseNumber"].ToString().Trim(), totalPremium, windHailOrHurricane, totalDiscount.ToString(), covEAmount, covFAmount, multirateOptions, covCAmount, covAAmount, Convert.ToInt32(coveredPerils), string.Empty, 0, 0, 0, increasedCovAAmount);
switch (multirateOptions)
{
case "Option1":
qSummary.TotalPremium1 = totalPremium;
qSummary.Deductible1 = deductible;
qSummary.TotalDiscount1 = totalDiscount.ToString("f2");
qSummary.CovEAmount1 = covEAmount.ToString();
qSummary.CovFAmount1 = covFAmount.ToString();
qSummary.CovCAmount1 = covCAmount.ToString();
qSummary.CovAAmount1 = covAAmount.ToString();
qSummary.IncreasedCovAAmount1 = increasedCovAAmount.ToString();
qSummary.MultirateOption1 = multirateOptions;
qSummary.coveredPerils1 = (coveredPerils == 0) ? "standard" : "extended";
break;
case "Option2":
qSummary.TotalPremium2 = totalPremium;
qSummary.Deductible2 = deductible;
qSummary.TotalDiscount2 = totalDiscount.ToString("f2");
qSummary.CovEAmount2 = covEAmount.ToString();
qSummary.CovFAmount2 = covFAmount.ToString();
qSummary.CovCAmount2 = covCAmount.ToString();
qSummary.CovAAmount2 = covAAmount.ToString();
qSummary.IncreasedCovAAmount2 = increasedCovAAmount.ToString();
qSummary.MultirateOption2 = multirateOptions;
qSummary.coveredPerils2 = (coveredPerils == 0) ? "standard" : "extended";
break;
case "Option3":
qSummary.TotalPremium3 = totalPremium;
qSummary.Deductible3 = deductible;
qSummary.TotalDiscount3 = totalDiscount.ToString("f2");
qSummary.CovEAmount3 = covEAmount.ToString();
qSummary.CovFAmount3 = covFAmount.ToString();
qSummary.CovCAmount3 = covCAmount.ToString();
qSummary.CovAAmount3 = covAAmount.ToString();
qSummary.IncreasedCovAAmount3 = increasedCovAAmount.ToString();
qSummary.MultirateOption3 = multirateOptions;
qSummary.coveredPerils3 = (coveredPerils == 0) ? "standard" : "extended";
break;
}
}
qSummary.CovAAmount = coverage.CovAAmount;
qSummary.MedicalPaymentLimit = coverage.MedicalPaymentLimit;
qSummary.PersonalLiabilityLimit = coverage.PersonalLiabilityLimit;
}
/// <summary>
/// Updates the argued QuoteSummary object with MultiRate data. This is only used in ConsumerWeb - HO4
/// </summary>
/// <param name="header">BusinessLogic.Header</param>
/// <param name="quote">BusinessLogic.Quote</param>
/// <param name="coverage">BusinessLogic.Coverage</param>
/// <param name="qSummary">reference of the QuoteSummary object to update</param>
private static void BindMultiRateForForm4(Header header, Quote quote, Coverage coverage, ref QuoteSummary qSummary)
{
DataTable table = DirectWebDAC.GetMultirate(header.SessionID);
for (var i = 0; i < table.Rows.Count; i++)
{
var totalPremium = table.Rows[i]["PolicyPremiumAmt"].ToString().Trim().Replace("$", "");
var deductible = table.Rows[i]["Deductible"].ToString().Trim();
var covCAmount = (table.Rows[i]["CovCAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovCAmount"];
var covEAmount = (table.Rows[i]["CovEAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovEAmount"];
var covFAmount = (table.Rows[i]["CovFAmount"] == null) ? 0 : (decimal?)table.Rows[i]["CovFAmount"];
var multirateOptions = table.Rows[i]["MultirateOptions"].ToString().Trim();
DateTime ratingDate = DirectWebDAC.GetRatingDate(DateTime.Parse(coverage.PolicyEffDate),
quote.InitialQuoteRequestDt.HasValue ? quote.InitialQuoteRequestDt.Value : DateTime.Now,
header.State);
var premiumDisplay = DirectWebDAC.GetPremiumDisplay(
Convert.ToInt32(table.Rows[i]["RatingCaseNumber"].ToString()), header.PartnerID ?? -1,
header.State ?? "", ratingDate, (int)header.UnderwritingNumber);
var premiumDiscounts = (ISODataProvider.GetPremiumDiscountsDataTable)premiumDisplay.Tables["GetPremiumDiscounts"];
var discounts = new ControlDataSource(premiumDiscounts, "display", "premium", "Discounts");
double totalDiscount = 0;
foreach (var discount in discounts.Items)
{
if (discount.Value == "" || discount.Key == "Total Discounts and Surcharges" || discount.Key == "ACV Roof Loss Settlement (Wind/Hail) for roofs older than 10 years")
{
continue;
}
double val = Convert.ToDouble(discount.Value);
if (val < 0)
{
totalDiscount = totalDiscount - val;
}
}
var EftStateFee = header.State == "AL" ? "$2.60" : header.State == "KY" ? "$2.50" : header.State == "NC" ? "$0.00" : header.State == "TN" ? "$0.00" : header.State.Equals("FL") ? "$1.00" : "$3.00";
string totalPrice = (Convert.ToDouble(totalPremium) + totalDiscount).ToString();
string monthlyPaymentPlan;
string downPayment;
int numInstallments;
Structure structure = Structure.GetStructure(header.SessionID);
int propertyType = 0;
if (!String.IsNullOrEmpty(structure.PropertyType))
{
propertyType = Convert.ToInt32(structure.PropertyType);
}
QuoteServices.ProcessMonthlyPremiumData(header.State, quote.CompanysQuoteNumber, ((DateTime)ratingDate).ToString("MM/dd/yyyy"), totalPremium, propertyType,
out monthlyPaymentPlan, out downPayment, out numInstallments);
DirectWebDAC.InsertOrUpdateMultirate(header.SessionID, deductible, (Convert.ToInt32(table.Rows[i]["IsDeductibleSelected"]) == 1) ? 1 : 0, table.Rows[i]["RatingCaseNumber"].ToString().Trim(), totalPremium, string.Empty, totalDiscount.ToString(), covEAmount, covFAmount, multirateOptions, 0, 0, 0, totalPrice, Convert.ToDecimal(monthlyPaymentPlan.Trim().Replace("$", "")), Convert.ToDecimal(downPayment.Trim().Replace("$", "")), numInstallments, 0);
switch (multirateOptions)
{
case "Option1":
qSummary.TotalPremium1 = totalPremium;
qSummary.Deductible1 = deductible;
qSummary.TotalDiscount1 = totalDiscount.ToString("f2");
qSummary.CovCAmount1 = covCAmount.ToString();
qSummary.CovEAmount1 = covEAmount.ToString();
qSummary.CovFAmount1 = covFAmount.ToString();
qSummary.MultirateOption1 = multirateOptions;
qSummary.TotalPrice1 = totalPrice;
qSummary.MonthlyPayPlan1 = monthlyPaymentPlan;
qSummary.Downpayment1 = downPayment;
qSummary.NumInstallments1 = numInstallments;
break;
case "Option2":
qSummary.TotalPremium2 = totalPremium;
qSummary.Deductible2 = deductible;
qSummary.TotalDiscount2 = totalDiscount.ToString("f2");
qSummary.CovCAmount2 = covCAmount.ToString();
qSummary.CovEAmount2 = covEAmount.ToString();
qSummary.CovFAmount2 = covFAmount.ToString();
qSummary.MultirateOption2 = multirateOptions;
qSummary.TotalPrice2 = totalPrice;
qSummary.MonthlyPayPlan2 = monthlyPaymentPlan;
qSummary.Downpayment2 = downPayment;
qSummary.NumInstallments2 = numInstallments;
break;
case "Option3":
qSummary.TotalPremium3 = totalPremium;
qSummary.Deductible3 = deductible;
qSummary.TotalDiscount3 = totalDiscount.ToString("f2");
qSummary.CovCAmount3 = covCAmount.ToString();
qSummary.CovEAmount3 = covEAmount.ToString();
qSummary.CovFAmount3 = covFAmount.ToString();
qSummary.MultirateOption3 = multirateOptions;
qSummary.TotalPrice3 = totalPrice;
qSummary.MonthlyPayPlan3 = monthlyPaymentPlan;
qSummary.Downpayment3 = downPayment;
qSummary.NumInstallments3 = numInstallments;
break;
}
}
qSummary.MedicalPaymentLimit = coverage.MedicalPaymentLimit;
qSummary.PersonalLiabilityLimit = coverage.PersonalLiabilityLimit;
}
/// <summary>
/// Updates the argued QuoteSummary object with MultiRate data. This is only used in ConsumerWeb.
/// </summary>
/// <param name="header">BusinessLogic.Header</param>
/// <param name="quote">BusinessLogic.Quote</param>
/// <param name="coverage">BusinessLogic.Coverage</param>
/// <param name="qSummary">reference of the QuoteSummary object to update</param>
public static void UpdateMultiRateToQuoteSummary(Header header, Quote quote, Coverage coverage, ref QuoteSummary qSummary)
{
switch (header.FormNumber)
{
case 3:
BindMultiRateForForm3(header, quote, coverage, ref qSummary);
break;
case 4:
BindMultiRateForForm4(header, quote, coverage, ref qSummary);
break;
}
}