public async Task <IList <Playlist> > Filtro(PlaylistFiltro filtro)
{
var playlistQuery = DbSet.AsNoTracking();
if (filtro != null)
{
if (!string.IsNullOrEmpty(filtro.Nome))
{
playlistQuery = playlistQuery.Where(p => p.Nome.Contains(filtro.Nome));
}
}
return(await playlistQuery.ToListAsync());
}
public async Task <IActionResult> Excel([FromQuery] PlaylistFiltro filtro)
{
var playlists = await _playlistRepository.Filtro(filtro);
using (var wb = new XLWorkbook())
{
var ws = wb.AddWorksheet("Playlists");
var linhaAtual = 1;
ws.Cell(linhaAtual, (int)PlaylistColumns.Nome).Value = "Nome";
ws.Cell(linhaAtual, (int)PlaylistColumns.Nome).Style.Font.Bold = true;
foreach (var playlist in playlists)
{
linhaAtual++;
ws.Cell(linhaAtual, (int)PlaylistColumns.Nome).Value = playlist.Nome;
}
return(await GerarArquivoExcel(wb, "playlists.xlsx"));
}
}
public async Task <IList <PlaylistViewModel> > GetAll([FromQuery] PlaylistFiltro filtro)
{
return(_mapper.Map <IList <PlaylistViewModel> >(await _playlistRepository.Filtro(filtro)));
}
