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