public List <SqlParameter> SetValuesInSupplierOccupancyDetailInfo(SupplierOccupancyDetailInfo SupplierOccupancyDetail)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (SupplierOccupancyDetail.OccupancyDetailId != 0)
{
sqlParam.Add(new SqlParameter("@OccupancyDetailId", SupplierOccupancyDetail.OccupancyDetailId));
}
else
{
sqlParam.Add(new SqlParameter("@CreatedDate", SupplierOccupancyDetail.CreatedDate));
sqlParam.Add(new SqlParameter("@CreatedBy", SupplierOccupancyDetail.CreatedBy));
}
sqlParam.Add(new SqlParameter("@SupplierHotelId", SupplierOccupancyDetail.SupplierHotelId));
sqlParam.Add(new SqlParameter("@OccupancyId", SupplierOccupancyDetail.OccupancyId));
sqlParam.Add(new SqlParameter("@AgeFrom", SupplierOccupancyDetail.AgeFrom));
sqlParam.Add(new SqlParameter("@AgeTo", SupplierOccupancyDetail.AgeTo));
sqlParam.Add(new SqlParameter("@UpdatedDate", SupplierOccupancyDetail.UpdatedDate));
sqlParam.Add(new SqlParameter("@UpdatedBy", SupplierOccupancyDetail.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 UpdateSupplierOccupancyDetail(SupplierOccupancyDetailInfo SupplierOccupancyDetail)
{
_sqlHelper.ExecuteNonQuery(SetValuesInSupplierOccupancyDetailInfo(SupplierOccupancyDetail), Storeprocedures.spUpdateSupplierOccupancy.ToString(), CommandType.StoredProcedure);
}
