Example #1
0
        public static CountryDataFilter ConvertToDbValue(CountryFilter tourFilter)
        {
            CountryDataFilter result = new CountryDataFilter
            {
                Skip     = tourFilter.Skip,
                Take     = tourFilter.Take,
                TourType = tourFilter.TourType.HasValue ? TourTypesEnumConverter.ConvertToDbValue(tourFilter.TourType.Value) : null
            };

            return(result);
        }
Example #2
0
        public PageDataModel <CountryDataModel> GetCountriesPage(CountryDataFilter filter)
        {
            var filteredCountries = _dbContext.Countries
                                    .Include(t => t.CountryImages)
                                    .OrderBy(t => t.Category)
                                    .ThenBy(t => t.Name)
                                    .Where(t => string.IsNullOrWhiteSpace(filter.TourType) || t.Category == filter.TourType);

            var count          = filteredCountries.Count();
            var pageCollection = filteredCountries
                                 .Skip(filter.Skip)
                                 .Take(filter.Take)
                                 .AsNoTracking()
                                 .ToList();

            var result = new PageDataModel <CountryDataModel>(count, pageCollection);

            return(result);
        }