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 />"); }