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