/** * <summary> * This method pupulate the Gridview with teams list * </summary> * * @method GetTeams * @returns * */ protected void GetTeams() { // populate the form with existing gmae data from the db int GameID = Convert.ToInt32(Request.QueryString["GameID"]); // connect to EF using (GameTrackerConnection db = new GameTrackerConnection()) { // query the games Table using EF and LINQ var Teams = (from allTeam in db.Teams where allTeam.GameID == GameID select allTeam); // bind the result to the GridView TeamsGridView.DataSource = Teams.AsQueryable().ToList(); TeamsGridView.DataBind(); } }
private void ShowImportData() { TeamsGridView.DataSource = null; TeamsGridView.Columns.Clear(); TeamsGridView.Rows.Clear(); TeamsGridView.Refresh(); TeamsGridView.AutoGenerateColumns = false; TeamsGridView.Columns.Add("Name", "Team"); TeamsGridView.Columns.Add("Wins", "W"); TeamsGridView.Columns.Add("Losses", "L"); TeamsGridView.Columns.Add("RPIRank", "RPI Rank"); TeamsGridView.Columns.Add("SoSRank", "SoS Rank"); TeamsGridView.Columns.Add("RPI", "RPI"); TeamsGridView.Columns.Add("SoS", "SoS"); TeamsGridView.Columns.Add("WP", "WP"); TeamsGridView.Columns.Add("OWP", "OWP"); TeamsGridView.Columns.Add("OOWP", "OOWP"); TeamsGridView.Columns.Add("PythRPI", "PythRPI"); TeamsGridView.Columns.Add("PythRPIRank", "PythRPIRank"); TeamsGridView.Columns[0].DataPropertyName = "Name"; TeamsGridView.Columns[1].DataPropertyName = "Wins"; TeamsGridView.Columns[2].DataPropertyName = "Losses"; TeamsGridView.Columns[3].DataPropertyName = "RPIRank"; TeamsGridView.Columns[4].DataPropertyName = "StrengthOfScheduleRank"; TeamsGridView.Columns[5].DataPropertyName = "RPI"; TeamsGridView.Columns[6].DataPropertyName = "StrengthOfSchedule"; TeamsGridView.Columns[7].DataPropertyName = "WinningPercentage"; TeamsGridView.Columns[8].DataPropertyName = "OpponentsWinPercentage"; TeamsGridView.Columns[9].DataPropertyName = "OpponentsOpponentWinPercentage"; TeamsGridView.Columns[10].DataPropertyName = "PythRPI"; TeamsGridView.Columns[11].DataPropertyName = "PythRPIRanking"; TeamsGridView.DataSource = Teams; TeamsGridView.Sort(TeamsGridView.Columns["Name"], ListSortDirection.Ascending); }
private void btnAll_Click(object sender, EventArgs e) { TeamsGridView.DataSource = null; TeamsGridView.Columns.Clear(); TeamsGridView.Rows.Clear(); TeamsGridView.Refresh(); TeamsGridView.AutoGenerateColumns = false; TeamsGridView.Columns.Add("Name", "Team"); TeamsGridView.Columns.Add("Division", "Division"); TeamsGridView.Columns.Add("Wins", "W"); TeamsGridView.Columns.Add("Losses", "L"); TeamsGridView.Columns.Add("RPIRank", "RPI Rank"); TeamsGridView.Columns.Add("SoSRank", "SoS Rank"); TeamsGridView.Columns.Add("RPI", "RPI"); TeamsGridView.Columns.Add("PrevRPI", "PrevRPI"); TeamsGridView.Columns.Add("SoS", "SoS"); TeamsGridView.Columns.Add("WP", "WP"); TeamsGridView.Columns.Add("OWP", "OWP"); TeamsGridView.Columns.Add("OOWP", "OOWP"); TeamsGridView.Columns[0].DataPropertyName = "Name"; TeamsGridView.Columns[1].DataPropertyName = "Division"; TeamsGridView.Columns[2].DataPropertyName = "Wins"; TeamsGridView.Columns[3].DataPropertyName = "Losses"; TeamsGridView.Columns[4].DataPropertyName = "RPIRank"; TeamsGridView.Columns[5].DataPropertyName = "StrengthOfScheduleRank"; TeamsGridView.Columns[6].DataPropertyName = "RPI"; TeamsGridView.Columns[7].DataPropertyName = "PreviousRPI"; TeamsGridView.Columns[8].DataPropertyName = "StrengthOfSchedule"; TeamsGridView.Columns[9].DataPropertyName = "WinningPercentage"; TeamsGridView.Columns[10].DataPropertyName = "OpponentsWinPercentage"; TeamsGridView.Columns[11].DataPropertyName = "OpponentsOpponentWinPercentage"; TeamsGridView.DataSource = Teams; TeamsGridView.Sort(TeamsGridView.Columns["Name"], ListSortDirection.Ascending); }
private void btnSoS_Click(object sender, EventArgs e) { TeamsGridView.DataSource = null; TeamsGridView.Rows.Clear(); TeamsGridView.Refresh(); TeamsGridView.AutoGenerateColumns = false; TeamsGridView.DataSource = Teams; TeamsGridView.Columns.Clear(); TeamsGridView.Columns.Add("SoSRank", "SoSRank"); TeamsGridView.Columns.Add("Name", "Team"); TeamsGridView.Columns.Add("SoS", "SoS"); TeamsGridView.Columns[0].DataPropertyName = "StrengthOfScheduleRank"; TeamsGridView.Columns[1].DataPropertyName = "Name"; TeamsGridView.Columns[2].DataPropertyName = "StrengthOfSchedule"; TeamsGridView.Sort(TeamsGridView.Columns["SoS"], ListSortDirection.Descending); }
private void btnPyth_Click(object sender, EventArgs e) { TeamsGridView.DataSource = null; TeamsGridView.Rows.Clear(); TeamsGridView.Refresh(); TeamsGridView.AutoGenerateColumns = false; TeamsGridView.DataSource = Teams; TeamsGridView.Columns.Clear(); TeamsGridView.Columns.Add("PythRPIRank", "PythRPIRank"); TeamsGridView.Columns.Add("Name", "Team"); TeamsGridView.Columns.Add("RPIRank", "RPIRank"); TeamsGridView.Columns.Add("PythRPI", "PythRPI"); TeamsGridView.Columns.Add("PythWin", "PythWin"); TeamsGridView.Columns.Add("PythLosses", "PythLosses"); TeamsGridView.Columns.Add("PythWinPercentage", "PythWinPercentage"); TeamsGridView.Columns.Add("PythOWP", "PythOWP"); TeamsGridView.Columns.Add("PythOOWP", "PythOOWP"); TeamsGridView.Columns[0].DataPropertyName = "PythRPIRanking"; TeamsGridView.Columns[1].DataPropertyName = "Name"; TeamsGridView.Columns[2].DataPropertyName = "RPIRank"; TeamsGridView.Columns[3].DataPropertyName = "PythRPI"; TeamsGridView.Columns[4].DataPropertyName = "PythWins"; TeamsGridView.Columns[5].DataPropertyName = "PythLosses"; TeamsGridView.Columns[6].DataPropertyName = "PythWinPercentage"; TeamsGridView.Columns[7].DataPropertyName = "PythOpponentsWinPercentage"; TeamsGridView.Columns[8].DataPropertyName = "PythOpponentsOpponentWinPercentage"; TeamsGridView.Sort(TeamsGridView.Columns["RPIRank"], ListSortDirection.Descending); }
/** * <summary> * This function will get the teams from the database, as well as the applicable data (scores) from the database and bind the data to the gridview * </summary> * * @method GetTeams * @returns {void} */ protected void GetTeams() { //Opens the DB and gets all data from the teams table SqlCommand getTeams = new SqlCommand("SELECT * FROM TeamTable", db); db.Open(); reader = getTeams.ExecuteReader(); teamsData.Load(reader); db.Close(); teamsData.Columns.Add(new DataColumn("GameOneScores", typeof(string))); teamsData.Columns.Add(new DataColumn("GameTwoScores", typeof(string))); teamsData.Columns.Add(new DataColumn("GameThreeScores", typeof(string))); teamsData.Columns.Add(new DataColumn("GameFourScores", typeof(string))); //This set of loops will loop through each row in the data table holding the teams information, //checking for that team in each game that occured that week. It will then post N/A for games where //that team did not participate, or will post the number of points won & lost by that team //for all games they participated in that week. foreach (DataRow teamsRow in teamsData.Rows) { foreach (DataRow gameRow in gamesData.Rows) { if (teamsRow["TeamID"].ToString() != gameRow["TeamOneID"].ToString() && teamsRow["TeamID"].ToString() != gameRow["TeamTwoID"].ToString()) { if (gameRow["GameNum"].ToString() == "Game #1") { teamsRow["GameOneScores"] = "N/A"; } else if (gameRow["GameNum"].ToString() == "Game #2") { teamsRow["GameTwoScores"] = "N/A"; } else if (gameRow["GameNum"].ToString() == "Game #3") { teamsRow["GameThreeScores"] = "N/A"; } else { teamsRow["GameFourScores"] = "N/A"; } } else if (teamsRow["TeamID"].ToString() == gameRow["TeamOneID"].ToString()) { if (gameRow["GameNum"].ToString() == "Game #1") { teamsRow["GameOneScores"] = "Won " + gameRow["TeamOnePoints"] + " / Lost " + gameRow["TeamTwoPoints"]; } else if (gameRow["GameNum"].ToString() == "Game #2") { teamsRow["GameTwoScores"] = "Won " + gameRow["TeamOnePoints"] + " / Lost " + gameRow["TeamTwoPoints"]; } else if (gameRow["GameNum"].ToString() == "Game #3") { teamsRow["GameThreeScores"] = "Won " + gameRow["TeamOnePoints"] + " / Lost " + gameRow["TeamTwoPoints"]; } else { teamsRow["GameFourScores"] = "Won " + gameRow["TeamOnePoints"] + " / Lost " + gameRow["TeamTwoPoints"]; } } else { if (gameRow["GameNum"].ToString() == "Game #1") { teamsRow["GameOneScores"] = "Won " + gameRow["TeamTwoPoints"] + " / Lost " + gameRow["TeamOnePoints"]; } else if (gameRow["GameNum"].ToString() == "Game #2") { teamsRow["GameTwoScores"] = "Won " + gameRow["TeamTwoPoints"] + " / Lost " + gameRow["TeamOnePoints"]; } else if (gameRow["GameNum"].ToString() == "Game #3") { teamsRow["GameThreeScores"] = "Won " + gameRow["TeamTwoPoints"] + " / Lost " + gameRow["TeamOnePoints"]; } else { teamsRow["GameFourScores"] = "Won " + gameRow["TeamTwoPoints"] + " / Lost " + gameRow["TeamOnePoints"]; } } } } TeamsGridView.DataSource = teamsData.DefaultView; TeamsGridView.DataBind(); }