private TaxFormulaChargesInfo GetTaxFormulaCharges(DataRow dr, int taxFormulaId)
{
TaxFormulaChargesInfo taxFormulaCharges = new TaxFormulaChargesInfo();
taxFormulaCharges.TaxFormulaId = taxFormulaId;
if (dr["ChargesId"] != DBNull.Value)
{
taxFormulaCharges.ChargesId = Convert.ToInt32(dr["ChargesId"]);
}
if (dr["ChargesName"] != DBNull.Value)
{
taxFormulaCharges.ChargesName = Convert.ToString(dr["ChargesName"]);
}
if (dr["ChargeFormula"] != DBNull.Value)
{
taxFormulaCharges.ChargeFormula = Convert.ToString(dr["ChargeFormula"]);
}
if (dr["ChargeFormulaText"] != DBNull.Value)
{
taxFormulaCharges.ChargeFormulaText = Convert.ToString(dr["ChargeFormulaText"]);
}
return(taxFormulaCharges);
}
public int InsertTaxFormulaCharge(TaxFormulaChargesInfo taxformulacharge, int taxFormulaId)
{
// Insert into "Tax Formula Charges"
int rowcount = Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInTaxFormulaCharge(taxformulacharge, taxFormulaId), Storeprocedures.spInsertTaxFormulaCharges.ToString(), CommandType.StoredProcedure));
return(rowcount);
}
private TaxFormulaChargesInfo GetHotelTariffTaxFormulaCharges(DataRow dr)
{
TaxFormulaChargesInfo taxFormulaCharges = new TaxFormulaChargesInfo();
if (dr["ChargesId"] != DBNull.Value)
{
taxFormulaCharges.ChargesId = Convert.ToInt32(dr["ChargesId"]);
}
if (dr["ChargesName"] != DBNull.Value)
{
taxFormulaCharges.ChargesName = Convert.ToString(dr["ChargesName"]);
}
if (dr["ChargeFormula"] != DBNull.Value)
{
taxFormulaCharges.ChargeFormula = Convert.ToString(dr["ChargeFormula"]);
}
if (dr["ChargeFormulaText"] != DBNull.Value)
{
taxFormulaCharges.ChargeFormulaText = Convert.ToString(dr["ChargeFormulaText"]);
}
if (dr["Percentage"] != DBNull.Value)
{
taxFormulaCharges.HotelTariffCharge.Percentage = Convert.ToDecimal(dr["Percentage"]);
}
if (dr["CalculatedPrice"] != DBNull.Value)
{
taxFormulaCharges.HotelTariffCharge.CalculatedPrice = Convert.ToDecimal(dr["CalculatedPrice"]);
}
if (dr["TotalTaxPrice"] != DBNull.Value)
{
taxFormulaCharges.HotelTariffCharge.TotalTaxPrice = Convert.ToDecimal(dr["TotalTaxPrice"]);
}
//if (dr["HotelTariffChargesDetailsId"] != DBNull.Value)
//{
// taxFormulaCharges.HotelTariffCharge.HotelTariffChargesDetailsId = Convert.ToInt32(dr["HotelTariffChargesDetailsId"]);
//}
return(taxFormulaCharges);
}
private List <SqlParameter> SetValuesInTaxFormulaCharge(TaxFormulaChargesInfo taxformulacharges, int taxFormulaId)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@TaxFormulaId", taxFormulaId));
Logger.Debug("TaxFormula Controller TaxFormulaId:" + taxFormulaId);
sqlParams.Add(new SqlParameter("@ChargesId", taxformulacharges.ChargesId));
Logger.Debug("TaxFormula Controller ChargesId:" + taxformulacharges.ChargesId);
sqlParams.Add(new SqlParameter("@ChargeFormula", taxformulacharges.ChargeFormula));
Logger.Debug("TaxFormula Controller ChargesFormula:" + taxformulacharges.ChargeFormula);
sqlParams.Add(new SqlParameter("@OldChargesId", taxformulacharges.OldChargesId));
Logger.Debug("TaxFormula Controller OldChargesId:" + taxformulacharges.OldChargesId);
return(sqlParams);
}
