private static void ProcessQuoteFooter(string quoteNumber, QuoteFooter footer, string spName)
{
try
{
SqlParameter pQuoteNumber = new SqlParameter();
pQuoteNumber.ParameterName = "QuoteNumber";
pQuoteNumber.Value = quoteNumber;
SqlParameter pSubTotal = new SqlParameter();
pSubTotal.ParameterName = "SubTotal";
pSubTotal.Value = footer.SubTotal;
SqlParameter pIsDollar = new SqlParameter();
pIsDollar.ParameterName = "IsDollar";
pIsDollar.Value = footer.IsDollar;
SqlParameter pEnergySurcharge = new SqlParameter();
pEnergySurcharge.ParameterName = "EnergySurcharge";
pEnergySurcharge.Value = footer.EnergySurcharge;
SqlParameter pDiscount = new SqlParameter();
pDiscount.ParameterName = "Discount";
pDiscount.Value = footer.Discount;
SqlParameter pDelivery = new SqlParameter();
pDelivery.ParameterName = "Delivery";
pDelivery.Value = footer.Delivery;
SqlParameter pIsRushOrder = new SqlParameter();
pIsRushOrder.ParameterName = "IsRush";
pIsRushOrder.Value = footer.IsRushOrder;
SqlParameter pRushOrder = new SqlParameter();
pRushOrder.ParameterName = "RushOrder";
pRushOrder.Value = footer.RushOrder;
SqlParameter pTax = new SqlParameter();
pTax.ParameterName = "Tax";
pTax.Value = footer.Tax;
SqlParameter pGrandTotal = new SqlParameter();
pGrandTotal.ParameterName = "GrandTotal";
pGrandTotal.Value = footer.GrandTotal;
SQLHelper.ExecuteStoredProcedure(spName, pQuoteNumber, pSubTotal, pIsDollar, pEnergySurcharge, pDiscount, pDelivery, pIsRushOrder, pRushOrder, pTax, pGrandTotal);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
internal static void SaveQuoteFooter(string quoteNumber, QuoteFooter footer)
{
try
{
ProcessQuoteFooter(quoteNumber, footer, StoredProcedures.InsertQuoteFooter);
}
catch (Exception ex)
{
Logger.LogException(ex);
}
}
internal static void UpdateQuoteFooter(string quoteNumber, QuoteFooter footer)
{
ProcessQuoteFooter(quoteNumber, footer, StoredProcedures.UpdateQuoteFooter);
}
private QuoteFooter BuildQuoteFooter()
{
QuoteFooter footer = new QuoteFooter();
try
{
footer.SubTotal = double.Parse(lblSubTotal.Content.ToString().Replace("$ ", string.Empty));
footer.IsDollar = cbDollar.IsChecked.Value == true;
footer.EnergySurcharge = double.Parse(txtEnergySurcharge.Text);
footer.Discount = double.Parse(txtDiscount.Text);
footer.Delivery = double.Parse(txtDelivery.Text);
footer.IsRushOrder = cbRush.IsChecked.Value == true;
footer.RushOrder = double.Parse(txtRushOrder.Text);
footer.Tax = applyTaxInPercentage;
//footer.Tax = double.Parse(txtTax.Text);
footer.GrandTotal = double.Parse(lblGrandTotal.Content.ToString().Replace("$ ", string.Empty));
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return footer;
}
