//Static method for returning data
public static List<Menu> GetAllMenus()
{
// Set up table adapters
MenuTableAdapter taMenu = new MenuTableAdapter();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
// assign data table to results from table adapter
var dtMenu = taMenu.GetData();
List<Menu> allMenus = new List<Menu>();
// iterate through rows in the datatable and do stuff n things
foreach (dsDinerMax3000.MenuRow menuRow in dtMenu.Rows) {
Menu currentMenu = new Menu(); // new menu object instance
currentMenu.name = menuRow.Name; // get the assign it the name from the dataset
currentMenu._databaseId = menuRow.id;
allMenus.Add(currentMenu); // add it to the list of menus
// get all the menu items of each menu while in the Menu loop and add to a list
var dtMenuItems = taMenuItem.GetMenuItemsByMenuId(menuRow.id);
foreach (dsDinerMax3000.MenuItemRow menuItemRow in dtMenuItems.Rows) { // for every menu item in the data table dtMenuItems
currentMenu.AddMenuItem(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price); // add the menu items to the current menu object, from the dataset
}
}
return allMenus;
}
public static List <Menu> GetAllMenus()
{
MenuTableAdapter taMenu = new MenuTableAdapter();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
var dtMenu = taMenu.GetData();
List <Menu> result = new List <Menu>();
var databaseMenus = dtMenu.Rows;
foreach (DSDinerMax3000.MenuRow databaseMenu in databaseMenus)
{
Menu newMenuObject = new Menu();
newMenuObject.Name = databaseMenu.Name;
newMenuObject._databaseID = databaseMenu.Id;
result.Add(newMenuObject);
var dtMenuItems = taMenuItem.GetMenuItemsByMenuId(databaseMenu.Id);
foreach (DSDinerMax3000.MenuItemRow menuItemRow in dtMenuItems.Rows)
{
newMenuObject.AddMenuItem(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
}
return(result);
}
public static List <Menu> GetAllMenus()
{
MenuTableAdapter taMenu = new MenuTableAdapter();
var dtMenu = taMenu.GetData();
List <Menu> allMenus = new List <Menu>();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
foreach (dsDinerMax3000.MenuRow menuRow in dtMenu.Rows)
{
Menu currentMenu = new Menu();
currentMenu.Name = menuRow.Name;
currentMenu._databaseId = menuRow.Id;
allMenus.Add(currentMenu);
var dtMenuItems = taMenuItem.GetMenuItemsByMenuId(menuRow.Id);
foreach (dsDinerMax3000.MenuItemRow menuItemRow in dtMenuItems.Rows)
{
currentMenu.addMenuItem(menuItemRow.Name, menuItemRow.Descripion, menuItemRow.Price);
}
}
return(allMenus);
}
public static List <MenuItem> GetMenuItemsByMenuId(int menuId)
{
MenuItemTableAdapter menuItemTableAdapter = new MenuItemTableAdapter();
List <MenuItem> menuItems = new List <MenuItem>();
var dtMenuItem = menuItemTableAdapter.GetMenuItemsByMenuId(menuId);
menuItems.AddRange(from dsDinerMax3000.MenuItemRow menuItemRow in dtMenuItem
select new MenuItem
{
Title = menuItemRow.Name,
Description = menuItemRow.Description,
Price = menuItemRow.Price
});
return(menuItems);
}
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<Menu> GetAllMenus()
{
MenuTableAdapter taMenu = new MenuTableAdapter();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
var dtMenu = taMenu.GetData();
List<Menu> allMenus = new List<Menu>();
foreach (dsDinerMax3000.MenuRow menuRow in dtMenu.Rows)
{
Menu currentMenu = new Menu();
currentMenu._databaseId = menuRow.Id;
currentMenu.Name = menuRow.Name;
allMenus.Add(currentMenu);
var dtMenuItems = taMenuItem.GetMenuItemsByMenuId(menuRow.Id);
foreach(dsDinerMax3000.MenuItemRow menuItemRow in dtMenuItems.Rows)
{
currentMenu.AddMenuItem(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
}
return allMenus;
}
public static List <Order> GetAllOrders()
{
var menuItemTable = new MenuItemTableAdapter();
var orderTable = new OrderTableAdapter();
var orderDT = orderTable.GetData();
var allOrders = new List <Order>();
foreach (dsDinerMax3000.OrderRow row in orderDT.Rows)
{
var currentOrder = new Order();
currentOrder.serverName = row.ServerName;
currentOrder._databaseID = row.Id;
var menuItemDT = menuItemTable.GetOrderItemsByOrderID(row.Id);
foreach (dsDinerMax3000.MenuItemRow menuRow in menuItemDT.Rows)
{
currentOrder.addMenuItems(menuRow.Name, menuRow.Description, menuRow.Price);
}
allOrders.Add(currentOrder);
}
return(allOrders);
}
public static List<Menu> GetAllMenus()
{
MenuTableAdapter taMenu = new MenuTableAdapter();
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
var rsMenu = taMenu.GetData();
List<Menu> allMenus = new List<Menu>();
foreach (dsDinermax3000.MenuRow menuRow in rsMenu.Rows)
{
Menu currentMenu = new Menu();
currentMenu.name = menuRow.Name;
currentMenu._dbID = menuRow.ID;
var rsMenuItems = taMenuItem.GetMenuItemsByMenuId(menuRow.ID);
foreach (dsDinermax3000.MenuItemRow menuItemRow in rsMenuItems.Rows)
{
currentMenu.addToMenu(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
allMenus.Add(currentMenu);
}
return allMenus;
}
public static List <Menu> GetAllMenus()
{
var menuItemTable = new MenuItemTableAdapter();
var menuTable = new MenuTableAdapter();
var dtMenu = menuTable.GetData();
List <Menu> allMenus = new List <Menu>();
foreach (dsDinerMax3000.MenuRow row in dtMenu.Rows)
{
var currentMenu = new Menu();
currentMenu.Name = row.Name;
currentMenu._databaseId = row.Id;
//allMenus.Add(currentMenu);
var dtMenuItems = menuItemTable.GetMenuItemsByMenuID(row.Id);
foreach (dsDinerMax3000.MenuItemRow menuItemRow in dtMenuItems)
{
currentMenu.addMenuItems(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
allMenus.Add(currentMenu);
}
return(allMenus);
}
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 SaveNewMenuItem(string Name, string Description, double Price)
{
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
taMenuItem.InsertNewMenuItem(Name, Description, Price, _databaseId);
}
public void SaveNewMenuItem(string Name, string Description, double Price)
{
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
taMenuItem.InsertNewMenuItem(Name, Description, Price, _databaseId);
}
// a list of MenuItem objects but has not instantiated the list - this is done
// in the class constructor.
public void saveNewMenuItem(string Name, string Description, double Price)
{
MenuItemTableAdapter taMenuItem = new MenuItemTableAdapter();
taMenuItem.InsertMenuItem(Name, Description, Price, _dbID);
}
