public void CreateMenuItemDb(MenuItem item) { using (var db = new RestaurantSystemDataContext()) { db.MenuItems.Add(item); db.SaveChanges(); } }
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); } }