public Task <List <ObserverModel> > Handle(ActiveObserversQuery request, CancellationToken cancellationToken) { var results = _context.PollingStationInfos .Include(pi => pi.PollingStation) .Include(pi => pi.PollingStation.County) .Include(pi => pi.Observer) .Where(i => request.CountyCodes.Contains(i.PollingStation.County.Code)) .Where(i => i.PollingStation.Number >= request.FromPollingStationNumber) .Where(i => i.PollingStation.Number <= request.ToPollingStationNumber); if (request.IdNgo > 0) { results = results.Where(i => i.Observer.IdNgo == request.IdNgo); } var observers = results .Select(i => i.Observer) .AsEnumerable() .Select(_mapper.Map <ObserverModel>) .ToList(); return(Task.FromResult(observers)); }
public Task <List <UserModel> > Handle(ActiveObserversQuery request, CancellationToken cancellationToken) { //var results = _context.PollingStationInfos // .Include(pi => pi.PollingStation) // .Include(pi => pi.PollingStation.County) // .Include(pi => pi.User) // .Where(i => request.CountyCodes.Contains(i.PollingStation.County.Code)) // .Where(i => i.PollingStation.Number >= request.FromPollingStationNumber) // .Where(i => i.PollingStation.Number <= request.ToPollingStationNumber); //if (request.NgoId > 0) //{ // results = results.Where(i => i.User.NgoId == request.NgoId); //} //var observers = results // .Select(i => i.User) // .AsEnumerable() // .Select(_mapper.Map<ObserverModel>) // .ToList(); //return Task.FromResult(observers); return(null); }