protected void Button3_Click(object sender, EventArgs e)
{
//adding a game
string homeTeam = TextBox1.Text;
string awayTeam = TextBox2.Text;
decimal homeOdds = Convert.ToDecimal(TextBox3.Text);
decimal awayOdds = Convert.ToDecimal(TextBox4.Text);
Sports_Table newGame = new Sports_Table
{
Home = homeTeam,
Away = awayTeam,
H__win = homeOdds,
A__win = awayOdds,
};
dbcon.Sports_Tables.Add(newGame);
dbcon.SaveChanges();
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//first checks if there is anything selected in the grid
if (GridView1.SelectedDataKey.Value != null)
{
int id = Convert.ToInt32(GridView1.SelectedDataKey.Value.ToString());
//grabs the game using the id
Sports_Table game = (from x in dbcon.Sports_Tables
where x.Match_ID == id
select x).First();
//if the admin clicks the button when the dropdown is on home
if (DropDownList1.SelectedValue.Equals("Home"))
{
//sets the values of the winner
game.Home_Winner = 1;
game.Away_Winner = 0;
//goes through each bet
foreach (Bet x in dbcon.Bets)
{
//if the bet has the same match id as the match that is selected
if (x.MatchId == game.Match_ID)
{
//grabs the person that made the bet
User_Admin_Table person = (from y in dbcon.User_Admin_Tables
where y.Id == x.UserId
select y).First();
//if the bet is correct, assigns the correct amount to winnings and adds to the persons balance
if (x.HomeAway.Equals("Home"))
{
x.Winnings = x.BetAmount * game.H__win;
person.Balance = person.Balance + Convert.ToDecimal(x.Winnings);
}
//if not right, simply sets winnings to 0
else
{
x.Winnings = 0;
}
}
}
}
//when the admin clicks the button when the dropdown is on away
//same as above except for if away wins
else
{
game.Home_Winner = 0;
game.Away_Winner = 1;
foreach (Bet x in dbcon.Bets)
{
if (x.MatchId == game.Match_ID)
{
User_Admin_Table person = (from y in dbcon.User_Admin_Tables
where y.Id == x.UserId
select y).First();
if (x.HomeAway.Equals("Away"))
{
x.Winnings = x.BetAmount * game.A__win;
person.Balance = person.Balance + Convert.ToDecimal(x.Winnings);
}
else
{
x.Winnings = 0;
}
}
}
}
//saves changes and updates the grids
dbcon.SaveChanges();
GridView1.DataBind();
GridView2.DataBind();
GridView3.DataBind();
}
else
{
}
}