public void DeleteProcess(Guid processId) { using (OracleConnection connection = new OracleConnection(ConnectionString)) { WorkflowProcessInstance.Delete(connection, processId); WorkflowProcessInstanceStatus.Delete(connection, processId); WorkflowProcessInstancePersistence.DeleteByProcessId(connection, processId); WorkflowProcessTransitionHistory.DeleteByProcessId(connection, processId); WorkflowProcessTimer.DeleteByProcessId(connection, processId); WorkflowProcessInstance.Commit(connection); } }
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); } }
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 { var oldLock = instanceStatus.LOCKFLAG; instanceStatus.Status = status.Id; instanceStatus.LOCKFLAG = Guid.NewGuid(); var cnt = WorkflowProcessInstanceStatus.ChangeStatus(connection, instanceStatus, oldLock); if (cnt != 1) { throw new ImpossibleToSetStatusException(); } } WorkflowProcessInstanceStatus.Commit(connection); } }