public async Task<List<GetTasksItemViewModel>> ExecuteAsync(GetTasksViewModel request)
{
Int64 userId = this.authContext.CurrentUser.Id;
var query = dataContext
.Tasks
.Where(x => x.IsDeleted == false && x.Project.ProjectAdministrators.Any(a => a.UserId == userId && a.IsDeleted == false));
if (request.ProjectIdFilter != null)
{
query = query.Where(x => x.ProjectId == request.ProjectIdFilter.Value);
}
if (request.TaskStatusFilter != null)
{
query = query.Where(x => x.Status == request.TaskStatusFilter.Value);
}
if (request.UserIdFilter != null)
{
query = query.Where(x => x.UserId == request.UserIdFilter.Value);
}
return await query.ProjectTo<GetTasksItemViewModel>(this.mapper.ConfigurationProvider)
.OrderBy(x => x.Name)
.ToListAsync();
}
public async Task <List <GetTasksItemViewModel> > ExecuteAsync(GetTasksViewModel request)
{
var query = dataContext
.Tasks
.Where(x => x.IsDeleted == false);
if (request.ProjectIdFilter != null)
{
query = query.Where(x => x.ProjectId == request.ProjectIdFilter.Value);
}
if (request.TaskStatusFilter != null)
{
query = query.Where(x => x.Status == request.TaskStatusFilter.Value);
}
if (request.UserIdFilter != null)
{
query = query.Where(x => x.UserId == request.UserIdFilter.Value);
}
return(await query.ProjectTo <GetTasksItemViewModel>(this.mapper.ConfigurationProvider)
.OrderBy(x => x.Name)
.ToListAsync());
}
public async Task <IActionResult> Index([FromQuery] GetTasksViewModel model)
{
var command = this.unitOfWork.Create <GetTasksCommand>();
if (model == null)
{
model = new GetTasksViewModel();
}
model = await command.ExecuteAsync(model);
return(View(model));
}
