public async Task <IEnumerable <AskResponse> > GetAll()
{
await using var context = new CraigBotDbContext();
var responses = await context.AskResponses.ToListAsync();
return(responses);
}
public async Task <BankAccount> GetByUserId(ulong id)
{
await using var context = new CraigBotDbContext();
var bank = await context.BankAccounts.SingleOrDefaultAsync(x => x.UserId == id);
return(bank);
}
public async Task UpdateAll(IEnumerable <Stock> stocks)
{
await using var context = new CraigBotDbContext();
context.Stocks.UpdateRange(stocks);
await context.SaveChangesAsync();
}
public async Task <IEnumerable <Bet> > GetAll()
{
await using var context = new CraigBotDbContext();
var bets = await context.Bets.ToListAsync();
return(bets);
}
public async Task <Stock> GetById(int id)
{
await using var context = new CraigBotDbContext();
var stock = await context.Stocks.FindAsync(id);
return(stock);
}
public async Task DeleteRange(IEnumerable <Wager> wagers)
{
await using var context = new CraigBotDbContext();
context.Wagers.RemoveRange(wagers);
await context.SaveChangesAsync();
}
public async Task <IEnumerable <Stock> > GetAll()
{
await using var context = new CraigBotDbContext();
var stocks = await AsyncEnumerable.ToListAsync(context.Stocks);
return(stocks);
}
public async Task <Bet> GetBetById(int id)
{
await using var context = new CraigBotDbContext();
var bet = await context.Bets.FindAsync(id);
return(bet);
}
public async Task Delete(Investment investment)
{
await using var context = new CraigBotDbContext();
context.Investments.Remove(investment);
await context.SaveChangesAsync();
}
// TODO: Could probably cache these on first fetch
// https://docs.microsoft.com/en-us/aspnet/core/performance/caching/memory?view=aspnetcore-5.0
public async Task <IEnumerable <Fortune> > GetAll()
{
await using var context = new CraigBotDbContext();
var cookies = await context.Fortunes.ToListAsync();
return(cookies);
}
public async Task <Investment> GetByInvestmentId(int id)
{
await using var context = new CraigBotDbContext();
var investment = await context.Investments.FindAsync(id);
return(investment);
}
public async Task <Wager> Create(Wager wager)
{
await using var context = new CraigBotDbContext();
var newWager = (await context.Wagers.AddAsync(wager)).Entity;
await context.SaveChangesAsync();
return(newWager);
}
public async Task <Investment> Update(Investment investment)
{
await using var context = new CraigBotDbContext();
var updatedInvestment = context.Investments.Update(investment).Entity;
await context.SaveChangesAsync();
return(updatedInvestment);
}
public async Task <Investment> Create(Investment investment)
{
await using var context = new CraigBotDbContext();
var newInvestment = (await context.Investments.AddAsync(investment)).Entity;
await context.SaveChangesAsync();
return(newInvestment);
}
public async Task <Bet> Update(Bet bet)
{
await using var context = new CraigBotDbContext();
var updatedBet = context.Bets.Update(bet).Entity;
await context.SaveChangesAsync();
return(updatedBet);
}
public async Task <Bet> Create(Bet bet)
{
await using var context = new CraigBotDbContext();
var newBet = (await context.Bets.AddAsync(bet)).Entity;
await context.SaveChangesAsync();
return(newBet);
}
public async Task <Stock> GetByTicker(string ticker)
{
await using var context = new CraigBotDbContext();
var stock = await context.Stocks
.AsQueryable()
.FirstOrDefaultAsync(x => x.Ticker == ticker);
return(stock);
}
public async Task <BankAccount> Update(BankAccount account)
{
await using var context = new CraigBotDbContext();
var updatedAccount = context.BankAccounts.Update(account).Entity;
await context.SaveChangesAsync();
return(updatedAccount);
}
public async Task <BankAccount> Create(BankAccount account)
{
await using var context = new CraigBotDbContext();
var newBank = (await context.BankAccounts.AddAsync(account)).Entity;
await context.SaveChangesAsync();
return(newBank);
}
public async Task <IEnumerable <Wager> > GetAllByBetId(int id)
{
await using var context = new CraigBotDbContext();
var wagers = await context.Wagers
.AsQueryable()
.Where(x => x.BetId == id)
.ToListAsync();
return(wagers);
}
public async Task <IEnumerable <Investment> > GetAllByUserId(ulong id)
{
await using var context = new CraigBotDbContext();
var investments = await context.Investments
.AsQueryable()
.Where(x => x.UserId == id)
.ToListAsync();
return(investments);
}
public async Task <IEnumerable <Stock> > GetAllByIds(IEnumerable <int> ids)
{
await using var context = new CraigBotDbContext();
var stockIds = ids.ToList();
var stocks = context.Stocks
.AsQueryable()
.Where(x => stockIds.Contains(x.Id))
.ToList();
return(stocks);
}
