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