public List <SqlParameter> SetValuesInCharges(ChargesInfo charges)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (charges.ChargesId != 0)
{
sqlParam.Add(new SqlParameter("ChargesId", charges.ChargesId));
}
else
{
sqlParam.Add(new SqlParameter("CreatedDate", charges.CreatedDate));
sqlParam.Add(new SqlParameter("CreatedBy", charges.CreatedBy));
}
sqlParam.Add(new SqlParameter("ChargesName", charges.ChargesName));
Logger.Debug("Charges Controller ChargesName:" + charges.ChargesName);
sqlParam.Add(new SqlParameter("Abbreviation", charges.Abbreviation));
Logger.Debug("Charges Controller Abbreviation:" + charges.Abbreviation);
sqlParam.Add(new SqlParameter("ChargesBehaviour", charges.ChargesBehaviour));
Logger.Debug("Charges Controller ChargesBehaviour:" + charges.ChargesBehaviour);
sqlParam.Add(new SqlParameter("IsActive", charges.IsActive));
Logger.Debug("Charges Controller IsActive:" + charges.IsActive);
sqlParam.Add(new SqlParameter("UpdatedBy", charges.UpdatedBy));
sqlParam.Add(new SqlParameter("UpdatedDate", charges.UpdatedDate));
return(sqlParam);
}
private ChargesInfo GetChargesValues(DataRow dr)
{
ChargesInfo Charges = new ChargesInfo();
Charges.ChargesId = Convert.ToInt32(dr["ChargesId"]);
if (!dr.IsNull("ChargesName"))
{
Charges.ChargesName = Convert.ToString(dr["ChargesName"]);
}
if (!dr.IsNull("Abbreviation"))
{
Charges.Abbreviation = Convert.ToString(dr["Abbreviation"]);
}
if (!dr.IsNull("IsActive"))
{
Charges.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
if (!dr.IsNull("IsStandardPrice"))
{
Charges.IsStandardPrice = Convert.ToBoolean(dr["IsStandardPrice"]);
}
return(Charges);
}
public ChargesViewModel()
{
Charges = new ChargesInfo();
ChargesList = new List <ChargesInfo>();
Filter = new ChargesFilter();
Pager = new PaginationInfo();
FriendlyMessage = new List <FriendlyMessage>();
}
public HotelTariffTaxUpdationController()
{
charges = new ChargesInfo();
_htuRepo = new HotelTariffTaxUpdationRepo();
_tRepo = new TaxFormulaRepo();
_cRepo = new ChargesRepo();
_htRepo = new HotelTariffRepo();
}
public HotelTariffTaxUpdationViewModel()
{
HotelTariffTax = new HotelTariffTaxUpdationInfo();
HotelTariffTaxes = new List <HotelTariffTaxUpdationInfo>();
Vendors = new List <VendorInfo>();
Hotels = new List <HotelInfo>();
Meals = new List <MealInfo>();
Pager = new PaginationInfo();
FriendlyMessage = new List <FriendlyMessage>();
//for date details
HotelTariffDate = new HotelTariffDateDetailsInfo();
HotelTariffDates = new List <HotelTariffDateDetailsInfo>();
//for duration
HotelTariffDuration = new HotelTariffDurationDetailsInfo();
HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>();
//for price
HotelTariffPrice = new HotelTariffPriceDetailsInfo();
HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>();
//for room
HotelTariffRoom = new HotelTariffRoomDetailsInfo();
HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>();
// Tax Formula
LstStandardCharges = new List <ChargesInfo>();
LstTaxFormula = new List <TaxFormulaInfo>();
LstTaxFormula = new List <TaxFormulaInfo>();
//Charges
Charges = new ChargesInfo();
}
public ChargesInfo GetChargeTypeValues(DataRow dr)
{
ChargesInfo retVal = new ChargesInfo();
retVal.ChargesId = Convert.ToInt32(dr["ChargesId"]);
retVal.ChargesName = Convert.ToString(dr["ChargesName"]);
if (dr["IsStandardPrice"] != DBNull.Value)
{
retVal.IsStandardPrice = Convert.ToBoolean(dr["IsStandardPrice"]);
}
return(retVal);
}
private ChargesInfo SetStandardCharges(DataRow dr)
{
ChargesInfo chargesInfo = new ChargesInfo();
if (dr["ChargesId"] != DBNull.Value)
{
chargesInfo.ChargesId = Convert.ToInt32(dr["ChargesId"]);
}
if (dr["Abbreviation"] != DBNull.Value)
{
chargesInfo.Abbreviation = Convert.ToString(dr["Abbreviation"]);
}
return(chargesInfo);
}
public ChargesInfo GetChargesById(int chargesId)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
ChargesInfo Charges = new ChargesInfo();
sqlParam.Add(new SqlParameter("@ChargesId", chargesId));
Logger.Debug("Charges Controller ChargesId:" + chargesId);
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetChargesById.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Charges = GetChargesValues(dr);
}
}
return(Charges);
}
public void Update(ChargesInfo charges)
{
_sqlHelper.ExecuteNonQuery(SetValuesInCharges(charges), Storeprocedures.spUpdateCharges.ToString(), CommandType.StoredProcedure);
}
public int Insert(ChargesInfo charges)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInCharges(charges), Storeprocedures.spInsertCharges.ToString(), CommandType.StoredProcedure)));
}
