/**
* <summary>
* This method is called when the delete button is pressed for a football game
* </summary>
*
* @method FootballGridView_RowDeleting
* @param {object} sender
* @param {GridViewPageEventArgs} e
* @returns {void}
*/
protected void FootballGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var authenticationManager = HttpContext.Current.GetOwinContext().Authentication;
if (authenticationManager.User.Identity.Name == "")
{
Response.Redirect("~/Login.aspx");
}
else
{
// store which row was clicked
int selectedRow = e.RowIndex;
// get the selected StudentID using the Grid's DataKey collection
int GameID = Convert.ToInt32(FootballGridView.DataKeys[selectedRow].Values["GameID"]);
// use EF to find the selected student in the DB and remove it
using (SportScores db = new SportScores())
{
// create object of the Student class and store the query string inside of it
Football_Score deletedGame = (from savedGames in db.Football_Scores
where savedGames.GameID == GameID
select savedGames).FirstOrDefault();
// remove the selected student from the db
db.Football_Scores.Remove(deletedGame);
// save my changes back to the database
db.SaveChanges();
// refresh the grid
this.GetGames();
}
}
}
/**
* <summary>
* This method is called when the save button is pressed. It saves the provided game information to the database
* </summary>
*
* @method SaveButton_Click
* @param {object} sender
* @param {GridViewPageEventArgs} e
* @returns {void}
*/
protected void SaveButton_Click(object sender, EventArgs e)
{
//The user has selected to add a Football game
if (Sport.SelectedValue == "1")
{
// Use EF to connect to the server
using (SportScores db = new SportScores())
{
// use the Student model to create a new student object and save a new record
Football_Score newGame = new Football_Score();
int GameId = 0;
if (Request.QueryString.Count > 0) // our URL has this GameID in it (edit mode)
{
// get the id from the URL
GameId = Convert.ToInt32(Request.QueryString["GameId"]);
// get the current student from EF DB
newGame = (from GameScore in db.Football_Scores
where GameScore.GameID == GameId
select GameScore).FirstOrDefault();
}
// add form data to the new student record
newGame.GameWeek = Convert.ToInt32(GameWeekDropDownList.SelectedValue);
newGame.Spectators = Convert.ToInt32(SpectatorsTextBox.Text);
newGame.TeamNameOne = TeamOneNameTextBox.Text;
newGame.TeamNameTwo = TeamTwoNameTextBox.Text;
newGame.PointsScoredTeamOne = Convert.ToInt32(TeamOneScoreTextBox.Text);
newGame.PointsScoredTeamTwo = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamOne = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamTwo = Convert.ToInt32(TeamOneScoreTextBox.Text);
//Check which team had the higher score, and save it as the winner
if (newGame.PointsScoredTeamOne > newGame.PointsScoredTeamTwo)
{
newGame.TeamWon = newGame.TeamNameOne;
}
else
{
newGame.TeamWon = newGame.TeamNameTwo;
}
// use LINQ to ADO.NET to add / insert new student into the database
if (GameId == 0)
{
db.Football_Scores.Add(newGame);
}
// save our changes - also updates and inserts
db.SaveChanges();
// Redirect back to the updated students page
Response.Redirect("~/Default.aspx");
}
}
//The user has selected to add a Soccer game
if (Sport.SelectedValue == "2")
{
// Use EF to connect to the server
using (SportScores db = new SportScores())
{
// use the Student model to create a new student object and save a new record
Soccer_Score newGame = new Soccer_Score();
int GameId = 0;
if (Request.QueryString.Count > 0) // our URL has this GameID in it (edit mode)
{
// get the id from the URL
GameId = Convert.ToInt32(Request.QueryString["GameId"]);
// get the current student from EF DB
newGame = (from GameScore in db.Soccer_Scores
where GameScore.GameID == GameId
select GameScore).FirstOrDefault();
}
// add form data to the new student record
newGame.GameWeek = Convert.ToInt32(GameWeekDropDownList.SelectedValue);
newGame.Spectators = Convert.ToInt32(SpectatorsTextBox.Text);
newGame.TeamNameOne = TeamOneNameTextBox.Text;
newGame.TeamNameTwo = TeamTwoNameTextBox.Text;
newGame.PointsScoredTeamOne = Convert.ToInt32(TeamOneScoreTextBox.Text);
newGame.PointsScoredTeamTwo = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamOne = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamTwo = Convert.ToInt32(TeamOneScoreTextBox.Text);
//Check which team had the higher score, and save it as the winner
if (newGame.PointsScoredTeamOne > newGame.PointsScoredTeamTwo)
{
newGame.TeamWon = newGame.TeamNameOne;
}
else
{
newGame.TeamWon = newGame.TeamNameTwo;
}
// use LINQ to ADO.NET to add / insert new student into the database
if (GameId == 0)
{
db.Soccer_Scores.Add(newGame);
}
// save our changes - also updates and inserts
db.SaveChanges();
// Redirect back to the updated students page
Response.Redirect("~/Default.aspx");
}
}
//The user has selected to add a Hockey game
if (Sport.SelectedValue == "3")
{
// Use EF to connect to the server
using (SportScores db = new SportScores())
{
// use the Student model to create a new student object and save a new record
Hockey_Score newGame = new Hockey_Score();
int GameId = 0;
if (Request.QueryString.Count > 0) // our URL has this GameID in it (edit mode)
{
// get the id from the URL
GameId = Convert.ToInt32(Request.QueryString["GameId"]);
// get the current student from EF DB
newGame = (from GameScore in db.Hockey_Scores
where GameScore.GameID == GameId
select GameScore).FirstOrDefault();
}
// add form data to the new student record
newGame.GameWeek = Convert.ToInt32(GameWeekDropDownList.SelectedValue);
newGame.Spectators = Convert.ToInt32(SpectatorsTextBox.Text);
newGame.TeamNameOne = TeamOneNameTextBox.Text;
newGame.TeamNameTwo = TeamTwoNameTextBox.Text;
newGame.PointsScoredTeamOne = Convert.ToInt32(TeamOneScoreTextBox.Text);
newGame.PointsScoredTeamTwo = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamOne = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamTwo = Convert.ToInt32(TeamOneScoreTextBox.Text);
//Check which team had the higher score, and save it as the winner
if (newGame.PointsScoredTeamOne > newGame.PointsScoredTeamTwo)
{
newGame.TeamWon = newGame.TeamNameOne;
}
else
{
newGame.TeamWon = newGame.TeamNameTwo;
}
// use LINQ to ADO.NET to add / insert new student into the database
if (GameId == 0)
{
db.Hockey_Scores.Add(newGame);
}
// save our changes - also updates and inserts
db.SaveChanges();
// Redirect back to the updated students page
Response.Redirect("~/Default.aspx");
}
}
//The user has selected to add a Lacrosse game
if (Sport.SelectedValue == "4")
{
// Use EF to connect to the server
using (SportScores db = new SportScores())
{
// use the Student model to create a new student object and save a new record
lacrosse_Score newGame = new lacrosse_Score();
int GameId = 0;
if (Request.QueryString.Count > 0) // our URL has this GameID in it (edit mode)
{
// get the id from the URL
GameId = Convert.ToInt32(Request.QueryString["GameId"]);
// get the current student from EF DB
newGame = (from GameScore in db.lacrosse_Scores
where GameScore.GameID == GameId
select GameScore).FirstOrDefault();
}
// add form data to the new student record
newGame.GameWeek = Convert.ToInt32(GameWeekDropDownList.SelectedValue);
newGame.Spectators = Convert.ToInt32(SpectatorsTextBox.Text);
newGame.TeamNameOne = TeamOneNameTextBox.Text;
newGame.TeamNameTwo = TeamTwoNameTextBox.Text;
newGame.PointsScoredTeamOne = Convert.ToInt32(TeamOneScoreTextBox.Text);
newGame.PointsScoredTeamTwo = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamOne = Convert.ToInt32(TeamTwoScoreTextBox.Text);
newGame.PointsAllowedTeamTwo = Convert.ToInt32(TeamOneScoreTextBox.Text);
//Check which team had the higher score, and save it as the winner
if (newGame.PointsScoredTeamOne > newGame.PointsScoredTeamTwo)
{
newGame.TeamWon = newGame.TeamNameOne;
}
else
{
newGame.TeamWon = newGame.TeamNameTwo;
}
// use LINQ to ADO.NET to add / insert new student into the database
if (GameId == 0)
{
db.lacrosse_Scores.Add(newGame);
}
// save our changes - also updates and inserts
db.SaveChanges();
// Redirect back to the updated students page
Response.Redirect("~/Default.aspx");
}
}
}