예제 #1
0
        /// <inheritdoc />
        public Task <PageResponse <HouseInfoDto> > GetPage(PageRequest <HouseFilter> request)
        {
            using (var db = new ApplicationDbContext())
            {
                var dbResult = db.Houses
                               .Include(h => h.Subnet)
                               .AsQueryable();

                dbResult = Filter(request, dbResult);

                dbResult = Sort(request, dbResult);

                var total = dbResult.Count();
                dbResult = dbResult.Skip(request.Skip).Take(request.Limit);

                var result = new PageResponse <HouseInfoDto>
                {
                    Data  = _mapper.ToInfoDto(dbResult),
                    Total = total
                };

                return(Task.FromResult(result));
            }
        }