public async Task EditLeagueYear(LeagueYear leagueYear)
{
LeagueYearEntity leagueYearEntity = new LeagueYearEntity(leagueYear.League, leagueYear.Year, leagueYear.Options, leagueYear.PlayStatus);
using (var connection = new MySqlConnection(_connectionString))
{
await connection.ExecuteAsync(
"update tblleagueyear SET StandardGames = @StandardGames, GamesToDraft = @GamesToDraft, CounterPicks = @CounterPicks, " +
"MaximumEligibilityLevel = @MaximumEligibilityLevel, AllowYearlyInstallments = @AllowYearlyInstallments, AllowEarlyAccess = @AllowEarlyAccess, DraftSystem = @DraftSystem, " +
"PickupSystem = @PickupSystem, ScoringSystem = @ScoringSystem WHERE LeagueID = @LeagueID and Year = @Year",
leagueYearEntity);
}
}
public async Task CreateLeague(League league, int initialYear, LeagueOptions options)
{
LeagueEntity entity = new LeagueEntity(league);
LeagueYearEntity leagueYearEntity = new LeagueYearEntity(league, initialYear, options, PlayStatus.NotStartedDraft);
using (var connection = new MySqlConnection(_connectionString))
{
await connection.ExecuteAsync(
"insert into tblleague(LeagueID,LeagueName,LeagueManager) VALUES " +
"(@LeagueID,@LeagueName,@LeagueManager);",
entity);
await connection.ExecuteAsync(
"insert into tblleagueyear(LeagueID,Year,StandardGames,GamesToDraft,CounterPicks,MaximumEligibilityLevel,AllowYearlyInstallments,AllowEarlyAccess,DraftSystem,PickupSystem,ScoringSystem,PlayStatus) VALUES " +
"(@LeagueID,@Year,@StandardGames,@GamesToDraft,@CounterPicks,@MaximumEligibilityLevel,@AllowYearlyInstallments,@AllowEarlyAccess,@DraftSystem,@PickupSystem,@ScoringSystem,@PlayStatus);",
leagueYearEntity);
}
await AddPlayerToLeague(league, league.LeagueManager);
}
public async Task <Maybe <LeagueYear> > GetLeagueYear(League requestLeague, int requestYear)
{
using (var connection = new MySqlConnection(_connectionString))
{
var queryObject = new
{
leagueID = requestLeague.LeagueID,
year = requestYear
};
LeagueYearEntity yearEntity = await connection.QueryFirstOrDefaultAsync <LeagueYearEntity>("select * from tblleagueyear where LeagueID = @leagueID and Year = @year", queryObject);
if (yearEntity == null)
{
return(Maybe <LeagueYear> .None);
}
var eligibilityLevel = await GetEligibilityLevel(yearEntity.MaximumEligibilityLevel);
LeagueYear year = yearEntity.ToDomain(requestLeague, eligibilityLevel);
return(year);
}
}
