public void Can_Get_Filtered_Paging_List()
        {
            var request = new LPCReportRequest
            {
                PageSize = 20,
                Page     = 1,
                Borough  = "Manhattan"
            };

            var results = _lpcReportService.GetLPCReports(request).Results;

            Assert.Equal(request.PageSize, results.Count);
        }
Exemple #2
0
        public IEnumerable <LPCReportModel> Get([FromQuery] LPCReportRequestModel query, int limit, int page)
        {
            long totalRecords = 0;
            var  request      = new LPCReportRequest
            {
                PageSize        = limit,
                Page            = page,
                SortColumn      = !string.IsNullOrEmpty(query.Sort) ? query.Sort : "name",
                SortOrder       = !string.IsNullOrEmpty(query.Order) ? query.Order : "asc",
                ParentStyleList = !string.IsNullOrEmpty(query.ParentStyles) ? query.ParentStyles.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList() : null,
                Borough         = query.Borough,
                ObjectType      = query.ObjectType
            };

            var records = _lpcReportService.GetLPCReports(request);

            totalRecords = records.Total;
            HttpContext.Response.Headers.Add("X-InlineCount", totalRecords.ToString());
            return(records.Results);
        }
        public PagedResultModel <LPCReportModel> GetLPCReports(LPCReportRequest request)
        {
            var predicate = PredicateBuilder.True <LPCReport>();

            if (!string.IsNullOrEmpty(request.Borough))
            {
                predicate = predicate.And(x => x.Borough == request.Borough);
            }

            if (!string.IsNullOrEmpty(request.ObjectType))
            {
                predicate = predicate.And(x => x.ObjectType == request.ObjectType);
            }

            var sortModel = new SortModel
            {
                SortColumn = !string.IsNullOrEmpty(request.SortColumn) ? request.SortColumn : null,
                SortOrder  = !string.IsNullOrEmpty(request.SortOrder) ? request.SortOrder : null
            };

            var sortingList = new List <SortModel>();

            sortingList.Add(sortModel);

            int totalCount = _lpcReportRepository.FindBy(predicate).Count();

            var results = _lpcReportRepository
                          .GetPage(predicate, request.PageSize * (request.Page - 1), request.PageSize, sortingList);

            var modelData = Mapper.Map <IEnumerable <LPCReport>, IEnumerable <LPCReportModel> >(results).ToList();

            var pagedResult = new PagedResultModel <LPCReportModel>
            {
                Total   = totalCount,
                Page    = request.Page,
                Limit   = request.PageSize,
                Results = modelData,
            };

            return(pagedResult);
        }
        public void Can_Get_Paging_List()
        {
            //int count = 0;
            var request = new LPCReportRequest
            {
                PageSize = 20,
                Page     = 1,
            };

            var sortingList = new List <SortModel>()
            {
                new SortModel
                {
                    SortColumn = "name",
                    SortOrder  = "asc"
                }
            };

            var results = _lpcReportRepository.GetPage(request.Page, request.PageSize, sortingList).ToList();

            Assert.Equal(request.PageSize, results.Count);
        }
Exemple #5
0
        //[Fact]
        public void Can_Get_Filtered_Paging_List()
        {
            var predicate = PredicateBuilder.True <LPCReport>();
            var request   = new LPCReportRequest()
            {
                PageSize = 20,
                Page     = 1,
            };

            var sortModel = new SortModel
            {
                SortColumn = !string.IsNullOrEmpty(request.SortColumn) ? request.SortColumn : null,
                SortOrder  = !string.IsNullOrEmpty(request.SortOrder) ? request.SortOrder : null
            };

            var sortingList = new List <SortModel>();

            sortingList.Add(sortModel);

            var results = lpcReportRepository
                          .GetPage(predicate, request.PageSize * (request.Page - 1), request.PageSize, sortingList);

            Assert.NotNull(results);
        }