/// <summary> /// set mygame attributes to selected game /// </summary> private void Set_Game_Attributes() { // set team name and id if a team is selected if (GamesDG.SelectedItems.Count == 1) { DataRowView item = (DataRowView)GamesDG.SelectedItem; // parse game id from selected game int id = Int32.Parse(item["id"].ToString()); // get game attributes from qry by id string qry = string.Format(SELECT_GAME_QRY, id); myGame.Set_Attributes(build.Execute_DataSet_Query(qry)); } }
/// <summary> /// updates information in database /// </summary> private void Update_Game() { // get game info from window uesr input string oppTeam = OppNameTB.Text.ToString(); string gameType = GameTypeCB.Text.ToString(); string gameLoc = GameLocCB.Text.ToString(); string gameDate = string.Format(DATE_FMT, YearTB.Text.ToString(), MonthCB.Text.ToString(), DayCB.Text.ToString()); // insert new game into game datatable string insqry = string.Format(UPDATE_GAME_QRY, oppTeam, gameType, gameLoc, gameDate, myGame.GetId()); build.Execute_Query(insqry); // select inserted game from datatable myGame.init(); myGame.Set_Attributes(build.Execute_DataSet_Query(SELECT_GAME_QRY)); }