public async Task <SeasonInfoEntity> GetActiveSeasonInfoByDateAsync(DateTime date)
{
var season = (await _table.ReadManyAsync("SeasonEndDate is null OR SeasonEndDate >= @date",
new { date }, top: 1)).FirstOrDefault();
return(season);
}
public async Task <Dictionary <MatchDetailKey, MatchDetailEntity> > ReadForScheduleId(Guid scheduleId)
{
var entities = (await _table.ReadManyAsync("TeamScheduleId = @scheduleId", new { scheduleId })).ToList();
var dictionary = entities.GroupBy(x => (x.TeamScheduleId, x.Game, x.PlayerId))
.ToDictionary(x => new MatchDetailKey
{
ScheduleId = x.Key.Item1,
Game = x.Key.Item2,
PlayerId = x.Key.Item3
}, x => x.First());
return(dictionary);
}
public async Task <Dictionary <StatsKey, List <PlayerStatsEntity> > > GetStatsAsync(IEnumerable <StatsKey> keys)
{
keys = keys.ToList();
var entities = await _table.ReadManyAsync("SummonerId in @summonerIds AND SeasonInfoId in @seasonIds", new
{
summonerIds = keys.Select(x => x.SummonerId),
seasonIds = keys.Select(x => x.SeasonId)
});
var dictionary = entities.Where(x => x.SeasonInfoId.HasValue).GroupBy(x => (x.SummonerId, x.SeasonInfoId))
.ToDictionary(x => new StatsKey(x.Key.Item1, x.Key.Item2.GetValueOrDefault()), x => x.ToList());
return(dictionary);
}
public async Task <TeamCaptainEntity> GetCaptainByRosterId(Guid rosterId)
{
var captain = (await _table.ReadManyAsync("TeamRosterId = @rosterId", new { rosterId }, top: 1))
.FirstOrDefault();
return(captain);
}
public async Task <IEnumerable <AchievementEntity> > GetAchievementsForUserAsync(Guid userId)
{
return(await _table.ReadManyAsync("UserId = @userId", new { userId }));
}
public async Task <IEnumerable <ChampionStatsEntity> > GetStatsForPlayerAsync(Guid playerId)
{
var entities = await _table.ReadManyAsync("PlayerId = @playerId", new { playerId });
return(entities);
}
public async Task <IEnumerable <DivisionEntity> > GetAllForSeasonAsync(Guid seasonId)
{
return(await _table.ReadManyAsync("SeasonInfoId = @seasonId", new { seasonId }));
}
public async Task <IEnumerable <AlternateAccountEntity> > ReadAllForSummonerAsync(Guid summonerId)
{
return(await _table.ReadManyAsync("SummonerId = @summonerId", new { summonerId }));
}
public async Task <IEnumerable <ScheduleEntity> > GetAllAsync(Guid?seasonInfoId)
{
return(await _table.ReadManyAsync("SeasonInfoId = @seasonInfoId", new { seasonInfoId }));
}
public async Task <SummonerInfoEntity> ReadOneByUserIdAsync(Guid userId)
{
return((await _table.ReadManyAsync("UserId = @userId", new { userId })).FirstOrDefault());
}
public async Task <BlacklistEntity> GetByUserIdAsync(Guid userId)
{
var result = (await _table.ReadManyAsync("UserId = @userId", new { userId }, top: 1)).FirstOrDefault();
return(result);
}
public async Task <IEnumerable <SummonerRequestEntity> > ReadAllForSummonerAsync(Guid summonerId, Guid seasonInfoId)
{
var entities = (await _table.ReadManyAsync("SummonerId = @summonerId AND SeasonInfoId = @seasonInfoId", new { summonerId, seasonInfoId })).ToList();
return(entities);
}
public async Task <IEnumerable <MatchMvpEntity> > ReadAllForTeamScheduleId(Guid teamScheduleId)
{
var entities = await _table.ReadManyAsync("TeamScheduleId = @teamScheduleId", new { teamScheduleId });
return(entities);
}
public async Task <TeamRosterEntity> GetByTeamNameAsync(string teamName, Guid?seasonInfoId)
{
var seasonInfoNotNull = seasonInfoId == null ? "AND SeasonInfoId is null" : "AND SeasonInfoId = @seasonInfoId";
return((await _table.ReadManyAsync($"TeamName = @teamName {seasonInfoNotNull}", new { teamName, seasonInfoId })).FirstOrDefault());
}
public async Task <IEnumerable <LookupEntity> > GetLookupEntitiesByCategory(string category)
{
var entities = await _table.ReadManyAsync("Category = @category", new { category });
return(entities);
}
public async Task <GoogleDriveFolderEntity> GetFolderByGoogleIdAsync(Guid googleFolderId)
{
return((await _table.ReadManyAsync("FolderId = @googleFolderId", new { googleFolderId }, top: 1))
.FirstOrDefault());
}
public async Task <IEnumerable <TeamPlayerEntity> > ReadAllForSeasonAsync(Guid seasonInfoId)
{
return(await _table.ReadManyAsync("SeasonInfoId = @seasonInfoId", new { seasonInfoId }));
}