public async Task <IEnumerable <Shop> > Get(CancellationToken cancellationToken) { using (var db = new BankAppContext()) { return(await db.Set <Shop>().ToListAsync()); } }
public async Task <Shop> GetById(int id, CancellationToken cancellationToken) { using (var db = new BankAppContext()) { return(await db.Set <Shop>() .FindAsync(new object[] { id }, cancellationToken)); } }
public async Task <IEnumerable <BankTransaction> > GetByFilter(int?categoryId, string tags) { using (var db = new BankAppContext()) { return(await db.Set <BankTransaction>() .Where(a => a.ShopTags.Contains(tags)).ToListAsync()); } }
public async Task <double> GetAverageAgeByFilter(int?categoryId, string tags) { using (var db = new BankAppContext()) { var x = await db.Set <BankTransaction>() .Where(a => a.ShopTags.Contains(tags)).AverageAsync(x => x.Amount); return(x); } }