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; } }
private void setGame() { int gameId = Convert.ToInt32(Request.QueryString["gameId"]); using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { var game = (from _game in db.Games where _game.ID == gameId select _game).FirstOrDefault(); if (game != null) { this.gameId = game.ID; title.Value = game.mainTitle; description.Value = game.description; spectators.Value = Convert.ToString(game.spectators); weekNumber.Value = Convert.ToString(game.weekNumber); score1.Value = Convert.ToString(game.team1Score); score2.Value = Convert.ToString(game.team2Score); int ix = 0; foreach (ListItem item in teams1ListBox.Items) { if (item.Value.Equals(Convert.ToString(game.team1Id))) { teams1ListBox.SelectedIndex = ix; break; } ix++; } ix = 0; foreach (ListItem item in teams2ListBox.Items) { if (item.Value.Equals(Convert.ToString(game.team2Id))) { teams2ListBox.SelectedIndex = ix; break; } ix++; } editButton.Text = "Edit Game"; } } }
private void setTeam() { int teamId = Convert.ToInt32(Request.QueryString["teamId"]); using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { var team = (from _team in db.Teams where _team.ID == teamId select _team).FirstOrDefault(); if (team != null) { name.Value = team.name; logoPath.Value = team.logoPath; description.Value = team.description; editButton.Text = "Edit Team"; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { errorBox.Visible = false; errorBox.InnerText = ""; using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { teams1 = (from _team in db.Teams select _team).ToList(); setTeams1(); teams2 = (from _team in db.Teams select _team).ToList(); setTeams2(); } if (Request.QueryString.Count > 0) { setGame(); } } }
protected void Page_Load(object sender, EventArgs e) { Debug.WriteLine("Page was loaded"); using (GameTrackerContext db = new GameTrackerContext("GameTrackerConnection")) { var _games = (from allGames in db.Games select allGames).ToList(); this.allGames = _games; if (allGames.Count > 0) { lastGame = allGames.ElementAt(0); } if (allGames.Count > 1) { otherGames = allGames.GetRange(1, allGames.Count - 1); } else { otherGames = new List <Game>(); } Debug.WriteLine("There are # games in DB: " + allGames.Count); var _teams = (from allTeams in db.Teams select allTeams).ToList(); Debug.WriteLine("There are # teams: " + _teams.Count); foreach (var team in _teams) { Debug.WriteLine(team.name); } this.allTeams = _teams; } }
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; } }