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