/** * <summary> * This event handler deletes a game from the db using EF * </summary> * * @method gdTeams_RowDeleting * @param {object} sender * @param {GridViewDeleteEventArgs} e * @returns {void} */ protected void gdTeams_RowDeleting(object sender, GridViewDeleteEventArgs e) { // store which row was clicked int selectRow = e.RowIndex; //GET TID From selected row int TID = Convert.ToInt32(gdTeams.DataKeys[selectRow].Values["TID"]); // use EF to find the selected team in the DB and remove it using (DefaultConnectionGM db = new DefaultConnectionGM()) { // create object of the team class and store the query string inside of it Models.Team deletedTeam = (from teamRecords in db.Teams where teamRecords.TID == TID select teamRecords).FirstOrDefault(); // remove the selected game from the db db.Teams.Remove(deletedTeam); // save my changes back to the database db.SaveChanges(); Session["TeamMsg"] = "Your Record Deleted Succeessfully."; // refresh the grid this.GetTeams(); getMessage(); } }
/** * <summary> * This event handler deletes a game from the db using EF * </summary> * * @method gdGames_RowDeleting * @param {object} sender * @param {GridViewDeleteEventArgs} e * @returns {void} */ protected void gdGames_RowDeleting(object sender, GridViewDeleteEventArgs e) { // store which row was clicked int selectedRow = e.RowIndex; // get the selected GID using the Grid's DataKey collection int GID = Convert.ToInt32(gdGames.DataKeys[selectedRow].Values["GID"]); // use EF to find the selected game in the DB and remove it using (DefaultConnectionGM db = new DefaultConnectionGM()) { // create object of the Game class and store the query string inside of it Models.Game deletedGame = (from gameRecords in db.Games where gameRecords.GID == GID select gameRecords).FirstOrDefault(); // remove the selected game from the db db.Games.Remove(deletedGame); // save my changes back to the database db.SaveChanges(); Session["GameMsg"] = "Your Record Deleted Succeessfully."; // refresh the grid this.GetGames(); getMessage(); } }
private void GetTeam() { try { //populate form with existing data int TID = Convert.ToInt32(Request.QueryString["TeamID"].ToString()); //connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { // populate a team object instance with the TID from the URL Parameter var Team = (from team in db.Teams where team.TID == TID select team).FirstOrDefault(); // map the team properties to the form controls if (Team != null) { txtTeamName.Text = Team.Name; txtshortdesc.Text = Team.Description; ddlGameName.SelectedValue = Team.Gid.ToString(); btnsubmit.Text = "Update"; } } } catch (Exception e) { } }
private void GetGame() { try { // populate teh form with existing data from the database int GID = Convert.ToInt32(Request.QueryString["GID"]); // connect to the EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { // populate a game object instance with the GID from the URL Parameter Models.Game updatedStudent = (from game in db.Games where game.GID == GID select game).FirstOrDefault(); // map the student properties to the form controls if (updatedStudent != null) { txtGameName.Text = updatedStudent.Name; txtshortdesc.Text = updatedStudent.Description; btnsubmit.Text = "Update"; } } } catch (Exception e) { } }
/** * <summary> * This method check if record already have in table. * </summary> * * @method checkAlready * @returns {int} */ private int checkAlready(Models.GameRecord newGameRecord) { int rowCount = 0; try { using (DefaultConnectionGM db = new DefaultConnectionGM()) { //write query var recordAlready = (from record in db.GameRecords where record.Date == newGameRecord.Date && record.Gid == newGameRecord.Gid && record.Team1 == newGameRecord.Team1 && record.Team2 == newGameRecord.Team2 && record.WTeam == newGameRecord.WTeam select record).First(); if (recordAlready != null) { rowCount = 1; } } } catch (Exception e) { } return(rowCount); }
/** * <summary> * This method gets teams from DB and bind to dropdown * </summary> * * @method ddlTeamData * @parameters {GID} * @returns {void} */ private void ddlTeamData(int GID) { try { //connect to database using (DefaultConnectionGM db = new DefaultConnectionGM()) { //write query var TeamRecords = (from records in db.Teams where records.Gid == GID select new { records.Name, records.TID }).ToList(); //bind data in team1 drop down ddlTeamName1.DataTextField = "Name"; ddlTeamName1.DataValueField = "TID"; ddlTeamName1.DataSource = TeamRecords; ddlTeamName1.DataBind(); ddlTeamName1.Enabled = true; //first item ddlTeamName1.Items.Insert(0, new ListItem("Select Team", "0")); //bind data in team2 drop down ddlTeamName2.DataTextField = "Name"; ddlTeamName2.DataValueField = "TID"; ddlTeamName2.DataSource = TeamRecords; ddlTeamName2.DataBind(); //first item ddlTeamName2.Items.Insert(0, new ListItem("Select Team", "0")); } } catch (Exception e) { } }
/** * <summary> * This method gets the games data from the DB * </summary> * * @method GetGames * @returns {void} */ protected void GetGames() { // connect to EF using (DefaultConnectionGM db = new DefaultConnectionGM()) { string SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); // query the Games Table using EF and LINQ var Games = (from allGames in db.Games select allGames); // bind the result to the GridView gdGames.DataSource = Games.AsQueryable().OrderBy(SortString).ToList(); gdGames.DataBind(); } }
/** * <summary> * This event handler Shows pop-up box with game name and description * </summary> * * @method lbGame_Click * @param {object} sender * @param {EventArgs} e * @returns {void} */ protected void lbGame_Click(object sender, EventArgs e) { // find link button and createe object LinkButton lnkBtnTags = (LinkButton)sender; //Connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { var recordGame = (from record in db.Games where record.Name == lnkBtnTags.Text.Trim() select record).FirstOrDefault(); //bind data to model pop up lblTitle.Text = recordGame.Name; lblbody.Text = recordGame.Description; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true); } }
/** * <summary> * This method gets the teams data from the DB * </summary> * * @method GetTeams * @returns {void} */ private void GetTeams() { // connect to EF using (DefaultConnectionGM db = new DefaultConnectionGM()) { string SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString(); // query the Teams Table using EF and LINQ var Teams = (from allTeams in db.Teams join allGames in db.Games on allTeams.Gid equals allGames.GID select new { allTeams.Name, allTeams.Description, GName = allGames.Name, allTeams.TID, allTeams.Gid, allGames.GID }); // bind the result to the GridView gdTeams.DataSource = Teams.AsQueryable().OrderBy(SortString).ToList(); gdTeams.DataBind(); } }
/** * <summary> * This method gets gamesrecords from DB and bind to form * </summary> * * @method GetGameRecord * @returns {void} */ private void GetGameRecord() { try { int GRID = Convert.ToInt32(Request.QueryString["GRID"]); if (GRID > 0) { //connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { var gameRecords = (from records in db.GameRecords where records.GRID == GRID select records).FirstOrDefault(); //bind data to form txtGameDate.Text = gameRecords.Date.ToString("yyyy-MM-dd"); txtWinTeamScore.Text = gameRecords.T1WinScore.ToString(); txtLoseTeamScore.Text = gameRecords.T2WinScore.ToString(); txtSpectators.Text = gameRecords.Sepectators.ToString(); ddlGameName.SelectedValue = gameRecords.Gid.ToString(); //fill team drop down ddlTeamData(gameRecords.Gid); //set selected value to team dropdowns ddlTeamName1.SelectedValue = gameRecords.Team1.ToString(); ddlTeamName2.SelectedValue = gameRecords.Team2.ToString(); ddlTeamName2.Enabled = true; //bind value to win dropdown ddlWinTeam.Items.Clear(); ddlWinTeam.Items.Insert(0, new ListItem("Select Winning Team", "0")); ddlWinTeam.Items.Insert(1, new ListItem(ddlTeamName1.SelectedItem.Text.ToString(), ddlTeamName1.SelectedValue)); ddlWinTeam.Items.Insert(2, new ListItem(ddlTeamName2.SelectedItem.Text.ToString(), ddlTeamName2.SelectedValue)); ddlWinTeam.SelectedValue = gameRecords.WTeam.ToString(); ddlWinTeam.Enabled = true; btnsubmit.Text = "Update"; } } } catch (Exception e) { } }
/** * <summary> * This method gets the student data from the DB * </summary> * * @method GetGameRecords * @returns {void} */ private void GetGameRecords() { try { //geberate sorting string SortString = Session["SortColumn"] + " " + Session["SortDirection"]; //Connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { var GameRecords = (from GR in db.GameRecords join G in db.Games on GR.Gid equals G.GID join T in db.Teams on GR.Team1 equals T.TID join T1 in db.Teams on GR.Team2 equals T1.TID join W in db.Teams on GR.WTeam equals W.TID select new { GR.GRID, GR.Sepectators, GR.T1WinScore, GR.T2WinScore, GR.Date, GR.Team2, GR.Team1, GR.WTeam, GName = G.Name, TeamN1 = T.Name, TeamN2 = T1.Name, WTeamN = W.Name }); //bind result to grid view gdGameRecord.DataSource = GameRecords.AsQueryable().OrderBy(SortString).ToList(); gdGameRecord.DataBind(); } } catch (Exception e) { } }
/** * <summary> * This method gets the games data from the DB * </summary> * * @method bindGames * @returns {void} */ private void bindGames() { //Connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { if (Week == 0) { //get current week CultureInfo ciCurr = CultureInfo.CurrentCulture; Week = Convert.ToInt32(ciCurr.Calendar.GetWeekOfYear(DateTime.Now, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday).ToString()); } lbprevious.CommandArgument = (Week - 1).ToString(); lbnext.CommandArgument = (Week + 1).ToString(); //write query var GameRecords = (from GR in db.GameRecords join G in db.Games on GR.Gid equals G.GID join T in db.Teams on GR.Team1 equals T.TID join T1 in db.Teams on GR.Team2 equals T1.TID join W in db.Teams on GR.WTeam equals W.TID where GR.Week == Week select new { GR.GRID, GR.Sepectators, GR.T1WinScore, GR.T2WinScore, GR.Date, GR.Team2, GR.Team1, GR.WTeam, GName = G.Name, TeamN1 = T.Name, TeamN2 = T1.Name, WTeamN = W.Name, TotalScore = GR.T1WinScore + GR.T2WinScore, GR.Week }); if (GameRecords.Count() > 0) { //bind result to grid view rptGame.DataSource = GameRecords.ToList(); rptGame.DataBind(); Jumbotron3.Visible = false; rptGame.Visible = true; } else { rptGame.DataSource = null; rptGame.DataBind(); Jumbotron3.Visible = true; rptGame.Visible = true; } } }
/* <summary> * This method check if record already have in table. * </summary> * * @method checkAlready * @returns {int } */ private int checkAlready(Models.Game newGame) { int rowCount = 0; try { using (DefaultConnectionGM db = new DefaultConnectionGM()) { //write query var recordAlready = (from record in db.Games where record.Name == newGame.Name select record).First(); if (recordAlready != null) { rowCount = 1; } } } catch (Exception e) { } return(rowCount); }
/** * <summary> * This method gets total number of records from each table. * </summary> * * @method GetData * @returns {void} */ private void GetData() { using (DefaultConnectionGM db = new DefaultConnectionGM()) { //games count var countGame = (from count in db.Games select count).Count(); //teams count var countTeam = (from count in db.Teams select count).Count(); //games records var countGRecords = (from count in db.GameRecords select count).Count(); //bind data lblGames.Text = countGame.ToString(); lblTeams.Text = countTeam.ToString(); lblGRecord.Text = countGRecords.ToString(); } }
/** * <summary> * This method gets games from DB and bind to dropdown * </summary> * * @method ddlBindGameData * @returns {void} */ private void ddlBindGameData() { try { using (DefaultConnectionGM db = new DefaultConnectionGM()) { //Write query ddlGameName.DataSource = (from allGames in db.Games orderby allGames.Name select new { allGames.GID, allGames.Name }).ToList(); //bind data to dropdown ddlGameName.DataTextField = "Name"; ddlGameName.DataValueField = "GID"; //ddlGameName.DataSource = Games; ddlGameName.DataBind(); //first item ddlGameName.Items.Insert(0, new ListItem("Select Game", "0")); } } catch (Exception e) { } }
/** * <summary> * This event handler deletes a game record from the db using EF * </summary> * * @method gdGameRecord_RowDeleting * @param {object} sender * @param {GridViewDeleteEventArgs} e * @returns {void} */ protected void gdGameRecord_RowDeleting(object sender, GridViewDeleteEventArgs e) { // store which row was clicked int selectRow = e.RowIndex; //get id form selected row int GRID = Convert.ToInt32(gdGameRecord.DataKeys[selectRow].Values["GRID"]); //Connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { var deleteRecord = (from record in db.GameRecords where record.GRID == GRID select record).FirstOrDefault(); db.GameRecords.Remove(deleteRecord); db.SaveChanges(); //refresh grid GetGameRecords(); Session["GRMsg"] = "Your Record Delete Succeessfully."; getMessage(); } }
/** * <summary> * This event handler allows to add or update records to DB * </summary> * * @method btnsubmit_Click * @param {object} sender * @param {EventArgs} e * @returns {void} */ protected void btnsubmit_Click(object sender, EventArgs e) { int rowCount; // Use EF to connect to the server using (DefaultConnectionGM db = new DefaultConnectionGM()) { // use the Games model to create a new game object and // save a new record Models.Game newGame = new Models.Game(); int GID = 0; if (Request.QueryString.Count > 0) // our URL has a StudentID in it { // get the id from the URL GID = Convert.ToInt32(Request.QueryString["GID"]); // get the current student from EF DB newGame = (from game in db.Games where game.GID == GID select game).FirstOrDefault(); Session["GameMsg"] = "Your Record Updated Succeessfully."; } // add form data to the new game record newGame.Name = txtGameName.Text; newGame.Description = txtshortdesc.Text; // use LINQ to ADO.NET to add / insert new student into the database if (GID == 0) { //check record is already in DB rowCount = checkAlready(newGame); if (rowCount == 0) { db.Games.Add(newGame); Session["GameMsg"] = "Your Record Added Succeessfully."; // save our changes - also updates and inserts db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/Game.aspx"); } else { lblMsg.Text = "Record has been already added."; alertMsg.Visible = true; } } else { // save our changes - also updates and inserts db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/Game.aspx"); } } }
/** * <summary> * This event handler update or add record to DB * </summary> * * @method btnsubmit_Click * @param {object} sender * @param {EventArgs} e * @returns {void} */ protected void btnsubmit_Click(object sender, EventArgs e) { int rowCount; // Use EF to connect to the server using (DefaultConnectionGM db = new DefaultConnectionGM()) { // use the Teams model to create a new team object and // save a new record Models.Team newTeam = new Models.Team(); int TID = 0; if (Request.QueryString.Count > 0) { TID = Convert.ToInt32(Request.QueryString["TeamID"]); //write query newTeam = (from teamRecord in db.Teams where teamRecord.TID == TID select teamRecord).FirstOrDefault(); Session["TeamMsg"] = "Your Record Updated Succeessfully."; } //add data to DB newTeam.Name = txtTeamName.Text.ToString().Trim(); newTeam.Description = txtshortdesc.Text.ToString().Trim(); newTeam.Gid = Convert.ToInt32(ddlGameName.SelectedValue); //check operation insert or update if (TID == 0) { //check record is already in DB rowCount = checkAlready(newTeam); if (rowCount == 0) { db.Teams.Add(newTeam); Session["TeamMsg"] = "Your Record Added Succeessfully."; //save our change db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/Team.aspx"); } else { lblMsg.Text = "Record has been already added."; alertMsg.Visible = true; } } else { //save our change db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/Team.aspx"); } } }
/** * <summary> * This event handler allows to save or update data * </summary> * * @method btnsubmit_Click * @param {object} sender * @param {EventArgs} e * @returns {void} */ protected void btnsubmit_Click(object sender, EventArgs e) { int rowCount; //connect to EF DB using (DefaultConnectionGM db = new DefaultConnectionGM()) { if (Convert.ToInt32(txtWinTeamScore.Text) > Convert.ToInt32(txtLoseTeamScore.Text)) { if ((ddlTeamName1.SelectedValue != ddlTeamName2.SelectedValue)) { int GRID = 0; //define onject of Game record model Models.GameRecord newGameRecord = new Models.GameRecord(); if (Request.QueryString.Count > 0) { GRID = Convert.ToInt32(Request.QueryString["GRID"]); newGameRecord = (from record in db.GameRecords where record.GRID == GRID select record).FirstOrDefault(); Session["GRMsg"] = "Your Record Updated Succeessfully."; } newGameRecord.Date = Convert.ToDateTime(txtGameDate.Text.ToString()); newGameRecord.Gid = Convert.ToInt32(ddlGameName.SelectedValue); newGameRecord.Team1 = Convert.ToInt32(ddlTeamName1.SelectedValue); newGameRecord.Team2 = Convert.ToInt32(ddlTeamName2.SelectedValue); newGameRecord.WTeam = Convert.ToInt32(ddlWinTeam.SelectedValue); newGameRecord.Sepectators = Convert.ToInt32(txtSpectators.Text.ToString().Trim()); newGameRecord.T1WinScore = Convert.ToInt32(txtWinTeamScore.Text.ToString().Trim()); newGameRecord.T2WinScore = Convert.ToInt32(txtLoseTeamScore.Text.ToString().Trim()); newGameRecord.T1LoseScore = Convert.ToInt32(txtLoseTeamScore.Text.ToString().Trim()); newGameRecord.T2LoseScore = Convert.ToInt32(txtWinTeamScore.Text.ToString().Trim()); newGameRecord.TotalScore = Convert.ToInt32(txtWinTeamScore.Text.ToString().Trim()) + Convert.ToInt32(txtLoseTeamScore.Text.ToString().Trim()); CultureInfo ciCurr = CultureInfo.CurrentCulture; newGameRecord.Week = Convert.ToInt32(ciCurr.Calendar.GetWeekOfYear(Convert.ToDateTime(txtGameDate.Text.ToString()), CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday).ToString()); //check insert of update operation if (GRID == 0) { //check record is already in DB rowCount = checkAlready(newGameRecord); if (rowCount == 0) { db.GameRecords.Add(newGameRecord); Session["GRMsg"] = "Your Record Added Succeessfully."; //save our change db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/GameRecord.aspx"); } else { lblMsg.Text = "Record has been already added."; alertMsg.Visible = true; } } else { //save our change db.SaveChanges(); // Redirect back to the updated games page Response.Redirect("~/AdminPanel/GameRecord.aspx"); } } else { lblMsg.Text = "Team1 and Team2 have different value."; ddlTeamName1.Focus(); alertMsg.Visible = true; } } else { lblMsg.Text = "Winning team has always higher score."; txtWinTeamScore.Focus(); alertMsg.Visible = true; } } }