protected void Page_Load(object sender, EventArgs e)
{
if ((!IsPostBack) && (Request.QueryString.Count > 0))
{
this.GetGame();
}
else
{
using (GameTrackerConn db = new GameTrackerConn()) {
DataTable playerTable = new DataTable();
playerTable.Columns.Add(new DataColumn("Name"));
playerTable.Columns.Add(new DataColumn("PlayerID"));
foreach (Player p in db.Players)
{
playerTable.Rows.Add(p.Name, p.PlayerID.ToString());
}
APlayerDropDownList.DataSource = playerTable;
APlayerDropDownList.DataTextField = playerTable.Columns["Name"].ToString();
APlayerDropDownList.DataValueField = playerTable.Columns["PlayerID"].ToString();
APlayerDropDownList.DataBind();
BPlayerDropDownList.DataSource = playerTable;
BPlayerDropDownList.DataTextField = playerTable.Columns["Name"].ToString();
BPlayerDropDownList.DataValueField = playerTable.Columns["PlayerID"].ToString();
BPlayerDropDownList.DataBind();
}
}
}
protected void GetGame()
{
//populate form with existing Game record
int GameID = Convert.ToInt32(Request.QueryString["GameID"]);
//connect to database with ef
using (GameTrackerConn db = new GameTrackerConn()) {
//populate Game instance with Game id with url param
Game updatedGame = (from game in db.Games
where game.GameID == GameID
select game).FirstOrDefault();
if (updatedGame != null)
{
NameTextBox.Text = updatedGame.Name.ToString();
DescriptionTextBox.Text = updatedGame.Description.ToString();
SpectatorsTextBox.Text = updatedGame.Spectators.ToString();
DatePlayedTextBox.Text = updatedGame.DatePlayed.ToString("yyyy-MM-dd");
var playerA = (from G in db.Games
join S in db.Scores on G.GameID equals S.Game_ID
join P in db.Players on S.Player_ID equals P.PlayerID
where S.Game_ID == GameID
orderby P.PlayerID ascending
select new { P.PlayerID, P.Name, S.Win }).First();
var playerB = (from G in db.Games
join S in db.Scores on G.GameID equals S.Game_ID
join P in db.Players on S.Player_ID equals P.PlayerID
where S.Game_ID == GameID
orderby P.PlayerID descending
select new { P.PlayerID, P.Name, S.Win }).First();
DataTable playerATable = new DataTable();
playerATable.Columns.Add(new DataColumn("Name"));
playerATable.Columns.Add(new DataColumn("PlayerID"));
playerATable.Rows.Add(playerA.Name, playerA.PlayerID.ToString());
APlayerDropDownList.DataSource = playerATable;
APlayerDropDownList.DataTextField = playerATable.Columns["Name"].ToString();
APlayerDropDownList.DataValueField = playerATable.Columns["PlayerID"].ToString();
APlayerDropDownList.DataBind();
AWinsTextBox.Text = playerA.Win.ToString();
DataTable playerBTable = new DataTable();
playerBTable.Columns.Add(new DataColumn("Name"));
playerBTable.Columns.Add(new DataColumn("PlayerID"));
playerBTable.Rows.Add(playerB.Name, playerB.PlayerID.ToString());
BPlayerDropDownList.DataSource = playerBTable;
BPlayerDropDownList.DataTextField = playerBTable.Columns["Name"].ToString();
BPlayerDropDownList.DataValueField = playerBTable.Columns["PlayerID"].ToString();
BPlayerDropDownList.DataBind();
BWinsTextBox.Text = playerB.Win.ToString();
}
}
}
