// AddNewOrder - Create a new order and add it to Orders. public void AddNewOrder() { // Create the order. var db = new PickUpOrderDBEntities2(); var newOrder = new Order(); db.Orders.Add(newOrder); db.SaveChanges(); // If the order string is null, use this ID to start. if (Orders == null) { Orders = newOrder.OrderID.ToString(); } else { Orders += "," + newOrder.OrderID; } }
// ContentsToItemList - Return a list of the items referenced by // the orderContents string. public List <MenuItem> ContentsToItemList() { if (OrderContents == null) { return(null); } // Establish a database connection. var db = new PickUpOrderDBEntities2(); // Create the list to be returned. var itemObjects = new List <MenuItem>(); // Split the ID string. For each ID value, // get the corresponding item and add it to itemObjects. string[] itemIDs = OrderContents.Split(','); foreach (string item in itemIDs) { int id = int.Parse(item); itemObjects.Add(db.MenuItems.Find(id)); } return(itemObjects); }
// OrdersToList - Return a list of the orders referenced by // the order string. public List <Order> OrdersToList() { if (Orders == null) { return(null); } // Establish a database connection. var db = new PickUpOrderDBEntities2(); // Create the list to be returned. var orderObjects = new List <Order>(); // Split the ID string. For each ID value, // get the corresponding order and add it to orderObjects. string[] orderIDs = Orders.Split(','); foreach (string order in orderIDs) { int id = int.Parse(order); orderObjects.Add(db.Orders.Find(id)); } return(orderObjects); }
// GetCategoryDropdown - Build a dropdown list of all categories. public static List <SelectListItem> GetCategoryDropdown() { var db = new PickUpOrderDBEntities2(); var cats = new List <SelectListItem>(); // If there are no categories, add the four defaults. if (db.Categories.Count() == 0) { db.Categories.Add(new Category { CategoryName = "Main Dishes" }); db.Categories.Add(new Category { CategoryName = "Appetizers" }); db.Categories.Add(new Category { CategoryName = "Desserts" }); db.Categories.Add(new Category { CategoryName = "Drinks" }); db.SaveChanges(); } foreach (Category c in db.Categories) { cats.Add(new SelectListItem { Text = c.CategoryName, Value = c.CategoryID.ToString() }); } return(cats); }