public async Task <(Dictionary <string, List <Checkout> > checkouts, List <Territory> territories)> Backup() { var checkout = await Checkouts.ToListAsync(); var territories = await Territorys.ToListAsync(); return(checkout.OrderBy(c => c.TerritoryId).GroupBy(c => c.TerritoryId).ToDictionary(c => c.Key, c => c.ToList()), territories); }
public async Task UpdateTerritory(Territory territory) { var existing = await Territorys.Where(t => t.TerritoryId == territory.TerritoryId).SingleAsync(); existing.Notes = territory.Notes; await SaveChangesAsync(); }
public async Task <List <Territory> > GetTerritories(string sectionId) { return(await Territorys.Include(t => t.Checkouts).Where(t => t.Section == sectionId).ToListAsync()); }
public async Task <List <string> > GetSections() { return(await Territorys.Select(t => t.Section).Distinct().ToListAsync()); }
public async Task <List <Territory> > GetTerritories() { return(await Territorys.Include(t => t.Checkouts).ToListAsync()); }