public async Task <BookPaginationDto> Find(int pageSize, int currentPage, Sort sort, string column, string authorId) { try { IEnumerable <Book> books = await _bookRepository.FindAsync(); // filter if (authorId != null) { books = books.Where(x => x.AuthorId == Guid.Parse(authorId)); } // sort if (column != null) { if (typeof(Book).GetProperty(column) == null) { string[] joinColumns = { "AuthorName" }; if (joinColumns.Contains(column)) { if (column.Equals("AuthorName")) { Func <Book, string> AuthorNameSelector() => x => x?.Author?.Name; books = DynamicSorting.SortJoinColumn <Book, string>(books, sort, AuthorNameSelector()); } } else { throw ErrorResponse.BadRequest(); } } else { books = DynamicSorting.SortColumn <Book>(books, sort, typeof(Book).GetProperty(column)); } } else { books = DynamicSorting.SortColumn(books, sort, typeof(Book).GetProperty("Id")); } // pagination int booksCount = books.Count(); books = Pagination.Paging <Book>(books, currentPage, pageSize); return(new BookPaginationDto { Total = booksCount, Books = _mapper.Map <IEnumerable <Book>, IEnumerable <BookDto> >(books), }); } catch (Exception ex) { await _unitOfWork.RollbackAsync(); throw ErrorResponse.InternalServerError(ex); } }
/// <summary> Resets this instance to the default values </summary> public void Reset() { Behavior = DEFAULT_BEHAVIOR; StopBehavior = DEFAULT_STOP_BEHAVIOR; AutoSort = DEFAULT_AUTO_SORT; SortingSteps = DEFAULT_SORTING_STEPS; CustomSortingLayer = DEFAULT_SORTING_LAYER; CustomSortingOrder = DEFAULT_SORTING_ORDER; }
public async Task <AuthorPaginationDto> Find(int pageSize, int currentPage, Sort sort, string column) { try { IEnumerable <Author> authors = await _authorRepository.FindAsync(); // sort if (column != null) { if (typeof(Author).GetProperty(System.Text.Json.JsonNamingPolicy.CamelCase.ConvertName(column)) == null) { string[] joinColumns = { "TotalBooks" }; if (joinColumns.Contains(column)) { if (column.Equals("TotalBooks")) { Func <Author, int> TotalBookSelector() => x => x.Books.Count(); authors = DynamicSorting.SortJoinColumn <Author, int>(authors, sort, TotalBookSelector()); } } else { throw ErrorResponse.BadRequest(); } } else { authors = DynamicSorting.SortColumn <Author>(authors, sort, typeof(Author).GetProperty(System.Text.Json.JsonNamingPolicy.CamelCase.ConvertName(column))); } } else { authors = DynamicSorting.SortColumn(authors, sort, typeof(Author).GetProperty("Id")); } // pagination int authorCount = authors.Count(); authors = Pagination.Paging <Author>(authors, currentPage, pageSize); return(new AuthorPaginationDto() { Total = authorCount, Authors = _mapper.Map <IEnumerable <Author>, IEnumerable <AuthorDto> >(authors), }); } catch (Exception ex) { await _unitOfWork.RollbackAsync(); throw ErrorResponse.InternalServerError(ex); } }