public StockMerchandise GetByBookId(int id)
{
return(_context.StockMerchandises
.Include(m => m.Book)
.ThenInclude(b => b.Category)
.FirstOrDefault(StockMerchandiseQueries.GetByBookId(id)));
}
public List <StockMerchandise> GetAllActive()
{
return(_context.StockMerchandises
.Include(m => m.Book)
.ThenInclude(b => b.Category)
.Where(StockMerchandiseQueries.GetAllActive())
.AsNoTracking()
.ToList());
}
public List <StockMerchandise> Search(
string author,
string title,
int category,
string publishing,
string edition,
string isbn,
int year,
int pageNumber,
string synopsis,
string codeBar
)
{
IQueryable <StockMerchandise> result = _context.StockMerchandises
.Include(m => m.Book)
.ThenInclude(b => b.Category)
.Where(StockMerchandiseQueries.GetAllActive());
if (author != null)
{
result = result.Where(c => c.Book.Author.Contains(author));
}
if (title != null)
{
result = result.Where(c => c.Book.Title.Contains(title));
}
if (category != 0)
{
result = result.Where(c => c.Book.Category.Id == category);
}
if (publishing != null)
{
result = result.Where(c => c.Book.Publishing.Contains(publishing));
}
if (edition != null)
{
result = result.Where(c => c.Book.Edition.Contains(edition));
}
if (isbn != null)
{
result = result.Where(c => c.Book.ISBN.Contains(isbn));
}
if (year != 0)
{
result = result.Where(c => c.Book.Year == year);
}
if (pageNumber != 0)
{
result = result.Where(c => c.Book.PageNumber == pageNumber);
}
if (synopsis != null)
{
result = result.Where(c => c.Book.Synopsis.Contains(synopsis));
}
if (codeBar != null)
{
result = result.Where(c => c.Book.CodeBar.Contains(codeBar));
}
return(result
.AsNoTracking()
.ToList());
}
