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