// Fill vM object for tables // of rankings per map public IEnumerable <MapRankings> FillMapRankings() { var mapRankingsContainer = new List <MapRankings>(); var maps = _dbContext.MapPerformanceSummaries .Select(m => m.MapName) .Distinct(); foreach (var map in maps) { var mapPerformanceSummaries = _dbContext.MapPerformanceSummaries .Where(m => m.MapName == map) .ToList(); var mapRankingItem = new MapRankings() { MapName = map, MapPerformanceSummaries = mapPerformanceSummaries }; mapRankingsContainer.Add(mapRankingItem); } return(mapRankingsContainer); }
public IEnumerable <MapRankings> FillMapRankings(DateTime matchDate) { var mapRankingsContainer = new List <MapRankings>(); var maps = _dbContext.MapDistinctByMatchDate(matchDate); foreach (var map in maps) { var mapPerformanceSummaries = _dbContext.MapPerformanceSummaryByMatchDate(matchDate) .Where(m => m.MapName == map) .ToList(); var mapRankingItem = new MapRankings() { MapName = map, MapPerformanceSummariesByMatchDate = mapPerformanceSummaries }; mapRankingsContainer.Add(mapRankingItem); } return(mapRankingsContainer); }