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