public async Task <long> Count(RequestWorkflowDefinitionMappingFilter filter) { IQueryable <RequestWorkflowDefinitionMappingDAO> query = DataContext.RequestWorkflowDefinitionMapping.AsNoTracking(); if (filter.RequestId != null) { query = query.Where(q => q.RequestId, filter.RequestId); } if (filter.WorkflowDefinitionId != null) { query = query.Where(q => q.WorkflowDefinitionId, filter.WorkflowDefinitionId); } return(await query.CountAsync()); }
private async Task <bool> WorkflowDefinitionInUsed(WorkflowDefinition WorkflowDefinition) { RequestWorkflowDefinitionMappingFilter RequestWorkflowDefinitionMappingFilter = new RequestWorkflowDefinitionMappingFilter { Skip = 0, Take = 1, WorkflowDefinitionId = new IdFilter { Equal = WorkflowDefinition.Id } }; var count = await UOW.RequestWorkflowDefinitionMappingRepository.Count(RequestWorkflowDefinitionMappingFilter); if (count != 0) { WorkflowDefinition.AddError(nameof(WorkflowDefinitionValidator), nameof(WorkflowDefinition.Id), ErrorCode.WorkflowDefinitionInUsed); } return(WorkflowDefinition.IsValidated); }
public async Task <List <RequestWorkflowDefinitionMapping> > List(RequestWorkflowDefinitionMappingFilter filter) { IQueryable <RequestWorkflowDefinitionMappingDAO> query = DataContext.RequestWorkflowDefinitionMapping.AsNoTracking(); if (filter.RequestId != null) { query = query.Where(q => q.RequestId, filter.RequestId); } if (filter.WorkflowDefinitionId != null) { query = query.Where(q => q.WorkflowDefinitionId, filter.WorkflowDefinitionId); } query = query.OrderBy(q => q.RequestId).Skip(0).Take(int.MaxValue); var result = await query.Select(q => new RequestWorkflowDefinitionMapping { RequestId = q.RequestId, RequestStateId = q.RequestStateId, WorkflowDefinitionId = q.WorkflowDefinitionId, }).ToListAsync(); return(result); }