/** * <summary> * This method sorts out the games played by week * </summary> * @method dotaSort * @returns {VOID} * */ protected void dotaSort(object sender, EventArgs e) { if (weekNumberSort.Text == null) { Response.Redirect("~/Dota.aspx"); } else { //store the input into a string string week = weekNumberSort.Text; string[] weekArray = null; char[] splitChar = { 'W' }; //split the input into 2 parts the year will be stored in weekArray[0] and the week number is stored in the second index of the array weekArray = week.Split(splitChar); string weekNum = weekArray[1]; // store just the week number into a string variable int weekSort = int.Parse(weekNum); // parse the number as an integer //connect to EF using (GameTrackerConnection db = new GameTrackerConnection()) { //query the csgo table var Dota = (from allData in db.Dotas where allData.weekOfGame == weekSort select allData); //bind results to the gridview DotaGridView.DataSource = Dota.ToList(); DotaGridView.DataBind(); } } }
/** * * <summary> * This method gets the dota data from the DB * </summary> * @method GetDotaData * @returns {void} * */ protected void GetDotaData() { //connect to EF using (GameTrackerConnection db = new GameTrackerConnection()) { //query the csgo table var Dota = (from allData in db.Dotas select allData); //bind results to the gridview DotaGridView.DataSource = Dota.ToList(); DotaGridView.DataBind(); } }