public BooksWithCategoriesAndAuthorsSpecification(BookSpecificationParams bookParams)
: base(b =>
(string.IsNullOrEmpty(bookParams.Search) || b.Title.ToLower().Contains(bookParams.Search)) &&
(!bookParams.AuthorId.HasValue || b.AuthorId == bookParams.AuthorId) &&
(!bookParams.CategoryId.HasValue || b.CategoryId == bookParams.CategoryId) &&
b.IsActive == true
)
{
AddInclude(b => b.Category);
AddInclude(b => b.Author);
ApplyPaging(bookParams.PageSize * (bookParams.PageIndex - 1), bookParams.PageSize);
if (!string.IsNullOrEmpty(bookParams.Sort))
{
switch (bookParams.Sort)
{
case "titleAsc":
ApplyOrderBy(b => b.Title);
break;
case "titleDesc":
ApplyOrderByDescending(b => b.Title);
break;
case "authorAsc":
ApplyOrderBy(b => b.Author.LastName);
break;
case "authorDesc":
ApplyOrderByDescending(b => b.Author.LastName);
break;
case "yearPublishedAsc":
ApplyOrderBy(b => b.YearPublished);
break;
case "yearPublishedDesc":
ApplyOrderByDescending(b => b.YearPublished);
break;
case "recentlyAddedDesc":
ApplyOrderByDescending(b => b.AddedOn);
break;
case "mostPopularDesc":
ApplyOrderByDescending(b => b.RequestCount);
break;
default:
ApplyOrderBy(b => b.Title);
break;
}
}
else
{
ApplyOrderBy(b => b.Title);
}
}
public BooksWithFiltersForCountSpecification(BookSpecificationParams bookParams)
: base(b =>
(string.IsNullOrEmpty(bookParams.Search) || b.Title.ToLower().Contains(bookParams.Search)) &&
(!bookParams.AuthorId.HasValue || b.AuthorId == bookParams.AuthorId) &&
(!bookParams.CategoryId.HasValue || b.CategoryId == bookParams.CategoryId) &&
b.IsActive == true
)
{
}