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)); }