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);
}
