void MovingToPosition_Enter() { if (_currentBotWanderComponent.MovementTimeout > 0) { _movingToPosition_TimeOut = MovingToPosition_TimeOut(); if (!BotLocomotiveComponent.MoveToPosition(_currentBotWanderComponent.StopMovementCondition, false)) { FSM.ChangeState(FStatesWander.CannotWander); return; } DebugHelpers.LogInDebugMode(DebugMode, DEBUG_TAG, $"{transform.name} Wandering to {BotLocomotiveComponent.FocusedOnPosition.ToString()}"); StartCoroutine(_movingToPosition_TimeOut); } }
public void ExecuteCommands_Insert(List <SqliteCommand> lstInsertCommands) { var query_log = string.Empty; using (var dbConnection = new SqliteConnection(Connection)) { dbConnection.Open(); using (var transaction = dbConnection.BeginTransaction()) { try { for (int i = 0; i < lstInsertCommands.Count; i++) { using (lstInsertCommands[i]) { if (i == 0) { query_log = string.Format("[{0} x Rows] {1}", lstInsertCommands.Count, lstInsertCommands[i].CommandText); DebugHelpers.LogInDebugMode(DebugMode, DEBUG_TAG, query_log); } lstInsertCommands[i].Connection = dbConnection; lstInsertCommands[i].ExecuteNonQuery(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); LogSQLQueryErrorInDebugMode(query_log, ex); } } dbConnection.Close(); } }
public void ExecuteCommand_Delete(SqliteCommand deleteCommand) { var query = string.Empty; try { using (var dbConnection = new SqliteConnection(Connection)) { dbConnection.Open(); using (deleteCommand) { query = deleteCommand.CommandText; DebugHelpers.LogInDebugMode(DebugMode, DEBUG_TAG, query); deleteCommand.Connection = dbConnection; deleteCommand.ExecuteNonQuery();//ExecuteScalar(); } dbConnection.Close(); } } catch (Exception ex) { LogSQLQueryErrorInDebugMode(query, ex); } }
protected void LogInDebugMode(string message, bool includeTimestamp = false) { DebugHelpers.LogInDebugMode(DebugMode, GetDebugTag(), message, includeTimestamp); }