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