1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| protected void SubmitButton_Click(object sender, EventArgs e)
{
int HomeWin = 0, HomeLost = 0, HomeOTL = 0, AwayWin = 0, AwayLost = 0, AwayOTL = 0;
string HCoach = GridView1.SelectedRow.Cells[2].Text;
string ACoach = GridView1.SelectedRow.Cells[6].Text;
if (int.Parse(HomeScore.Text) < int.Parse(AwayScore.Text))
{
if (OTBox.Checked == true)
{
HomeOTL = 1;AwayWin = 1;
}
else
{
HomeLost = 1;AwayWin = 1;
}
}
else
{
if (OTBox.Checked == true)
{
HomeWin = 1;AwayOTL = 1;
}
else
{
HomeWin = 1;AwayLost = 1;
}
}
SqlDataTeamStat.UpdateCommand = "UPDATE Team SET GP=GP+1, Win=Win+"+HomeWin+", Lost=Lost+"+HomeLost+", OTL=OTL+"+HomeOTL+", GF=GF+"+int.Parse(HomeScore.Text)+", GA=GA+"+int.Parse(AwayScore.Text)+" WHERE Coach=" + HCoach;
SqlDataTeamStat.UpdateCommand = "UPDATE Team SET GP=GP+1, Win=Win+" + AwayWin + ", Lost=Lost+" + AwayLost + ", OTL=OTL+" + AwayOTL + ", GF=GF+" + int.Parse(AwayScore.Text) + ", GA=GA+" + int.Parse(HomeScore.Text) + " WHERE Coach=" + ACoach;
SqlDataTeamStat.Update();
} |
Partager