protected void deleteGame_click(object sender, EventArgs e) { int gameID = 0; // Check if query string value exists if (!String.IsNullOrEmpty(Request.QueryString["gameID"])) { // Query string value is there so now use it gameID = Convert.ToInt32(Request.QueryString["gameID"]); } if (gameID > 0) { // use EF and LINQ to find the selected game and delete it from DB! using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { // create a Game object and store the query inside it Game toBeDeleted = (from game in db.Games where game.ID == gameID select game).FirstOrDefault(); // remove and save! db.Games.Remove(toBeDeleted); db.SaveChanges(); // Go back to the home page Response.Redirect("Default.aspx"); } } }
protected void editGame_click(object sender, EventArgs e) { try { using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { int gameId = Convert.ToInt32(Request.QueryString["gameId"]); Game game = null; if (gameId == 0) { game = new Game(); db.Games.Add(game); } else { game = (from _game in db.Games where _game.ID == gameId select _game).FirstOrDefault(); } if (game != null) { game.team1Id = Convert.ToInt32(teams1ListBox.SelectedItem.Value); game.team2Id = Convert.ToInt32(teams2ListBox.SelectedItem.Value); game.spectators = Convert.ToInt32(spectators.Value); game.team1Score = Convert.ToInt32(score1.Value); game.team2Score = Convert.ToInt32(score2.Value); game.mainTitle = title.Value; game.description = description.Value; game.weekNumber = Convert.ToInt32(weekNumber.Value); validateGame(game); } // save the team db.SaveChanges(); Response.Redirect("~/Default.aspx"); } } catch (Exception ex) { errorBox.Visible = true; errorBox.InnerText = ex.Message; } }
protected void editTeam_click(object sender, EventArgs e) { try { using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { int teamId = Convert.ToInt32(Request.QueryString["teamId"]); Team team = null; if (teamId == 0) { team = new Team(); db.Teams.Add(team); } else { team = (from _team in db.Teams where _team.ID == teamId select _team).FirstOrDefault(); } if (team != null) { team.name = name.Value; team.logoPath = logoPath.Value; team.description = description.Value; } // save the team db.SaveChanges(); Response.Redirect("~/Default.aspx"); } } catch (Exception ex) { errorBox.Visible = true; errorBox.InnerText = ex.Message; } }