private async void ShowReportBtn_Click(object sender, EventArgs e)
        {
            var searchRequest = new MostActiveUsersRequest()
            {
                From = fromDtp.Value,
                To   = toDtp.Value
            };


            var results = await _userReports.Get <List <MostActiveUsers> >(searchRequest);

            if (results.Any())
            {
                var activeUsersForm = new MostActiveUsersView();
                activeUsersForm.Users = results;
                activeUsersForm.Show();
            }
        }
 public async Task <List <MostActiveUsers> > GetMostActiveUsers(MostActiveUsersRequest request)
 {
     return(await _context.Query <MostActiveUsers>().AsNoTracking().FromSql("SP_GetMostActiveUsersByDate @p0, @p1", request.From, request.To).ToListAsync());
 }
 public async Task <List <MostActiveUsers> > MostActiveUsers([FromQuery] MostActiveUsersRequest request)
 {
     return(await _reportsService.GetMostActiveUsers(request));
 }