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