protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PlayersGridView.Sort("ranking", System.Web.UI.WebControls.SortDirection.Ascending);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Application["MatchNumber"] == null)
{
Application["MatchNumber"] = 1;
}
if (!IsPostBack)
{
string oracleConnectionString = ConfigurationManager.ConnectionStrings["OracleConnection"].ConnectionString;
OracleConnection con = new OracleConnection(oracleConnectionString);
try
{
string query = QueryBuilderClass.NextMatchQueryBuilder((int)Application["MatchNumber"]);
OracleCommand cmd = new OracleCommand(query, con);
con.Open();
OracleDataReader rdr = cmd.ExecuteReader();
NextMatchGridView.DataSource = rdr;
NextMatchGridView.DataBind();
}
catch (OracleException ex)
{
Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex);
}
finally
{
con.Close();
}
homeTeamString = NextMatchGridView.Rows[0].Cells[0].Text;
awayTeamString = NextMatchGridView.Rows[0].Cells[2].Text;
Session["HomeTeam"] = homeTeamString;
Session["AwayTeam"] = awayTeamString;
try
{
string query = QueryBuilderClass.NextMatchPlayerSelectionQueryBuilder(homeTeamString, awayTeamString);
OracleCommand cmd = new OracleCommand(query, con);
con.Open();
OracleDataReader rdr = cmd.ExecuteReader();
PlayersGridView.DataSource = rdr;
PlayersGridView.DataBind();
}
catch (OracleException ex)
{
Response.Write("<br>/" + "<br>/" + "<br>/" + "<br>/" + "<br>/" + ex);
}
finally
{
con.Close();
}
}
}
/**
* <summary>
* This method gets the student data from the DB
* </summary>
*
* @method GetPlayers
* @returns {void}
*/
protected void GetPlayers()
{
// connect to EF
using (GameTrackerConn db = new GameTrackerConn())
{
string SortString = Session["SortColumn"].ToString() + " " + Session["SortDirection"].ToString();
// query the Gridview_template_item_view1 Table using EF and LINQ
var PlayersList = (from allPlayers in db.Players
select allPlayers);
// bind the result to the GridView
PlayersGridView.DataSource = PlayersList.AsQueryable().OrderBy(SortString).ToList();
PlayersGridView.DataBind();
}
}
