Exemple #1
0
        public PagedSearchResponseDto <List <PersonSearchResultDto> > SearchPeople(PagedSearchDto dto)
        {
            using (MyDbContext context = new MyDbContext())
            {
                SqlParameter pageSize = new SqlParameter("@PageSize", dto.PageSize ?? (object)DBNull.Value)
                {
                    DbType = System.Data.DbType.Int32
                };
                SqlParameter pageNumber = new SqlParameter("@PageNumber", dto.PageNumber ?? (object)DBNull.Value)
                {
                    DbType = System.Data.DbType.Int32
                };
                SqlParameter orderBy   = new SqlParameter("@OrderBy", string.IsNullOrEmpty(dto.OrderByColumn) ? (object)DBNull.Value : dto.OrderByColumn);
                SqlParameter orderAsc  = new SqlParameter("@OrderAsc", dto.OrderAscending ?? (object)DBNull.Value);
                SqlParameter totalRows = new SqlParameter("@TotalRows", 0)
                {
                    DbType    = System.Data.DbType.Int32,
                    Direction = System.Data.ParameterDirection.Output
                };

                List <PersonSearchResultDto> results = context.Database.SqlQuery <PersonSearchResultDto>("EXEC dbo.GetPeople @PageSize, @PageNumber, @OrderBy, @OrderAsc, @TotalRows OUTPUT",
                                                                                                         pageSize, pageNumber, orderBy, orderAsc, totalRows).ToList();

                PagedSearchResponseDto <List <PersonSearchResultDto> > response = new PagedSearchResponseDto <List <PersonSearchResultDto> >
                {
                    PageSize       = dto.PageSize,
                    PageNumber     = dto.PageNumber,
                    OrderByColumn  = dto.OrderByColumn,
                    OrderAscending = dto.OrderAscending,
                    TotalRows      = (int?)totalRows.Value,
                    Result         = results
                };
                return(response);
            }
        }
        public async Task MyTestMethod()
        {
            PagedSearchDto dto = new PagedSearchDto();

            dto.PageSize       = 25;
            dto.PageNumber     = 2;
            dto.OrderByColumn  = "FirstName";
            dto.OrderAscending = true;
            dto.TotalRows      = 0;
            ApiResponse response = await _Client.GetPeople(dto);

            PagedSearchResponseDto <List <PersonSearchResultDto> > data = response.GetTypedContent <PagedSearchResponseDto <List <PersonSearchResultDto> > >();

            Assert.AreEqual(dto.PageSize, data.Result.Count);
        }
Exemple #3
0
 public void TestGetPeopleWithDefaults()
 {
     using (ApiSampleRepository repository = new ApiSampleRepository())
     {
         PagedSearchDto dto = new PagedSearchDto();
         dto.PageSize       = 25;
         dto.PageNumber     = 2;
         dto.OrderByColumn  = "PersonId";
         dto.OrderAscending = true;
         dto.TotalRows      = 0;
         PagedSearchResponseDto <List <PersonSearchResultDto> > response = repository.SearchPeople(dto);
         Assert.IsTrue(response.Result.Count == 25);
         Assert.IsTrue(response.Result.First().PersonId == 26);
     }
 }