public static int AddEditChargeRates(IChargeRate ChargeRate) { string strExecution = "[mst].[spAddEditChargeRates]"; int Result = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddIntegerParam("@ChargesRateID", ChargeRate.ChargesRateID); oDq.AddIntegerParam("@ChargesID", ChargeRate.ChargesID); oDq.AddIntegerParam("@LocationId", ChargeRate.LocationId); oDq.AddIntegerParam("@TerminalId", ChargeRate.TerminalId); oDq.AddIntegerParam("@WashingType", ChargeRate.WashingType); oDq.AddIntegerParam("@High", ChargeRate.High); oDq.AddIntegerParam("@Low", ChargeRate.Low); oDq.AddDecimalParam("@RatePerBL", 12, 2, ChargeRate.RatePerBL); oDq.AddDecimalParam("@RatePerTEU", 12, 2, ChargeRate.RatePerTEU); oDq.AddDecimalParam("@RatePerFEU", 12, 2, ChargeRate.RatePerFEU); oDq.AddDecimalParam("@RatePerTON", 12, 2, ChargeRate.RatePerTON); oDq.AddDecimalParam("@RatePerCBM", 12, 2, ChargeRate.RatePerCBM); oDq.AddDecimalParam("@SharingBL", 12, 2, ChargeRate.SharingBL); oDq.AddDecimalParam("@SharingTEU", 12, 2, ChargeRate.SharingTEU); oDq.AddDecimalParam("@SharingFEU", 12, 2, ChargeRate.SharingFEU); oDq.AddBooleanParam("@RateActive", ChargeRate.RateActive); oDq.AddIntegerParam("@Type", ChargeRate.Type); oDq.AddNVarcharParam("@Size", 2, ChargeRate.Size); oDq.AddDecimalParam("@RatePerUnit", 12, 2, ChargeRate.RatePerUnit); oDq.AddDecimalParam("@RatePerDoc", 12, 2, ChargeRate.RatePerDoc); oDq.AddIntegerParam("@RESULT", Result, QueryParameterDirection.Output); oDq.RunActionQuery(); Result = Convert.ToInt32(oDq.GetParaValue("@Result")); } return(Result); }
public static int SaveInvoiceChargesFwd(IChargeRate cRate) { string strExecution = "[fwd].[uspFwd_Invoice_Charges_Save]"; int invoiceChargeId = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@InvoiceID", cRate.InvoiceId); if (cRate.InvoiceChargeId > 0) { oDq.AddBigIntegerParam("@InvoiceChargeID", cRate.InvoiceChargeId); } oDq.AddIntegerParam("@ChargeID", cRate.ChargesID); oDq.AddIntegerParam("@ChargeRateID", cRate.ChargesRateID); oDq.AddDecimalParam("@RatePerUnit", 12, 2, cRate.RatePerBL); oDq.AddDecimalParam("@Units", 12, 2, cRate.Units); oDq.AddVarcharParam("@Size", 2, cRate.Size); oDq.AddIntegerParam("@UnitType", cRate.UnitTypeID); //oDq.AddDecimalParam("@RatePerTEU", 12, 2, cRate.RatePerTEU); //oDq.AddDecimalParam("@RatePerFEU", 12, 2, cRate.RatePerFEU); //oDq.AddDecimalParam("@RatePerCBM", 12, 2, cRate.RatePerCBM); //oDq.AddDecimalParam("@RatePerTon", 12, 2, cRate.RatePerTON); oDq.AddDecimalParam("@RateUSD", 12, 2, 0); oDq.AddDecimalParam("@GrossAmount", 12, 2, cRate.GrossAmount); oDq.AddDecimalParam("@ServiceTaxAmount", 12, 2, cRate.ServiceTax); oDq.AddDecimalParam("@ServiceTaxCessAmount", 12, 2, cRate.ServiceTaxCessAmount); oDq.AddDecimalParam("@ServiceTaxACess", 12, 2, cRate.ServiceTaxACess); oDq.AddDecimalParam("@ServTaxPer", 12, 2, cRate.STaxPer); //oDq.AddBigIntegerParam("@TerminalId", cRate.TerminalId); //oDq.AddDecimalParam("@SharingBL", 12, 2, 0); //oDq.AddDecimalParam("@SharingTEU", 12, 2, 0); //oDq.AddDecimalParam("@SharingFEU", 12, 2, 0); oDq.AddIntegerParam("@CurId", cRate.fk_CurrencyID); oDq.AddDecimalParam("@ExchgRt", 12, 2, cRate.ExchgRate); invoiceChargeId = Convert.ToInt32(oDq.GetScalar()); } return(invoiceChargeId); }
public static int SaveInvoiceCharges(IChargeRate cRate) { string strExecution = "usp_Invoice_Charges_Save"; int invoiceChargeId = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@InvoiceID", cRate.InvoiceId); if (cRate.InvoiceChargeId > 0) { oDq.AddBigIntegerParam("@InvoiceChargeID", cRate.InvoiceChargeId); } oDq.AddIntegerParam("@ChargeID", cRate.ChargesID); oDq.AddDecimalParam("@RatePerUnit", 12, 2, cRate.RatePerBL); oDq.AddDecimalParam("@RatePerTEU", 12, 2, cRate.RatePerTEU); oDq.AddDecimalParam("@RatePerFEU", 12, 2, cRate.RatePerFEU); oDq.AddDecimalParam("@RatePerCBM", 12, 2, cRate.RatePerCBM); oDq.AddDecimalParam("@RatePerTon", 12, 2, cRate.RatePerTON); oDq.AddDecimalParam("@RateUSD", 12, 2, cRate.Usd); oDq.AddDecimalParam("@GrossAmount", 12, 2, cRate.GrossAmount); oDq.AddDecimalParam("@ServiceTaxAmount", 12, 2, cRate.STax); oDq.AddDecimalParam("@ServiceTaxCessAmount", 12, 2, cRate.ServiceTaxCessAmount); oDq.AddDecimalParam("@ServiceTaxACess", 12, 2, cRate.ServiceTaxACess); oDq.AddBigIntegerParam("@TerminalId", cRate.TerminalId); oDq.AddDecimalParam("@SharingBL", 12, 2, cRate.SharingBL); oDq.AddDecimalParam("@SharingTEU", 12, 2, cRate.SharingTEU); oDq.AddDecimalParam("@SharingFEU", 12, 2, cRate.SharingFEU); invoiceChargeId = Convert.ToInt32(oDq.GetScalar()); } return(invoiceChargeId); }
public int AddEditChargeRates(IChargeRate ChargeRate) { return(ChargeDAL.AddEditChargeRates(ChargeRate)); }