private void player1Button_Click(object sender, EventArgs e)
{
p1OldElo = sql.findElo(player1);
p2OldElo = sql.findElo(player2);
p1Exponent = Math.Pow(10, ((p2OldElo - p1OldElo) / 400));
p1Expected = 1 / (1 + p1Exponent);
changeRate = Math.Round(32 * (1 - p1Expected));
p1Elo = p1OldElo + changeRate;
sql.updateElo(player1, (int)p1Elo);
changeRate = -changeRate;
p2Elo = p2OldElo + changeRate;
sql.updateElo(player2, (int)p2Elo);
Hide();
OneVOneResults results = new OneVOneResults();
results.player1 = player1;
results.player2 = player2;
results.p1Old = p1OldElo.ToString();
results.p2Old = p2OldElo.ToString();
results.p1New = p1Elo.ToString();
results.p2New = p2Elo.ToString();
results.Show();
}
private void View3v3Team_Load(object sender, EventArgs e)
{
//coachLabel.Text = sql.findCoach3v3(teamName);
teamLabel.Text = teamName;
p1Label.Text = sql.findTeamMember3v3(teamName, "p1username");
p2Label.Text = sql.findTeamMember3v3(teamName, "p2username");
p3Label.Text = sql.findTeamMember3v3(teamName, "p3username");
p1Elo.Text = sql.findElo(p1Label.Text).ToString();
p2Elo.Text = sql.findElo(p2Label.Text).ToString();
p3Elo.Text = sql.findElo(p3Label.Text).ToString();
teamEloLabel.Text = ((sql.findElo(p1Label.Text) + sql.findElo(p2Label.Text) + sql.findElo(p3Label.Text)) / 3).ToString();
//coachElo.Text = sql.findCoachElo(coachLabel.Text).ToString();
}
private void viewPlayer_Load(object sender, EventArgs e)
{
playerUsernameLabel.Text = playerUsername;
playerUsernameLabel.Location = new Point((600 - playerUsernameLabel.Width) / 2, 217);
eloLabel.Text = sql.findElo(playerUsername).ToString();
eloLabel.Location = new Point((600 - eloLabel.Width) / 2, 262);
}
private void View5v5Team_Load(object sender, EventArgs e)
{
//coachLabel.Text = sql.findCoach5v5(teamName);
teamLabel.Text = teamName;
p1Label.Text = sql.findTeamMember5v5(teamName, "p1username");
p2Label.Text = sql.findTeamMember5v5(teamName, "p2username");
p3Label.Text = sql.findTeamMember5v5(teamName, "p3username");
p4Label.Text = sql.findTeamMember5v5(teamName, "p4username");
p5Label.Text = sql.findTeamMember5v5(teamName, "p5username");
p1Elo.Text = sql.findElo(p1Label.Text).ToString();
p2Elo.Text = sql.findElo(p2Label.Text).ToString();
p3Elo.Text = sql.findElo(p3Label.Text).ToString();
p4Elo.Text = sql.findElo(p4Label.Text).ToString();
p5Elo.Text = sql.findElo(p5Label.Text).ToString();
teamEloLabel.Text = ((sql.findElo(p1Label.Text) + sql.findElo(p2Label.Text) + sql.findElo(p3Label.Text) + sql.findElo(p4Label.Text) + sql.findElo(p5Label.Text)) / 5).ToString();
//coachElo.Text = sql.findCoachElo(coachLabel.Text).ToString();
}
private void caclulateTeamAverages()
{
t1p1 = sql.findPlayerOne3v3(teamOneName);
t1p2 = sql.findPlayerTwo3v3(teamOneName);
t1p3 = sql.findPlayerThree3v3(teamOneName);
t2p1 = sql.findPlayerOne3v3(teamTwoName);
t2p2 = sql.findPlayerTwo3v3(teamTwoName);
t2p3 = sql.findPlayerThree3v3(teamTwoName);
teamOneAvg = Math.Round(((double)sql.findElo(t1p1) + (double)sql.findElo(t1p2)
+ (double)sql.findElo(t1p3)) / 3.0);
teamTwoAvg = Math.Round(((double)sql.findElo(t2p1) + (double)sql.findElo(t2p2)
+ (double)sql.findElo(t2p3)) / 3.0);
}
private void caclulateTeamAverages()
{
t1p1 = sql.findPlayerOne5v5(teamOneName);
t1p2 = sql.findPlayerTwo5v5(teamOneName);
t1p3 = sql.findPlayerThree5v5(teamOneName);
t1p4 = sql.findPlayerFour5v5(teamOneName);
t1p5 = sql.findPlayerFive5v5(teamOneName);
t2p1 = sql.findPlayerOne5v5(teamTwoName);
t2p2 = sql.findPlayerTwo5v5(teamTwoName);
t2p3 = sql.findPlayerThree5v5(teamTwoName);
t2p4 = sql.findPlayerFour5v5(teamTwoName);
t2p5 = sql.findPlayerFive5v5(teamTwoName);
teamOneAvg = Math.Round(((double)sql.findElo(t1p1) + (double)sql.findElo(t1p2)
+ (double)sql.findElo(t1p3) + (double)sql.findElo(t1p4)
+ (double)sql.findElo(t1p5)) / 5.0);
teamTwoAvg = Math.Round(((double)sql.findElo(t2p1) + (double)sql.findElo(t2p2)
+ (double)sql.findElo(t2p3) + (double)sql.findElo(t2p4)
+ (double)sql.findElo(t2p5)) / 5.0);
}
