/* ----------------- 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();
}
private void Delete_Game()
{
// disable foregnkey contraints
string setQry = FOREIGN_KEY_DISABLE_QRY;
build.Execute_Query(setQry);
// delete game from database
string delQry = string.Format(DELETE_GAME_QRY, myGame.GetId());
build.Execute_Query(delQry);
Load_Game_Table_Data();
Set_Team_Stats();
Set_Player_Attributes_Stats();
Set_Labels();
Load_Player_Table_Data();
myGame.Clear();
}
/// <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));
}