public async Task <T> GetById(int id)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
return(await context.Set <T>().FirstOrDefaultAsync(e => e.Id == id));
}
}
public async Task <T> GetOne(int id)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
T entity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id);
return(entity);
}
public async Task <IEnumerable <T> > GetAll()
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
IEnumerable <T> entities = await context.Set <T>().ToListAsync();
return(entities);
}
public async Task <IEnumerable <T> > GetAll()
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
return(await context.Set <T>().ToListAsync());
}
}
public async Task <Account> GetByUsername(string username)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
return(await context.Set <Account>()
.Include(a => a.AccountHolder)
.Include(a => a.AssetTransactions)
.FirstOrDefaultAsync(a => a.AccountHolder.Username == username));
}
public async Task <Account> GetOne(int id)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
return(await context.Set <Account>()
.Include(a => a.AccountHolder)
.Include(a => a.AssetTransactions)
.FirstOrDefaultAsync(a => a.Id == id));
}
public async Task <IEnumerable <Account> > GetAll()
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
return(await context.Set <Account>()
.Include(a => a.AccountHolder)
.Include(a => a.AssetTransactions)
.ToListAsync());
}
public async Task <bool> Delete(int id)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
Account entity = await context.Set <Account>().FirstOrDefaultAsync((e) => e.Id == id);
context.Set <Account>().Remove(entity);
return(true);
}
public async Task <IEnumerable <Account> > GetAll()
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
IEnumerable <Account> entities = await context.Accounts.Include(a => a.AssetTransactions).ToListAsync();
return(entities);
}
}
public async Task <IEnumerable <TValue> > GetAll()
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
IEnumerable <TValue> allEntitiesList = await context.Set <TValue>().ToListAsync();
return(allEntitiesList);
};
}
public async Task <Account> Get(int id)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
Account entity = await context.Accounts.Include(a => a.AssetTransactions).FirstOrDefaultAsync(e => e.Id == id);
return(entity);
}
}
public async Task <Account> Update(int id, Account entity)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
entity.Id = id;
context.Set <Account>().Update(entity);
await context.SaveChangesAsync();
return(entity);
}
public async Task <Account> Create(Account entity)
{
using SimpleTraderDbContext context = _contextFactory.CreateDbContext();
EntityEntry <Account> createdResult = await context.Set <Account>().AddAsync(entity);
await context.SaveChangesAsync();
return(createdResult.Entity);
}
public async Task <T> GetById(int id)
{
using (SimpleTraderDbContext context = _context.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id);
return(entity);
}
}
public async Task <TValue> Get(int id)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
TValue entity = await context.Set <TValue>().FirstOrDefaultAsync((a) => a.Id == id);
return(entity);
};
}
public async Task <Account> GetByEmail(string email)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
return(await context.Accounts
.Include(a => a.AccountHolder)
.Include(a => a.AssetTransactions)
.FirstOrDefaultAsync(a => a.AccountHolder.Email == email));
}
}
public Task <Account> GetByUsername(string username)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
return(Task.FromResult(context.Accounts
.Include(a => a.AccountHolder)
.Include(a => a.AssetTransactions)
.FirstOrDefault(a => a.AccountHolder.Username == username)));
}
}
//public async Task<T> Create(T entity)
//{
// using (SimpleTraderDbContext context = _contexfactory.CreateDbContext())
// {
// EntityEntry<T> createdEntity = await context.Set<T>().AddAsync(entity);
// await context.SaveChangesAsync();
// return createdEntity.Entity;
// }
//}
public async Task <bool> Delete(int id)
{
using SimpleTraderDbContext context = _contexfactory.CreateDbContext();
T deleteEntity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id);
context.Set <T>().Remove(deleteEntity);
await context.SaveChangesAsync();
return(true);
}
public async Task <T> Create(T entity)
{
using (SimpleTraderDbContext context = _context.CreateDbContext())
{
EntityEntry <T> createdResult = await context.Set <T>().AddAsync(entity);
await context.SaveChangesAsync();
return(createdResult.Entity);
}
}
public async Task <T> Update(int id, T entity)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
entity.Id = id;
context.Set <T>().Update(entity);
await context.SaveChangesAsync();
return(entity);
}
}
public async Task <T> Create(T entity)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
var createdEntity = await context.Set <T>().AddAsync(entity);
await context.SaveChangesAsync();
return(createdEntity.Entity);
}
}
public async Task <bool> Delete(int id)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
TValue entity = await context.Set <TValue>().FirstOrDefaultAsync((a) => a.Id == id);
context.Set <TValue>().Remove(entity);
await context.SaveChangesAsync();
return(true);
};
}
protected override void OnStartup(StartupEventArgs e)
{
_host.Start();
SimpleTraderDbContextFactory contextFactory = _host.Services.GetRequiredService <SimpleTraderDbContextFactory>();
using (SimpleTraderDbContext context = contextFactory.CreateDbContext())
{
context.Database.Migrate();
}
Window window = _host.Services.GetRequiredService <MainWindow>();
window.Show();
base.OnStartup(e);
}
public async Task <bool> Delete(int id)
{
using (SimpleTraderDbContext context = _contextFactory.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync(e => e.Id == id);
if (entity == null)
{
return(false);
}
context.Set <T>().Remove(entity);
await context.SaveChangesAsync();
return(true);
}
}
