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