protected void GameGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            // store which row was clicked
            int selectedRow = e.RowIndex;

            // get the selected GameId using the Grid's DataKey collection
            int GameID = Convert.ToInt32(GameGridView.DataKeys[selectedRow].Values["GameID"]);

            // use EF to find the selected game in the DB and remove it
            using (VJKMConnection db = new VJKMConnection())
            {
                // create object of the game class and store the query string inside of it
                Game deletedGame = (from GameRecords in db.Games
                                    where GameRecords.GameID == GameID
                                    select GameRecords).FirstOrDefault();

                // remove the selected game from the db
                db.Games.Remove(deletedGame);

                // save my changes back to the database
                db.SaveChanges();

                // refresh the grid
                this.ConnectionToDB();
            }
        }
Ejemplo n.º 2
0
        protected void SaveButton_Click(object sender, EventArgs e)
        {
            // Use EF to connect to the server
            using (VJKMConnection db = new VJKMConnection())
            {
                // use the game model to create a new game object and
                // save a new record
                Game newGame = new Game();

                int GameID = 0;

                if (Request.QueryString.Count > 0) // our URL has a GameId in it
                {
                    // get the id from the URL
                    GameID = Convert.ToInt32(Request.QueryString["GameID"]);

                    // get the current Game from EF DB
                    newGame = (from game in db.Games
                               where game.GameID == GameID
                               select game).FirstOrDefault();
                }

                // add form data to the new game record
                newGame.GameName        = GameNameTextBox.Text;
                newGame.GameLocation    = GLocationTextBox.Text;
                newGame.GameDescription = GameDesc.Text;
                newGame.TeamA           = TeamA.Text;
                newGame.TeamB           = TeamB.Text;
                newGame.TeamAScore      = Convert.ToInt32(TeamAScore.Text);
                newGame.TeamBScore      = Convert.ToInt32(TeamBScore.Text);
                newGame.Spectators      = Convert.ToInt32(Spectators.Text);
                newGame.WinningTeam     = WinningTeam.Text;
                newGame.GameDate        = Convert.ToDateTime(GameDateTextBox.Text);

                // use LINQ to ADO.NET to add / insert new game into the database

                if (GameID == 0)
                {
                    db.Games.Add(newGame);
                }


                // save our changes - also updates and inserts
                db.SaveChanges();

                // Redirect back to the updated GameEditPage
                Response.Redirect("~/SecurePages/GameEditPage.aspx");
            }
        }