public void Add(Bill bill) { Bill billToSave = new Bill { CreatedDateTime = bill.CreatedDateTime, PaidDateTime = bill.PaidDateTime, CurrentUserId = bill.CurrentUser.Id, DiscountRate = bill.DiscountRate, PreTotal = bill.PreTotal, }; foreach (Item item in bill.Items) { billToSave.Items.Add(dbContext.Items.SingleOrDefault(it => it.Id == item.Id)); } foreach (Table table in bill.Tables) { billToSave.Tables.Add(dbContext.Tables.SingleOrDefault(t => t.Id == table.Id)); } billToSave.Total = (int)(billToSave.PreTotal * (100 - billToSave.DiscountRate) / 100.0); dbContext.Bills.Add(billToSave); dbContext.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 = "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 Shift Add(Shift shift) { var shiftToSave = new Shift { Date = shift.Date, UserId = shift.User.Id, DidWorkShift1 = shift.DidWorkShift1, DidWorkShift2 = shift.DidWorkShift2, DidWorkShift3 = shift.DidWorkShift3, Note = shift.Note }; _dbContext.Shifts.Add(shiftToSave); var result = _dbContext.SaveChanges(); return(result > 0 ? shiftToSave : null); }
public bool Update(User user) { if (dbContext.Users.Any(u => u.UserName == user.UserName)) { return(false); } var old = dbContext.Users.SingleOrDefault(u => u.Id == user.Id); old.FullName = user.FullName; old.UserName = user.UserName; old.Description = user.Description; old.Level = user.Level; dbContext.SaveChanges(); return(true); }
public void Add(Item item) { _dbContext.Items.Add(item); _dbContext.SaveChanges(); //return item; }
public Unit Add(Unit unit) { _dbContext.Units.Add(unit); _dbContext.SaveChanges(); return(unit); }