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