protected void AddButton_Click(object sender, EventArgs e)
{
try
{
GameContext db = new GameContext();
game_grades newrecord = new game_grades();
newrecord.Week = Convert.ToInt32(week.Value);
newrecord.Sports_category = sportsCategory.Value;
newrecord.Team_Name = teamnameTextBox.Value;
newrecord.Point = Convert.ToInt32(scoreBox.Text);
db.game_grades.Add(newrecord);
db.SaveChanges();
week.Disabled = false;
sportsCategory.Disabled = false;
selectButton.Enabled = true;
scoreBox.Text = "";
detailAddform.Style.Add("display", "none");
reminderInformation.Text = "Add sucessfully";
}
catch (Exception exception)
{
reminderInformation.Text = "Invalid data, fail to add";
}
}
protected void getPreviousPageData()
{
try
{
using (GameContext db = new GameContext())
{
if (Request.QueryString.Count > 0)
{
gameID = Convert.ToInt32(Request.QueryString["Sports_ID"]);
updatingObject = (from s in db.game_grades
where s.Sports_ID == gameID
select s).FirstOrDefault();
TeamNameTextBox.Text = updatingObject.Team_Name;
WeekTextBox.Text = updatingObject.Week.ToString();
CategoryTextBox.Text = updatingObject.Sports_category;
PointTextBox.Text = updatingObject.Point.ToString();
}
}
errorLabel.Text = "";
}
catch (Exception)
{
errorLabel.Text = "Fail to update";
}
}
protected void updateGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int selectedRow = e.RowIndex;
int SportsID = Convert.ToInt32(deleteGridView.DataKeys[selectedRow].Values["Sports_ID"]);
using (GameContext db = new GameContext())
{
game_grades deleteRecord = (from s in db.game_grades
where s.Sports_ID == SportsID
select s).FirstOrDefault();
db.game_grades.Remove(deleteRecord);
db.SaveChanges();
}
showDataafterselecting();
}
catch (Exception exception)
{
errorInformation.Text = "Invalid operation, fail to delete";
}
}
protected void CancelButton_Click(object sender, EventArgs e)
{
try
{
using (GameContext db = new GameContext())
{
if (Request.QueryString.Count > 0)
{
gameID = Convert.ToInt32(Request.QueryString["Sports_ID"]);
updatingObject = (from s in db.game_grades
where s.Sports_ID == gameID
select s).FirstOrDefault();
String url_1 = "update.aspx?ID=" + updatingObject.Sports_ID;
Response.Redirect(url_1);
}
}
errorLabel.Text = "";
}
catch (Exception)
{
errorLabel.Text = "Fail to update";
}
}
