public void UpdateTournamentEntry(TournamentEntryModel tem)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfiguration.ConnectionString(Db)))
{
var p = new DynamicParameters();
p.Add("@TournamentId", tem.TournamentId);
p.Add("@TeamId", tem.TeamId);
p.Add("@Wins", tem.Wins);
p.Add("@Losses", tem.Losses);
p.Add("@RoundDifference", tem.RoundDifference);
connection.Execute("dbo.spTournamentEntries_Update", p, commandType: CommandType.StoredProcedure);
}
}
private static void MarkWinner(List <MatchupModel> matchModels, int tournamentId)
{
foreach (MatchupModel m in matchModels)
{
if (m.Entries.Count == 1)
{
m.Winner = m.Entries[0].TeamCompeting;
continue;
}
if (m.Entries[0].MapOneScore > m.Entries[1].MapOneScore)
{
TournamentEntryModel team1 = GlobalConfiguration.Connection.GetTournamentEntry(m.Entries[0].TeamCompetingId, tournamentId);
team1.Wins += 1;
team1.RoundDifference += m.Entries[0].MapOneScore - m.Entries[1].MapOneScore;
TournamentEntryModel team2 = GlobalConfiguration.Connection.GetTournamentEntry(m.Entries[1].TeamCompetingId, tournamentId);
team2.Losses += 1;
team2.RoundDifference += m.Entries[1].MapOneScore - m.Entries[0].MapOneScore;
m.Winner = m.Entries[0].TeamCompeting;
GlobalConfiguration.Connection.UpdateTournamentEntry(team1);
GlobalConfiguration.Connection.UpdateTournamentEntry(team2);
}
else if (m.Entries[1].MapOneScore > m.Entries[0].MapOneScore)
{
TournamentEntryModel team1 = GlobalConfiguration.Connection.GetTournamentEntry(m.Entries[1].TeamCompetingId, tournamentId);
team1.Wins += 1;
team1.RoundDifference += m.Entries[1].MapOneScore - m.Entries[0].MapOneScore;
TournamentEntryModel team2 = GlobalConfiguration.Connection.GetTournamentEntry(m.Entries[0].TeamCompetingId, tournamentId);
team2.Losses += 1;
team2.RoundDifference += m.Entries[0].MapOneScore - m.Entries[1].MapOneScore;
m.Winner = m.Entries[1].TeamCompeting;
GlobalConfiguration.Connection.UpdateTournamentEntry(team1);
GlobalConfiguration.Connection.UpdateTournamentEntry(team2);
}
}
}
public TournamentEntryModel GetTournamentEntry(int teamId, int tournamentId)
{
TournamentEntryModel tem = new TournamentEntryModel();
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfiguration.ConnectionString(Db)))
{
var p = new DynamicParameters();
p.Add("@TeamId", teamId);
p.Add("@TournamentId", tournamentId);
List <TournamentEntryModel> temp = connection.Query <TournamentEntryModel>("dbo.spTournamentEntries_GetByTeamID", p, commandType: CommandType.StoredProcedure).ToList();
foreach (TournamentEntryModel temModel in temp)
{
tem.TeamId = temModel.TeamId;
tem.TournamentId = temModel.TournamentId;
tem.Wins = temModel.Wins;
tem.Losses = temModel.Losses;
tem.RoundDifference = temModel.RoundDifference;
}
}
return(tem);
}
