Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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();
        }