public static void Save(S_BowlingCenter bowlingCenter) { logger.Info("Start saving"); if (bowlingCenter != null) { try { if (BowlingCenterExistById(bowlingCenter.id)) { DatabaseConnection databaseconnection = new DatabaseConnection(); //open connection if (databaseconnection.OpenConnection()) { MySqlConnection sqlConnection = databaseconnection.getConnection(); // save the scores if (bowlingCenter.scores != null) { ScoresManager.Save(sqlConnection, bowlingCenter.id, bowlingCenter.scores); } else { logger.Warn("Er zijn geen scores"); } //close connection databaseconnection.CloseConnection(); } // update the last_syncdate set by the servicehandler Update(bowlingCenter); } } catch (Exception ex) { logger.Error("fout bij het opslaan van de scores: " + ex.Message); } } logger.Info("End saving"); }
public static void Save(MySqlConnection sqlConnection, long bowlingCenterId, S_Scores score) { long?scoreId = null; score.bowlingCenterId = bowlingCenterId; if (!ScoresManager.ScoresExistByBowlingCenterId(sqlConnection, bowlingCenterId, out scoreId)) { score.id = Insert(sqlConnection, score).Value; } else { score.id = ScoresManager.GetScoreById(sqlConnection, scoreId.Value).id; } foreach (S_Event bowlEvent in score.Events) { EventManager.Save(sqlConnection, score, bowlEvent); } }