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<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 <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); }; }
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 <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); } }
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 <IEnumerable <TValue> > GetAll() { using (SimpleTraderDbContext context = _contextFactory.CreateDbContext()) { IEnumerable <TValue> allEntitiesList = await context.Set <TValue>().ToListAsync(); return(allEntitiesList); }; }
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> 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 <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 <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); } }