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