/**
* <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();
}
