protected void SaveButton_Click(object sender, EventArgs e) { // Use EF to connect to the server using (TeamConnection db = new TeamConnection()) { // use the Student model to create a new student object and // save a new record team newTeam = new team(); int TeamID = 0; if (Request.QueryString.Count > 0) // our URL has a StudentID in it { // get the id from the URL TeamID = Convert.ToInt32(Request.QueryString["team_id"]); // get the current student from EF DB newTeam = (from teams in db.teams where teams.team_id == TeamID select teams).FirstOrDefault(); } // add form data to the new student record newTeam.team_wins = Convert.ToInt32(WinsTextBox.Text); newTeam.team_losses = Convert.ToInt32(LossesTextBox.Text); newTeam.team_rank = Convert.ToInt32(RankTextBox.Text); newTeam.team_number_of_games = Convert.ToInt32(NumberofGamesTextBox.Text); // use LINQ to ADO.NET to add / insert new student into the database if (TeamID == 0) { db.teams.Add(newTeam); } // save our changes - also updates and inserts try { db.SaveChanges(); } catch (Exception err) { Console.WriteLine(err); } // Redirect back to the updated students page Response.Redirect("~/Default.aspx"); } }
/** * @description Event Handler for deleteing a game * @method GamesGridView_RowDeleting * @param {object} sender * @param {EventArgs} e * @return {void} */ protected void GamesGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { int selectedRow = e.RowIndex; int GameId = Convert.ToInt32(GamesGridView.DataKeys[selectedRow].Values["GameId"]); using (TeamConnection db = new TeamConnection()) { Game deleteGame = (from game in db.Games where game.GameId == GameId select game).FirstOrDefault(); db.Games.Remove(deleteGame); db.SaveChanges(); this.GetGames(); } }
/** * @description Event Handler deleting a team from the database * @method TeamsGridView_RowDeleting * @param {object} sender * @param {EventArgs} e * @return {void} */ protected void TeamsGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { int selectedRow = e.RowIndex; int TeamId = Convert.ToInt32(TeamsGridView.DataKeys[selectedRow].Values["TeamId"]); using (TeamConnection db = new TeamConnection()) { Team deleteTeam = (from team in db.Teams where team.TeamId == TeamId select team).FirstOrDefault(); db.Teams.Remove(deleteTeam); db.SaveChanges(); this.GetTeams(); } }
/** * @description Event Handler for save button press, saves the team into the database if all required fields are filed in * @method SaveButton_Click * @param {object} sender * @param {EventArgs} e * @return {void} */ protected void SaveButton_Click(object sender, EventArgs e) { //use EF to connect to the server using (TeamConnection db = new TeamConnection()) { //use the Student model to create a new student object and //save a new record Game newGame = new Game(); string home = HomeTeamDropDownList.Text; string away = AwayTeamDropDownList.Text; System.Diagnostics.Debug.WriteLine(HomeTeamDropDownList.Text); System.Diagnostics.Debug.WriteLine(home); System.Diagnostics.Debug.WriteLine(home.Equals("Balls & Dolls")); var homeTeamId = (from teams in db.Teams where teams.TeamName == home select teams).FirstOrDefault().TeamId; var awayTeamId = (from teams in db.Teams where teams.TeamName == away select teams).FirstOrDefault().TeamId; System.Diagnostics.Debug.WriteLine(homeTeamId); System.Diagnostics.Debug.WriteLine(homeTeamId); System.Diagnostics.Debug.WriteLine(homeTeamId); System.Diagnostics.Debug.WriteLine(homeTeamId); //add data to the new Game record newGame.HomeTeamId = Convert.ToInt32(homeTeamId); newGame.AwayTeamId = Convert.ToInt32(awayTeamId); newGame.HomePoints = Convert.ToInt32(HomePointsTextBox.Text); newGame.AwayPoints = Convert.ToInt32(AwayPointsTextBox.Text); newGame.Spectators = Convert.ToInt32(SpectatorsTextBox.Text); newGame.GameDate = Convert.ToDateTime(GameDateTextBox.Text); //use LINQ to ADO.net to add / insert my new Game into the DB db.Games.Add(newGame); //save our changes db.SaveChanges(); //redirect back to the updated Games page Response.Redirect("~/DodgeBall/Games.aspx"); } }
/** * @description Event Handler for save button click * @method SaveButton_Click * @param {object} sender * @param {EventArgs} e * @return {void} */ protected void SaveButton_Click(object sender, EventArgs e) { //connect to the server using (TeamConnection db = new TeamConnection()) { Team newTeam = new Team(); int teamID = 0; if (Request.QueryString.Count > 0) { teamID = Convert.ToInt32(Request.QueryString["teamID"]); newTeam = (from team in db.Teams where team.TeamId == teamID select team).FirstOrDefault(); } //add data to the new student record newTeam.TeamName = TeamNameTextBox.Text; if (teamID == 0) { //use LINQ and ADO.NET to add or insert newStudent into the Database db.Teams.Add(newTeam); } //save changes db.SaveChanges(); //redirect back to the updated students page Response.Redirect("~/DodgeBall/Teams.aspx"); } }