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