public async Task <List <MeteringUnit> > GetMeteringUnits() { using (var context = new AccountManagementDbContext(Options)) { return(context.MeteringUnits.ToList()); } }
public async Task <MeteringUnit> GetMeteringUnit(long id) { using (var context = new AccountManagementDbContext(Options)) { return(context .MeteringUnits .Where(m => m.MeteringUnitId == id) .FirstOrDefault()); } }
public async Task <Account> GetAccount(long id) { using (var context = new AccountManagementDbContext(Options)) { return(await context .Accounts .Include(a => a.MeteringUnits) .FirstAsync(a => a.AccountId == id)); } }
public async Task <List <Account> > GetAccounts() { using (var context = new AccountManagementDbContext(Options)) { var accounts = await context.Accounts .Include(a => a.MeteringUnits) .ToListAsync <Account>(); return(accounts); } }
public bool CreateDB() { using (var context = new AccountManagementDbContext(Options)) { if (true && (context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists()) { return(false); } context.Database.EnsureDeleted(); return(context.Database.EnsureCreated()); } }
public AccountController(AccountManagementDbContext dbContext) { _dbContext = dbContext; }