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