public async Task <List <Author> > Handle(ParametersSelectAuthorID request, CancellationToken cancellationToken)
{
if (request.id == 0)
{
return(await _booksOnlineContext.Author.ToListAsync());
}
else
{
var resultadoPP = await _booksOnlineContext.AuthorBook.Where(p => p.BookID == request.id).ToListAsync();
var resultadosP = await _booksOnlineContext.Author.ToListAsync();
var result = (from p in resultadosP
join pp in resultadoPP on p.AuthorID equals pp.AuthorID
into ps
from pp in ps.DefaultIfEmpty()
select new Author {
AuthorID = p.AuthorID, FirstName = p.FirstName, LastName = p.LastName, Seleccionado = pp == null ? false : true
}
).ToList()
;
return(result);
}
}
public async Task <List <Author> > Handle(ParametersSelectAuthorID request, CancellationToken cancellationToken)
{
return(await _booksOnlineContext.Author
.Include(P => P.BooksLnk)
.ThenInclude(p => p.Book)
.Where(p => p.AuthorID == request.id)
.ToListAsync());
}
