public List <SupplierHotelCustomerCategoryInfo> GetSupplierHotelTariffCustomerCategory(int SupplierHotelPriceId, DateTime TariffDate)
{
List <SupplierHotelCustomerCategoryInfo> SupplierHotelCustomers = new List <SupplierHotelCustomerCategoryInfo>();
List <SqlParameter> sqlParam = new List <SqlParameter>();
SupplierHotelDurationInfo duration = new SupplierHotelDurationInfo();
sqlParam.Add(new SqlParameter("@SupplierHotelPriceId", SupplierHotelPriceId));
sqlParam.Add(new SqlParameter("@TariffDate", TariffDate));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetSupplierHotelTariffCustomerCategoriess.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SupplierHotelCustomers.Add(GetSupplierHotelCustomersValues(dr));
}
}
return(SupplierHotelCustomers);
}
public List <DateTime> GetFilteredDateForDuration(SupplierHotelDurationInfo supplierhotelTariffDurationDetails)
{
List <DateTime> dates = new List <DateTime>();
foreach (DateTime day in EachDay(supplierhotelTariffDurationDetails.FromDate, supplierhotelTariffDurationDetails.ToDate))
{
if (supplierhotelTariffDurationDetails.OperationalDays.Split(',').Contains(day.DayOfWeek.ToString()))
{
dates.Add(day.Date);
}
}
return(dates);
}
public List <SupplierHotelTariffDurationInfo> GetSupplierHotelTariffDurationPrice(int OccupancyDetailId)
{
List <SupplierHotelTariffDurationInfo> SupplierHotelTariff = new List <SupplierHotelTariffDurationInfo>();
List <SqlParameter> sqlParam = new List <SqlParameter>();
SupplierHotelDurationInfo duration = new SupplierHotelDurationInfo();
sqlParam.Add(new SqlParameter("@OccupancyDetailId", OccupancyDetailId));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetSupplierHotelTariffDurationPrice.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SupplierHotelTariff.Add(GetSupplierHotelTariffDurationValues(dr));
}
}
return(SupplierHotelTariff);
}
