public List <Models.MenuItem> GetMenuItemsDb()
{
using (var db = new RestaurantSystemDataContext())
{
return(db.MenuItems.ToList());
}
}
public List <Order> GetOrdersDb()
{
using (var db = new RestaurantSystemDataContext())
{
var orders = db.Orders.Include(o => o.User).Include(o => o.OrderItems).Include(o => o.OrderItems.Select(i => i.MenuItem)).ToList();
return(orders);
}
}
public User GetUserOrdersDb(String email)
{
using (var db = new RestaurantSystemDataContext())
{
var user = db.Users.Where(u => u.Email == email).Include(u => u.Orders.Select(o => o.OrderItems.Select(i => i.MenuItem))).FirstOrDefault();
return(user);
}
}
public void CreateMenuItemDb(MenuItem item)
{
using (var db = new RestaurantSystemDataContext())
{
db.MenuItems.Add(item);
db.SaveChanges();
}
}
public bool LoginDb(String email, String password)
{
using (var db = new RestaurantSystemDataContext())
{
// Search the database for a registered user with the corresponding email and password
var encryptedPassword = EncryptionHelper.sha256(password);
var user = db.Users.Where(u => u.Email == email && u.Password == encryptedPassword).FirstOrDefault();
return(user != null);
}
}
public bool UpdateOrderStatusDb(int orderId, int orderStatus)
{
using (var db = new RestaurantSystemDataContext())
{
var order = db.Orders.Where(o => o.ID == orderId).FirstOrDefault();
if (order == null)
{
return(false);
}
order.Status = orderStatus;
db.SaveChanges();
return(true);
}
}
public bool CreateOrderDb(String email, List <MenuItem> orderItems)
{
using (var db = new RestaurantSystemDataContext())
{
var user = db.Users.Where(u => u.Email == email).FirstOrDefault();
if (user == null)
{
return(false);
}
decimal totalPrice = 0;
foreach (MenuItem item in orderItems)
{
totalPrice += item.Price;
}
totalPrice *= (decimal)1.06;
Math.Round(totalPrice, 2);
Order newOrder = new Order()
{
Price = totalPrice,
Status = 0,
UserID = user.ID,
Submitted = DateTime.Now
};
db.Orders.Add(newOrder);
foreach (MenuItem item in orderItems)
{
OrderItem orderItem = new OrderItem()
{
MenuItemID = item.ID,
Order = newOrder
};
db.OrderItems.Add(orderItem);
}
db.SaveChanges();
return(true);
}
}
public bool RegisterDb(String email, String password)
{
using (var db = new RestaurantSystemDataContext())
{
// Check and make sure this email doesn't already exist
var user = db.Users.Where(u => u.Email == email).FirstOrDefault();
// If a user with the given username does not already exist, we can proceed with registration
if (user == null)
{
db.Users.Add(new User()
{
Email = email,
Password = EncryptionHelper.sha256(password),
IsEmployee = false
});
db.SaveChanges();
return(true);
}
return(false);
}
}
