protected void GetGame()
{
// populate the form with existing department data from the db
int GameID = Convert.ToInt32(Request.QueryString["gameID"]);
// connect to the EF DB
using (GameConnection db = new GameConnection())
{
// populate a department instance with the departmentID from the URL parameter
game updatedGame = (from Games in db.games
where Games.gameID == GameID
select Games).FirstOrDefault();
// map the Department properties to the form controls
if (updatedGame != null)
{
teamA.Text = updatedGame.teamA;
teamB.Text = updatedGame.teamB;
teamAScore.Text = updatedGame.teamAScore.ToString();
teamBScore.Text = updatedGame.teamBScore.ToString();
}
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
using (GameConnection db = new GameConnection())
{
game newGame = new game();
if (football.Checked == true)
{
var game = "football";
newGame.teamA = teamA.Text;
newGame.teamB = teamB.Text;
newGame.teamAScore = Convert.ToInt32(teamAScore.Text);
newGame.teamBScore = Convert.ToInt32(teamBScore.Text);
newGame.selectedGame = game;
db.games.Add(newGame);
db.SaveChanges();
}
if (cricket.Checked == true)
{
var game = "cricket";
newGame.teamA = teamA.Text;
newGame.teamB = teamB.Text;
newGame.teamAScore = Convert.ToInt32(teamAScore.Text);
newGame.teamBScore = Convert.ToInt32(teamBScore.Text);
newGame.selectedGame = game;
db.games.Add(newGame);
db.SaveChanges();
}
if (hockey.Checked == true)
{
var game = "hockey";
newGame.teamA = teamA.Text;
newGame.teamB = teamB.Text;
newGame.teamAScore = Convert.ToInt32(teamAScore.Text);
newGame.teamBScore = Convert.ToInt32(teamBScore.Text);
newGame.selectedGame = game;
db.games.Add(newGame);
db.SaveChanges();
}
Response.Redirect("~/Default.aspx");
}
}