public async Task <List <RecyclingOrder> > GetOrders(Guid recyclerId) { await using var context = new MasksUnleachedContext(); var recycler = await context.RecyclerUsers.FindAsync(recyclerId); return(recycler.RecyclingOrders.ToList()); }
public async Task <IList <User> > GetAll() { await using var context = new MasksUnleachedContext(); IList <User> users = await context.User.ToListAsync(); return(users); }
public async Task <IList <CollectorUser> > GetCollectors() { await using var context = new MasksUnleachedContext(); IList <CollectorUser> users = await context.CollectorUsers.ToListAsync(); return(users); }
public async Task <Guid> Insert(User user) { await using var context = new MasksUnleachedContext(); context.User.Add(user); await context.SaveChangesAsync(); return(user.Id); }
public async Task <List <DirtyMaskReception> > GetMaskReceptions(Guid collectorId) { using (var context = new MasksUnleachedContext()) { var receptions = await context.CollectorUsers .Where(user => user.Id.Equals(collectorId)) .FirstAsync(); return(receptions.DirtyMasksReceptions); } }
public async Task <int> GetCollectorMaskCapacity(Guid collectorId) { using (var context = new MasksUnleachedContext()) { var capacity = await context.CollectorUsers.Where(user => user.Id.Equals(collectorId)) .Select(collector => collector.MaskStorageCapacity) .FirstAsync(); return(capacity); } }
public async Task SetCollectorMaskCapacity(Guid collectorId, int newCapacity) { using (var context = new MasksUnleachedContext()) { var collector = await context.CollectorUsers.FindAsync(collectorId); collector.MaskStorageCapacity = newCapacity; context.Update(collector); await context.SaveChangesAsync(); } }
public async Task AddRecyclingOrder(Guid recyclerId, [NotNull] RecyclingOrder recyclingOrder) { await using var context = new MasksUnleachedContext(); var recycler = await context.RecyclerUsers.FindAsync(recyclerId); if (recycler.RecyclingOrders == null) { recycler.RecyclingOrders = new Collection <RecyclingOrder>(); } recycler.RecyclingOrders.Add(recyclingOrder); context.Update(recycler); await context.SaveChangesAsync(); }
public async Task AddMaskReception(Guid collectorId, DirtyMaskReception dirtyMaskReception) { using (var context = new MasksUnleachedContext()) { var collector = await context.CollectorUsers.FindAsync(collectorId); if (collector.DirtyMasksReceptions == null) { collector.DirtyMasksReceptions = new List <DirtyMaskReception>(1); } collector.DirtyMasksReceptions.Add(dirtyMaskReception); context.Update(collector); await context.SaveChangesAsync(); } }
public async Task <User> GetUserById(Guid userId) { await using var context = new MasksUnleachedContext(); return(await context.User.FindAsync(userId)); }