public List <SqlParameter> SetValuesInSupplierHotelDetailInfo(SupplierHotelDetailInfo supplierHotelDetailInfo)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (supplierHotelDetailInfo.SupplierHoteDetaillId != 0)
{
sqlParam.Add(new SqlParameter("@SupplierHotelDetailId", supplierHotelDetailInfo.SupplierHoteDetaillId));
}
else
{
sqlParam.Add(new SqlParameter("@CreatedDate", supplierHotelDetailInfo.CreatedDate));
sqlParam.Add(new SqlParameter("@CreatedBy", supplierHotelDetailInfo.CreatedBy));
}
sqlParam.Add(new SqlParameter("@SupplierHotelId", supplierHotelDetailInfo.SupplierHotelId));
sqlParam.Add(new SqlParameter("@CityId", supplierHotelDetailInfo.CityId));
sqlParam.Add(new SqlParameter("@HotelId", supplierHotelDetailInfo.HotelId));
sqlParam.Add(new SqlParameter("@RoomTypeId", supplierHotelDetailInfo.RoomTypeId));
sqlParam.Add(new SqlParameter("@MealId", supplierHotelDetailInfo.MealId));
sqlParam.Add(new SqlParameter("@TotalNights", supplierHotelDetailInfo.TotalNights));
sqlParam.Add(new SqlParameter("@MealInclusions", supplierHotelDetailInfo.MealInclusions));
sqlParam.Add(new SqlParameter("@UpdatedDate", supplierHotelDetailInfo.UpdatedDate));
sqlParam.Add(new SqlParameter("@UpdatedBy", supplierHotelDetailInfo.UpdatedBy));
return(sqlParam);
}
public SupplierHotelTariffViewModel()
{
SupplierHotelTariff = new SupplierHotelTariffInfo();
SupplierHotelDetail = new SupplierHotelDetailInfo();
SupplierOccupancyDetail = new SupplierOccupancyDetailInfo();
SupplierHotelCustomerCategory = new SupplierHotelCustomerCategoryInfo();
SupplierHotelCustomerCategories = new List <SupplierHotelCustomerCategoryInfo>();
LstVendor = new List <VendorInfo>();
LstCities = new List <CityInfo>();
LstRoomTypes = new List <RoomTypeInfo>();
LstMeals = new List <MealInfo>();
LstHotel = new List <HotelInfo>();
FriendlyMessage = new List <FriendlyMessage>();
SupplierHotelTariffDuration = new SupplierHotelTariffDurationInfo();
SupplierHotelTariffDurations = new List <SupplierHotelTariffDurationInfo>();
LstStandardCharges = new List <ChargesInfo>();
LstSupplierHotelPriceDetail = new List <SupplierHotelPriceDetailInfo>();
LstSupplierHotelPrice = new List <SupplierHotelPriceInfo>();
CustomerCategories = new List <CustomerCategoryInfo>();
LstStandardCharges = new List <ChargesInfo>();
LstTaxFormula = new List <TaxFormulaInfo>();
LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>();
SupplierHotelPrice = new SupplierHotelPriceInfo();
Pager = new PaginationInfo();
Cities = new List <CityInfo>();
SupplierHotelTariffDayInfo = new SupplierHotelTariffDayInfo();
SupplierHotelTariffDays = new List <SupplierHotelTariffDayInfo>();
SupplierHotelDayItem = new SupplierHotelDayItemInfo();
SupplierHotelDayItems = new List <SupplierHotelDayItemInfo>();
}
public void UpdateSupplierHotelDetail(SupplierHotelDetailInfo supplierHotelDetailInfo)
{
_sqlHelper.ExecuteNonQuery(SetValuesInSupplierHotelDetailInfo(supplierHotelDetailInfo), Storeprocedures.spUpdateSupplierHotelDetail.ToString(), CommandType.StoredProcedure);
}
