private void SetCustomStatus(Guid processId, ProcessStatus status, bool createIfnotDefined = false) { using (OracleConnection connection = new OracleConnection(ConnectionString)) { var instanceStatus = WorkflowProcessInstanceStatus.SelectByKey(connection, processId); if (instanceStatus == null) { if (!createIfnotDefined) { throw new StatusNotDefinedException(); } instanceStatus = new WorkflowProcessInstanceStatus() { Id = processId, LOCKFLAG = Guid.NewGuid(), Status = ProcessStatus.Initialized.Id }; instanceStatus.Insert(connection); } else { instanceStatus.Status = ProcessStatus.Initialized.Id; instanceStatus.Update(connection); } WorkflowProcessInstanceStatus.Commit(connection); } }
public void SetWorkflowRunning(ProcessInstance processInstance) { using (SqlConnection connection = new SqlConnection(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 (OracleConnection connection = new OracleConnection(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 (NpgsqlConnection connection = new NpgsqlConnection(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 (SqlConnection connection = new SqlConnection(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(); } } } }