public Task <List <ProjectDto> > Handle(GetProjectsWithoutUserQuery request, CancellationToken cancellationToken)
{
try
{
var projectsOfUserId = _dbContext.ProjectUsers.Where(x => x.UserId == request.UserId).Select(x => x.ProjectId).ToList();
var projects = _dbContext.Projects
.Where(x => !projectsOfUserId.Contains(x.Id))
.OrderBy(x => x.Title)
.ProjectTo <ProjectDto>(_mapper.ConfigurationProvider)
.ToList();
return(Task.FromResult(projects));
}
catch (Exception ex)
{
throw new Exception("There was an error getting the projects without the user", ex);
}
}
public async Task <IActionResult> GetProjectsWithoutUser([FromQuery] GetProjectsWithoutUserQuery query)
{
var result = await Mediator.Send(query);
return(Ok(result));
}
