//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();
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.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.Description, menuItemRow.Price);
}
;
}
;
return(allMenus);
}
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;
}