private async void ShowReportBtn_Click(object sender, EventArgs e)
{
var searchRequest = new MostPopularBookRequest()
{
From = fromDtp.Value,
To = toDtp.Value
};
var genreIdObj = genresComboBox.SelectedValue ?? 0;
if (int.TryParse(genreIdObj.ToString(), out int genreId))
{
searchRequest.GenreId = genreId;
}
var results = await _userReports.Get <List <MostPopularBook> >(searchRequest);
if (results.Any())
{
var activeUsersForm = new MostPopularBooksView();
activeUsersForm.Books = results;
activeUsersForm.Show();
}
}
public async Task <List <MostPopularBook> > GetMostPopularBooks(MostPopularBookRequest request)
{
return(await _context.Query <MostPopularBook>().AsNoTracking().FromSql("SP_GetMostPopularBooksByDate @p0, @p1, @p2", request.From, request.To, request.GenreId).ToListAsync());
}
public async Task <List <MostPopularBook> > MostPopularBooks([FromQuery] MostPopularBookRequest request)
{
return(await _reportsService.GetMostPopularBooks(request));
}
