private void SetCustomStatus(Guid processId, ProcessStatus status, bool createIfnotDefined = false)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
var instanceStatus = WorkflowProcessInstanceStatus.SelectByKey(connection, processId);
if (instanceStatus == null)
{
if (!createIfnotDefined)
{
throw new StatusNotDefinedException();
}
instanceStatus = new WorkflowProcessInstanceStatus()
{
Id = processId,
Lock = Guid.NewGuid(),
Status = ProcessStatus.Initialized.Id
};
instanceStatus.Insert(connection);
}
else
{
instanceStatus.Status = ProcessStatus.Initialized.Id;
instanceStatus.Update(connection);
}
}
}
public void SetWorkflowRunning(ProcessInstance processInstance)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
var instanceStatus = WorkflowProcessInstanceStatus.SelectByKey(connection, processInstance.ProcessId);
if (instanceStatus == null)
{
throw new StatusNotDefinedException();
}
if (instanceStatus.Status == ProcessStatus.Running.Id)
{
throw new ImpossibleToSetStatusException();
}
var oldLock = instanceStatus.Lock;
instanceStatus.Lock = Guid.NewGuid();
instanceStatus.Status = ProcessStatus.Running.Id;
var cnt = WorkflowProcessInstanceStatus.ChangeStatus(connection, instanceStatus, oldLock);
if (cnt != 1)
{
throw new ImpossibleToSetStatusException();
}
}
}
public ProcessStatus GetInstanceStatus(Guid processId)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
var instance = WorkflowProcessInstanceStatus.SelectByKey(connection, processId);
if (instance == null)
return ProcessStatus.NotFound;
var status = ProcessStatus.All.SingleOrDefault(ins => ins.Id == instance.Status);
if (status == null)
return ProcessStatus.Unknown;
return status;
}
}
public void SetWorkflowRunning(ProcessInstance processInstance)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
var instanceStatus = WorkflowProcessInstanceStatus.SelectByKey(connection, processInstance.ProcessId);
if (instanceStatus == null)
throw new StatusNotDefinedException();
if (instanceStatus.Status == ProcessStatus.Running.Id)
throw new ImpossibleToSetStatusException();
instanceStatus.Lock = Guid.NewGuid();
instanceStatus.Status = ProcessStatus.Running.Id;
instanceStatus.Update(connection);
}
}
private void SetCustomStatus(Guid processId, ProcessStatus status, bool createIfnotDefined = false)
{
using (MySqlConnection connection = new MySqlConnection(ConnectionString))
{
var instanceStatus = WorkflowProcessInstanceStatus.SelectByKey(connection, processId);
if (instanceStatus == null)
{
if (!createIfnotDefined)
{
throw new StatusNotDefinedException();
}
instanceStatus = new WorkflowProcessInstanceStatus
{
Id = processId,
Lock = Guid.NewGuid(),
Status = ProcessStatus.Initialized.Id
};
instanceStatus.Insert(connection);
}
else
{
var oldLock = instanceStatus.Lock;
instanceStatus.Status = status.Id;
instanceStatus.Lock = Guid.NewGuid();
var cnt = WorkflowProcessInstanceStatus.ChangeStatus(connection, instanceStatus, oldLock);
if (cnt != 1)
{
throw new ImpossibleToSetStatusException();
}
}
}
}