public static int UpdateRestorer(NpgsqlConnection connection, WorkflowRuntimeModel status, Guid oldLock)
{
var command = String.Format("UPDATE {0} SET \"RestorerId\" = @restorer, \"Lock\" = @newlock WHERE \"RuntimeId\" = @id AND \"Lock\" = @oldlock", ObjectName);
var p1 = new NpgsqlParameter("restorer", NpgsqlDbType.Varchar)
{
Value = status.RestorerId
};
var p2 = new NpgsqlParameter("newlock", NpgsqlDbType.Uuid)
{
Value = status.Lock
};
var p3 = new NpgsqlParameter("id", NpgsqlDbType.Varchar)
{
Value = status.RuntimeId
};
var p4 = new NpgsqlParameter("oldlock", NpgsqlDbType.Uuid)
{
Value = oldLock
};
return(ExecuteCommand(connection, command, p1, p2, p3, p4));
}
public static int UpdateRestorer(OracleConnection connection, WorkflowRuntimeModel runtime, Guid oldLock)
{
var command = String.Format("UPDATE {0} SET RESTORERID = :restorer, LOCKFLAG = :newlock WHERE RUNTIMEID = :id AND LOCKFLAG = :oldlock", ObjectName);
var p1 = new OracleParameter("restorer", OracleDbType.NVarchar2, runtime.RestorerId, ParameterDirection.Input);
var p2 = new OracleParameter("newlock", OracleDbType.Raw, runtime.Lock.ToByteArray(), ParameterDirection.Input);
var p3 = new OracleParameter("id", OracleDbType.NVarchar2, runtime.RuntimeId, ParameterDirection.Input);
var p4 = new OracleParameter("oldlock", OracleDbType.Raw, oldLock.ToByteArray(), ParameterDirection.Input);
return(ExecuteCommand(connection, command, p1, p2, p3, p4));
}
public static async Task <int> UpdateRestorerAsync(SqlConnection connection, WorkflowRuntimeModel status, Guid oldLock)
{
string command = $"UPDATE {ObjectName} SET [RestorerId] = @restorer, [Lock] = @newlock WHERE [RuntimeId] = @id AND [Lock] = @oldlock";
var p1 = new SqlParameter("restorer", SqlDbType.NVarChar)
{
Value = status.RestorerId
};
var p2 = new SqlParameter("newlock", SqlDbType.UniqueIdentifier)
{
Value = status.Lock
};
var p3 = new SqlParameter("id", SqlDbType.NVarChar)
{
Value = status.RuntimeId
};
var p4 = new SqlParameter("oldlock", SqlDbType.UniqueIdentifier)
{
Value = oldLock
};
return(await ExecuteCommandNonQueryAsync(connection, command, p1, p2, p3, p4).ConfigureAwait(false));
}
public static int UpdateRestorer(SqlConnection connection, WorkflowRuntimeModel status, Guid oldLock)
{
var command = String.Format("UPDATE {0} SET [RestorerId] = @restorer, [Lock] = @newlock WHERE [RuntimeId] = @id AND [Lock] = @oldlock", ObjectName);
var p1 = new SqlParameter("restorer", SqlDbType.NVarChar)
{
Value = status.RestorerId
};
var p2 = new SqlParameter("newlock", SqlDbType.UniqueIdentifier)
{
Value = status.Lock
};
var p3 = new SqlParameter("id", SqlDbType.NVarChar)
{
Value = status.RuntimeId
};
var p4 = new SqlParameter("oldlock", SqlDbType.UniqueIdentifier)
{
Value = oldLock
};
return(ExecuteCommand(connection, command, p1, p2, p3, p4));
}
public static async Task <int> UpdateStatusAsync(MySqlConnection connection, WorkflowRuntimeModel runtime, Guid oldLock)
{
string command = $"UPDATE {DbTableName} SET `Status` = @newstatus, `Lock` = @newlock WHERE `RuntimeId` = @id AND `Lock` = @oldlock";
var p1 = new MySqlParameter("newstatus", MySqlDbType.Byte)
{
Value = runtime.Status
};
var p2 = new MySqlParameter("newlock", MySqlDbType.Binary)
{
Value = runtime.Lock.ToByteArray()
};
var p3 = new MySqlParameter("id", MySqlDbType.VarString)
{
Value = runtime.RuntimeId
};
var p4 = new MySqlParameter("oldlock", MySqlDbType.Binary)
{
Value = oldLock.ToByteArray()
};
return(await ExecuteCommandNonQueryAsync(connection, command, p1, p2, p3, p4).ConfigureAwait(false));
}
public static int UpdateRestorer(MySqlConnection connection, WorkflowRuntimeModel runtime, Guid oldLock)
{
var command = String.Format("UPDATE {0} SET `RestorerId` = @restorer, `Lock` = @newlock WHERE `RuntimeId` = @id AND `Lock` = @oldlock", DbTableName);
var p1 = new MySqlParameter("restorer", MySqlDbType.VarString)
{
Value = runtime.RestorerId
};
var p2 = new MySqlParameter("newlock", MySqlDbType.Binary)
{
Value = runtime.Lock.ToByteArray()
};
var p3 = new MySqlParameter("id", MySqlDbType.VarString)
{
Value = runtime.RuntimeId
};
var p4 = new MySqlParameter("oldlock", MySqlDbType.Binary)
{
Value = oldLock.ToByteArray()
};
return(ExecuteCommand(connection, command, p1, p2, p3, p4));
}
public static async Task <int> UpdateRestorerAsync(NpgsqlConnection connection, WorkflowRuntimeModel status, Guid oldLock)
{
string command = $"UPDATE {ObjectName} SET \"RestorerId\" = @restorer, \"Lock\" = @newlock WHERE \"RuntimeId\" = @id AND \"Lock\" = @oldlock";
var p1 = new NpgsqlParameter("restorer", NpgsqlDbType.Varchar)
{
Value = status.RestorerId
};
var p2 = new NpgsqlParameter("newlock", NpgsqlDbType.Uuid)
{
Value = status.Lock
};
var p3 = new NpgsqlParameter("id", NpgsqlDbType.Varchar)
{
Value = status.RuntimeId
};
var p4 = new NpgsqlParameter("oldlock", NpgsqlDbType.Uuid)
{
Value = oldLock
};
return(await ExecuteCommandAsync(connection, command, p1, p2, p3, p4).ConfigureAwait(false));
}
public static async Task <int> UpdateRestorerAsync(OracleConnection connection, WorkflowRuntimeModel runtime, Guid oldLock)
{
string command = $"UPDATE {ObjectName} SET RESTORERID = :restorer, LOCKFLAG = :newlock WHERE RUNTIMEID = :id AND LOCKFLAG = :oldlock";
var p1 = new OracleParameter("restorer", OracleDbType.NVarchar2, runtime.RestorerId, ParameterDirection.Input);
var p2 = new OracleParameter("newlock", OracleDbType.Raw, runtime.Lock.ToByteArray(), ParameterDirection.Input);
var p3 = new OracleParameter("id", OracleDbType.NVarchar2, runtime.RuntimeId, ParameterDirection.Input);
var p4 = new OracleParameter("oldlock", OracleDbType.Raw, oldLock.ToByteArray(), ParameterDirection.Input);
return(await ExecuteCommandNonQueryAsync(connection, command, p1, p2, p3, p4).ConfigureAwait(false));
}
