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