public static void InitDatabase()
{
CoffeeDbContext context = new CoffeeDbContext();
// Init database with context
context.Users.Add(new User
{
UserName = "******",
Password = "******",
FullName = "Admin",
Level = Utilities.AppEnum.UserLevel.Admin
});
context.Users.Add(new User
{
UserName = "******",
Password = "******",
FullName = "Worker",
Level = Utilities.AppEnum.UserLevel.Worker
});
for (int i = 1; i <= 20; i++)
{
context.Tables.Add(new Table {
Name = "Bàn " + i, IsOccupied = false
});
}
context.SaveChanges();
}
public static void InitDatabase()
{
CoffeeDbContext context = new CoffeeDbContext();
// Init database with context
context.Users.Add(new User
{
UserName = "******",
Password = "******",
FullName = "Admin",
Level = Utilities.AppEnum.UserLevel.Admin
});
context.Users.Add(new User
{
UserName = "******",
Password = "******",
FullName = "Baristar",
Level = Utilities.AppEnum.UserLevel.Baristar
});
context.Users.Add(new User
{
UserName = "******",
Password = "******",
FullName = "Receptionist",
Level = Utilities.AppEnum.UserLevel.Worker
});
context.SaveChanges();
}
public List <Shift> GetShifts(DateTime date)
{
_dbContext = new CoffeeDbContext();
return(_dbContext.Shifts.ToList().Where(s => s.Date.Date.Equals(date.Date)).ToList());
}
public List <Shift> GetAll()
{
_dbContext = new CoffeeDbContext();
return(_dbContext.Shifts.ToList());
}
public List <Item> GetAll()
{
_dbContext = new CoffeeDbContext();
return(_dbContext.Items.ToList());
}
public UnitDao()
{
_dbContext = new CoffeeDbContext();
}
public List <Bill> GetAll()
{
dbContext = new CoffeeDbContext();
return(dbContext.Bills.Include(b => b.CurrentUser).ToList());
}
public List <Table> GetTables()
{
db = new CoffeeDbContext();
return(db.Tables.ToList());
}