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