public List <DateTime> GetFilteredDateForDuration(SightSeeingTariffDurationInfo sightseeingTariffDuration)
{
List <DateTime> dates = new List <DateTime>();
foreach (DateTime day in EachDay(sightseeingTariffDuration.FromDate, sightseeingTariffDuration.ToDate))
{
if (sightseeingTariffDuration.OperationalDays.Split(',').Contains(day.DayOfWeek.ToString()))
{
dates.Add(day.Date);
}
}
return(dates);
}
public List <SightSeeingTariffDateInfo> GetSightSeeingTariffDurationPrice(int sightseeingTariffOccupancyId)
{
List <SightSeeingTariffDateInfo> SightSeeingTariffDateDetails = new List <SightSeeingTariffDateInfo>();
List <SqlParameter> sqlParam = new List <SqlParameter>();
SightSeeingTariffDurationInfo duration = new SightSeeingTariffDurationInfo();
sqlParam.Add(new SqlParameter("@SightSeeingTariffOccupancyId", sightseeingTariffOccupancyId));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetSightSeeingTariffDurationPrice.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SightSeeingTariffDateDetails.Add(GetSightSeeingTariffDateValues(dr));
}
}
return(SightSeeingTariffDateDetails);
}
public List <SightSeeingTariffCustomerCategoryInfo> GetSightSeeingTariffCustomerCategory(int sightseeingTariffOccupancyId, DateTime tariffDate)
{
List <SightSeeingTariffCustomerCategoryInfo> SightSeeingTariffCustomerCategory = new List <SightSeeingTariffCustomerCategoryInfo>();
List <SqlParameter> sqlParam = new List <SqlParameter>();
SightSeeingTariffDurationInfo duration = new SightSeeingTariffDurationInfo();
sqlParam.Add(new SqlParameter("@SightSeeingTariffOccupancyId", sightseeingTariffOccupancyId));
sqlParam.Add(new SqlParameter("@TariffDate", tariffDate));
DataTable dt = _sqlHelper.ExecuteDataTable(sqlParam, Storeprocedures.spGetSightSeeingTariffCustomerCategories.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SightSeeingTariffCustomerCategory.Add(GetSightSeeingTariffCustomerCategoryValues(dr));
}
}
return(SightSeeingTariffCustomerCategory);
}
public SightSeeingTariffViewModel()
{
//For Sight Seeing Tariff
SightSeeingTariff = new SightSeeingTariffInfo();
SightSeeingTariffs = new List <SightSeeingTariffInfo>();
Filter = new SightSeeingTariffFilter();
Vendors = new List <VendorInfo>();
SightSeeings = new List <SightSeeingInfo>();
Meals = new List <MealInfo>();
Occupancies = new List <OccupancyInfo>();
Pager = new PaginationInfo();
FriendlyMessage = new List <FriendlyMessage>();
//for date details
SightSeeingTariffDate = new SightSeeingTariffDateInfo();
SightSeeingTariffDates = new List <SightSeeingTariffDateInfo>();
//For Duration
Durations = new List <DurationInfo>();
Duration = new DurationInfo();
DurationFilter = new DurationFilter();
//for sight seeing duration
SightSeeingTariffDuration = new SightSeeingTariffDurationInfo();
SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>();
SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter();
//For Sight Seeing Tariff Occupancy
SightSeeingTariffOccupancy = new SightSeeingTariffOccupancyInfo();
SightSeeingTariffOccupancies = new List <SightSeeingTariffOccupancyInfo>();
SightSeeingTariffOccupancyFilter = new SightSeeingTariffOccupancyFilter();
//For tax formula
LstStandardCharges = new List <ChargesInfo>();
LstTaxFormula = new List <TaxFormulaInfo>();
LstTaxFormulaCharges = new List <TaxFormulaChargesInfo>();
//For Sight Seeing Details
SightSeeingDetails = new List <SightSeeingDetailInfo>();
SightSeeingDetail = new SightSeeingDetailInfo();
SightSeeingDetailFilter = new SightSeeingDetailFilter();
//For Sight Seeing Tariff Price
SightSeeingTariffPrice = new SightSeeingTariffPriceInfo();
SightSeeingTariffPrices = new List <SightSeeingTariffPriceInfo>();
SightSeeingTariffPriceFilter = new SightSeeingTariffPriceFilter();
//For Sight Seeing Tariff Duration
SightSeeingTariffDuration = new SightSeeingTariffDurationInfo();
SightSeeingTariffDurations = new List <SightSeeingTariffDurationInfo>();
SightSeeingTariffDurationFilter = new SightSeeingTariffDurationFilter();
//for Customer Category
SightSeeingTariffCustomerCategory = new SightSeeingTariffCustomerCategoryInfo();
SightSeeingTariffCustomerCategories = new List <SightSeeingTariffCustomerCategoryInfo>();
CustomerCategory = new CustomerCategoryInfo();
CustomerCategories = new List <CustomerCategoryInfo>();
SightSeeingTariffCustomerCategoryFilter = new SightSeeingTariffCustomerCategoryFilter();
}