/* ---------------- FUNCTIONAL METHODS ---------------------*/ /// <summary> /// Load most recent data into the player datagrid /// </summary> private void Load_Table_Data() { // select all players string qry = string.Format(SELECT_PLAYERS_QRY, myTeam.GetId()); PlayersDT.ItemsSource = build.Execute_DataTable_Qry(qry).DefaultView; }
/* ---------------- HELPER METHODS ---------------- */ private void Load_Totalstat_Table() { // get all stats from totalstats table string qry = string.Format(SELECT_TOTALSTATS_QRY, myPlayer.GetId()); TotalStatsDG.ItemsSource = build.Execute_DataTable_Qry(qry).DefaultView; }
/// <summary> /// searches for team by name in database /// </summary> private void Search_Team() { // get student id from search box string teamName = TeamSearchTB.Text.ToString(); // build and execute select query according to id string qry = string.Format(SEARCH_TEAM_QRY, teamName); TeamsDT.ItemsSource = build.Execute_DataTable_Qry(qry).DefaultView; }
/* ----------------- HELPER METHODS ------------------- */ /// <summary> /// adds user specified stat to game and to all team and player stat totals /// </summary> private void Add_Stat() { // set deafult qtr values int qtr = 1; // if qtr = OT replace with 5 if (QtrCB.Text.ToString() == "OT") { qtr = 5; } else { qtr = Int32.Parse(QtrCB.Text.ToString()); } // deafult player id int playerId; // parse player number from combobox int playerNum; // if player is opponent, dont parse player value if (PlayerCB.Text.ToString() == "Opponent") { statType = 'O'; playerNum = Int32.Parse(PlayerCB.Items[0].ToString()); } // if home team stat, parse player id from player number else { statType = Set_Stat_Type(); playerNum = Int32.Parse(PlayerCB.Text.ToString()); } // get player id from player number string selqry = string.Format(SELECT_PLAYER_ID_QRY, playerNum, myTeam.GetId()); DataTable dt = build.Execute_DataTable_Qry(selqry); playerId = Int32.Parse(dt.Rows[0]["id"].ToString()); // insert new game stat into game history and watch the magic happen string insqry = string.Format(INSERT_STAT_QRY, qtr, this.statType, playerId, myGame.GetId(), myTeam.GetId()); build.Execute_Query(insqry); // update all tables Set_Game_Stats(); Update_Tables(); AddStatPNL.Visibility = Visibility.Hidden; this.UpdateLayout(); }
/// <summary> /// loads all stats per game for top data table /// </summary> private void Load_Gamestat_Table() { // load team game stats data string qry = string.Format(SELECT_TEAM_GAMESTATS_QRY, myTeam.GetId()); DataTable dt = build.Execute_DataTable_Qry(qry); // add columns not in datatable dt.Columns.Add("win_pct"); dt.Columns.Add("league_win_pct"); dt.Columns.Add("shot_pct"); dt.Rows[0]["win_pct"] = myTeam.GetWinPct(); dt.Rows[0]["league_win_pct"] = myTeam.GetLeagueWinPct(); dt.Rows[0]["shot_pct"] = myTeam.GetShotPct(); GameStatsDG.ItemsSource = dt.DefaultView; }
/// <summary> /// updates player data table /// </summary> private void Load_Player_Table_Data() { // select all players in current team string qry = string.Format(SELECT_PLAYER_ATT_STATS_QRY, myTeam.GetId()); DataTable dt = build.Execute_DataTable_Qry(qry); // caculate team highs Calculate_Highs(); // populate datagrid with players datatable PlayersDG.ItemsSource = dt.DefaultView; }