public void AddOrderItemToExistingOrder(string nameOfItem)
{
var addOrderItem = new Order_MenuItemTableAdapter();
var menuItemTable = new MenuItemTableAdapter();
var menuItemDT = menuItemTable.GetData();
int menuItemID = 1;
foreach (dsDinerMax3000.MenuItemRow row in menuItemDT.Rows)
{
if (row.Name.ToLower() == nameOfItem.ToLower())
{
menuItemID = row.Id;
}
}
addOrderItem.InsertOrderItem(_databaseID, menuItemID);
}
public static List<Order> GetAllOrders()
{
OrderTableAdapter taOrder = new OrderTableAdapter();
Order_MenuItemTableAdapter taOrder_MenuItem = new Order_MenuItemTableAdapter();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
var dtOrder = taOrder.GetData();
List<Order> allOrders = new List<Order>();
foreach (dsDinerMax3000.OrderRow orderRow in dtOrder.Rows)
{
Order CurrentOrder = new Order();
CurrentOrder._OrderNumber = orderRow.OrderNumber;
CurrentOrder._databaseID = orderRow.ID;
allOrders.Add(CurrentOrder);
var dtOrderItems = taMenuItem.GetMenuItemsByOrderID(orderRow.ID);
foreach(dsDinerMax3000.MenuItemRow menuItemRow in dtOrderItems.Rows){
CurrentOrder.AddMenuItem (menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
}
return allOrders;
}
public void AddMenuItemToOrder(int OrderID, int MenuItemID)
{
Order_MenuItemTableAdapter taOrder_MenuItem = new Order_MenuItemTableAdapter();
taOrder_MenuItem.Insert(OrderID, MenuItemID);
}