/// <summary> /// Delete Macro Assembly Action /// </summary> /// <param name="assemblyAction">The Macro Assembly Action</param> public void DeleteMacroAssemblyAction(IMacroAssemblyAction assemblyAction) { try { if (assemblyAction == null) { throw new ArgumentNullException("assemblyAction"); } string sql = $" DELETE FROM {SQLServerDataContract.MacroAssemblyActions.TABLE_NAME} " + $" WHERE " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_ID_NAME} = @id " + $" ); "; using (var connection = CreateConnection()) { connection.Open(); using (var command = CreateCommand(connection, CommandType.Text, sql)) { command.Parameters.Add(CreateParameter(DbType.Int64, "@id", assemblyAction.ID)); int recordsAffected = command.ExecuteNonQuery(); logger.Info($"Deleted Macro Assembly Action - {recordsAffected} records affected"); } } } catch (Exception caught) { logger.Error("Unexpected Error Deleting Macro Assembly Action", caught); throw; } }
/// <summary> /// Update Macro Assembly Action /// </summary> /// <param name="assemblyAction">The Macro Assembly Action</param> public void UpdateMacroAssemblyAction(IMacroAssemblyAction assemblyAction) { try { if (assemblyAction == null) { throw new ArgumentNullException("assemblyAction"); } string sql = $" UPDATE {SQLServerDataContract.MacroAssemblyActions.TABLE_NAME} SET " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_MACRO_ID_NAME} = @macroID, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_ACTION_TYPE_NAME} = @actionType, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_SCREEN_HEIGHT_NAME} = @screenHeight, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_SCREEN_WIDTH_NAME} = @screenWidth, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_POSITION_X_NAME} = @positionX, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_POSITION_Y_NAME} = @positionY, " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_ACTION_DELAY_NAME} = @actionDelay " + $" WHERE " + $" {SQLServerDataContract.MacroAssemblyActions.COLUMN_ID_NAME} = @id " + $" ); "; using (var connection = CreateConnection()) { connection.Open(); using (var command = CreateCommand(connection, CommandType.Text, sql)) { command.Parameters.Add(CreateParameter(DbType.Int64, "@id", assemblyAction.ID)); command.Parameters.Add(CreateParameter(DbType.Int64, "@macroID", assemblyAction.ID)); command.Parameters.Add(CreateParameter(DbType.Int32, "@actionType", assemblyAction.ActionType)); command.Parameters.Add(CreateParameter(DbType.Int32, "@screenHeight", assemblyAction.ScreenHeight)); command.Parameters.Add(CreateParameter(DbType.Int32, "@screenWidth", assemblyAction.ScreenWidth)); command.Parameters.Add(CreateParameter(DbType.Int32, "@positionX", assemblyAction.PositionX)); command.Parameters.Add(CreateParameter(DbType.Int32, "@positionY", assemblyAction.PositionY)); command.Parameters.Add(CreateParameter(DbType.Int32, "@actionDelay", assemblyAction.ActionDelay)); int recordsAffected = command.ExecuteNonQuery(); logger.Info($"Updated Macro Assembly Action - {recordsAffected} records affected"); } } } catch (Exception caught) { logger.Error("Unexpected Error Updating Macro Assembly Action", caught); throw; } }