private async Task <IEnumerable <ActivityPerRow> > GetWellRowsAsync() { // return await _context.Activities.Where(a => Brunnar.Contains(a.Address) && a.Time >= endDate.AddDays(-2) && a.Time <= endDate).ToListAsync(); return(await _context.ActivityPerRows.Where(a => Brunnar.Contains(a.Address)) .Where(a => a.TimeUp >= endDate.AddDays(-2) && a.TimeUp <= endDate) .ToListAsync()); }
private async Task <IEnumerable <PremisesPerWellViewModel> > GetPropertiesAsync() { return(await _context.Premises .Include(a => a.Well) //.Where(a => a.Well.WellName == WellName) .Where(a => Brunnar.Contains(a.Well.WellName)) .Select(a => new PremisesPerWellViewModel { WellName = a.Well.WellName, Property = a.Property, Address = a.Address }) .OrderBy(a => a.WellName) .ToListAsync()); }