public async Task UpdateWorkflowsChangedWithRevisionsAsync(int workflowId, int revisionId, IDbTransaction transaction = null)
{
if (workflowId < 1)
{
throw new ArgumentOutOfRangeException(nameof(workflowId));
}
if (revisionId <= 1)
{
throw new ArgumentOutOfRangeException(nameof(revisionId));
}
var parameters = new DynamicParameters();
parameters.Add("@workflowId", workflowId);
parameters.Add("@revisionId", revisionId);
if (transaction == null)
{
await _connectionWrapper.ExecuteAsync
(
"UpdateWorkflowsChangedWithRevisions",
parameters,
commandType : CommandType.StoredProcedure);
}
else
{
await transaction.Connection.ExecuteAsync
(
"UpdateWorkflowsChangedWithRevisions",
parameters,
transaction,
commandType : CommandType.StoredProcedure);
}
}
public async Task <Guid> PostFileHead(File file)
{
var prm = new DynamicParameters();
prm.Add("@FileName", file.FileName);
prm.Add("@FileType", file.FileType);
prm.Add("@ExpiredTime", GetPostFileHeadExpirationTime(file.ExpiredTime));
prm.Add("@ChunkCount", file.ChunkCount);
prm.Add("@FileSize", file.FileSize);
prm.Add("@FileId", dbType: DbType.Guid, direction: ParameterDirection.Output);
await _connectionWrapper.ExecuteAsync("[FileStore].InsertFileHead", prm, commandTimeout : _commandTimeout, commandType : CommandType.StoredProcedure);
return(file.FileId = prm.Get <Guid>("FileId"));
}
private async Task <bool> LockArtifactInternalAsync(int artifactId, int userId, IDbTransaction transaction = null)
{
var parameters = new DynamicParameters();
parameters.Add("@userId", userId);
parameters.Add("@artifactId", artifactId);
try
{
if (transaction == null)
{
await _connectionWrapper.ExecuteAsync("LockArtifact", parameters, commandType : CommandType.StoredProcedure);
}
else
{
await transaction.Connection.ExecuteAsync("LockArtifact", parameters, transaction, commandType : CommandType.StoredProcedure);
}
}
catch (SqlException e)
{
if (e.Number == 50000) // Default error generated from SQL by RAISERROR ('Artifact already locked',16,1)
{
return(false);
}
throw;
}
return(true);
}
public async Task RemoveDeletedArtifactsFromCollectionAsync(
int collectionId, int userId, IDbTransaction transaction = null)
{
var parameters = new DynamicParameters();
parameters.Add("@UserId", userId);
parameters.Add("@CollectionId", collectionId);
if (transaction == null)
{
await _connectionWrapper.ExecuteAsync(
"RemoveDeletedArtifactsFromCollection", parameters, commandType : CommandType.StoredProcedure);
}
else
{
await transaction.Connection.ExecuteAsync(
"RemoveDeletedArtifactsFromCollection", parameters, transaction,
commandType : CommandType.StoredProcedure);
}
}