コード例 #1
0
        public async Task <IActionResult> ByBoard([FromQuery] ByBoardScoresQuery filter = null)
        {
            if (filter?.IsApproved != true)
            {
                var isAdmin = await _auth.AuthorizeAsync(User, "AppAdmin").ConfigureAwait(false);

                // if the user is requesting unapproved scores, they must be an admin
                if (!isAdmin.Succeeded)
                {
                    return(Unauthorized());
                }
            }

            return(Ok(GetScoresByBoard(filter)));
        }
コード例 #2
0
        public async Task <IDictionary <string, IEnumerable <ScoreViewModel> > > GetScoresByBoard(ByBoardScoresQuery filter = null)
        {
            var top       = filter?.Top;
            var topBoards = filter?.TopBoards;

            // if we're selecting only x top boards, then 'top' referring to the top count from each board.
            // so we have to apply the top filter after we've performed the grouping
            if (topBoards != null)
            {
                filter.Top = null;
            }

            // EF Core doesn't support groupby, so we have to evaluate the query and do it in memory
            var scores = await GetScores(filter).ToArrayAsync().ConfigureAwait(false);

            var scoresQuery = scores.GroupBy(s => s.Board.Id);

            if (topBoards != null)
            {
                scoresQuery = scoresQuery.Take((int)filter.TopBoards);
            }

            if (top != null)
            {
                scoresQuery = scoresQuery.SelectMany(g => g.Take((int)top).GroupBy(s => s.Board.Id));
            }



            var scoresByBoard = scoresQuery.ToDictionary(g => g.Key, g => g.AsEnumerable());

            return(scoresByBoard);
        }