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 DataTable GetHotelTariffTaxUpdation(HotelTariffTaxUpdationInfo hotelTax, ref PaginationInfo pager)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
sqlParam.Add(new SqlParameter("@VendorId", hotelTax.VendorId));
sqlParam.Add(new SqlParameter("@HotelId", hotelTax.HotelId));
sqlParam.Add(new SqlParameter("@RoomTypeId", hotelTax.RoomTypeId));
sqlParam.Add(new SqlParameter("@MealId", hotelTax.MealId));
sqlParam.Add(new SqlParameter("@FormulaId", hotelTax.FormulaId));
if (hotelTax.FromDate == DateTime.MinValue)
{
DateTime?someDate = null;
sqlParam.Add(new SqlParameter("@FromDate", someDate));
}
else
{
sqlParam.Add(new SqlParameter("@FromDate", hotelTax.FromDate));
}
if (hotelTax.ToDate == DateTime.MinValue)
{
DateTime?someDate = null;
sqlParam.Add(new SqlParameter("@ToDate", someDate));
}
else
{
sqlParam.Add(new SqlParameter("@ToDate", hotelTax.ToDate));
}
//sqlParam.Add(new SqlParameter("@FromDate", null));
//sqlParam.Add(new SqlParameter("@ToDate", null));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetHotelTariffTax.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
return(CommonMethods.GetPaginatedTable(dt, ref pager));
}
public void UpdateHotelTariffPriceDetails(List <HotelTariffPriceDetailsInfo> hoteltariffpricedetails, HotelTariffPriceDetailsInfo hoteltariffpricedetail, HotelTariffTaxUpdationInfo hoteltax)
{
foreach (var item in hoteltariffpricedetails)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@HotelTariffPriceDetailsId", item.HotelTariffPriceDetailsId));
sqlParams.Add(new SqlParameter("@HotelTariffDurationDetailsId", item.HotelTariffDurationDetailsId));
Logger.Debug("HotelTariff Controller HotelTariffDurationDetailsId:" + item.HotelTariffDurationDetailsId);
sqlParams.Add(new SqlParameter("@HotelTariffRoomOccupancyId", item.HotelTariffRoomOccupancyId));
Logger.Debug("HotelTariff Controller HotelTariffRoomOccupancyId:" + item.HotelTariffRoomOccupancyId);
sqlParams.Add(new SqlParameter("@HotelTariffId", item.HotelTariffId));
Logger.Debug("HotelTariff Controller HotelTariffId:" + item.HotelTariffId);
sqlParams.Add(new SqlParameter("@PublishPrice", item.PublishPrice));
Logger.Debug("HotelTariff Controller PublishPrice:" + item.PublishPrice);
sqlParams.Add(new SqlParameter("@SpecialPrice", item.SpecialPrice));
Logger.Debug("HotelTariff Controller SpecialPrice:" + item.SpecialPrice);
sqlParams.Add(new SqlParameter("@CommissionPrice", item.CommissionPrice));
Logger.Debug("HotelTariff Controller CommissionPrice:" + item.CommissionPrice);
sqlParams.Add(new SqlParameter("@FormulaId", hoteltax.TaxFormulaId));
Logger.Debug("HotelTariff Controller TaxFormulaId:" + hoteltax.TaxFormulaId);
sqlParams.Add(new SqlParameter("@TotalTaxPrice", item.TotalTaxPrice));
Logger.Debug("HotelTariff Controller TotalTaxPrice:" + item.TotalTaxPrice);
sqlParams.Add(new SqlParameter("@NetRate", item.NetRate));
Logger.Debug("HotelTariff Controller NetRate:" + item.NetRate);
sqlParams.Add(new SqlParameter("@NetRatePerNight", item.NetRatePerNight));
Logger.Debug("HotelTariff Controller NetRatePerNight:" + item.NetRatePerNight);
sqlParams.Add(new SqlParameter("@UpdatedDate", item.UpdatedDate));
sqlParams.Add(new SqlParameter("@UpdatedBy", item.UpdatedBy));
_sqlHelper.ExecuteNonQuery(sqlParams, Storeprocedures.spUpdateHotelTariffPriceDetails.ToString(), CommandType.StoredProcedure);
}
//DeletHotelTariffCharges(hoteltariffpricedetail);
//InsertPriceChargesDetails(hoteltariffpricedetail);
}
