public void AddGoalieGameToMySQL(GoalieGame playerGame)
{
var helper = new GameHelper();
var hisGame = helper.GetGameFromMySQLByDate(playerGame.Game.Date);
var sqlToExecute = String.Format(
"insert into avDBGoalieRS (PlayerId, GameId, G, A, PIM, W, L, OT, T, SOUT, GA, SA, SV, SO, SOG, TOI)" +
"values ({0},{1}, {2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15})",
playerGame.Player.Id,
hisGame,
playerGame.Goals,
playerGame.Assists,
playerGame.PIM,
playerGame.Win,
playerGame.Loss,
playerGame.OT,
playerGame.Tie,
playerGame.ShootOut,
playerGame.GoalsAgainst,
playerGame.ShotAgaisnt,
playerGame.Saves,
playerGame.Shutout,
playerGame.SOG,
playerGame.TimeOnIce
);
Scripts.ExecuteMySQLNonQuery(sqlToExecute);
}
private void AddGoalieGame(GoalieGameHelper helper, GoalieGame playerGame)
{
helper.AddGoalieGameToMySQL(playerGame);
InfoLabel.Text += String.Format("Adding goalie game for {0} on {1}. {2}", playerGame.Player.Id, playerGame.Game.Date, "<br />");
}
