public static List <Menu> GetAllMenus()
{
//create instances
MenuTableAdapter taMenu = new MenuTableAdapter();
Menu_ItemTableAdapter taMenuItem = new Menu_ItemTableAdapter();
var dtMenu = taMenu.GetData();
// list returned by the method
List <Menu> allMenus = new List <Menu>();
// iterate through all the menu rows
foreach (dsDinerMax3000.MenuRow menuRow in dtMenu.Rows)
{
Menu currentMenu = new Menu();
//set the value from row
currentMenu.Name = menuRow.Name;
currentMenu._databaseId = menuRow.Id;
allMenus.Add(currentMenu);
var dtMenuItems = taMenuItem.GetMenuItemsByMenuId(menuRow.Id);
foreach (dsDinerMax3000.Menu_ItemRow menuItemRow in dtMenuItems.Rows)
{
currentMenu.AddMenuItems(menuItemRow.Name, menuItemRow.Description, menuItemRow.Price);
}
}
return(allMenus);
}
public void SaveNewMenuItem(string Name, string Description, double Price)
{
// new instance of item table adapater
Menu_ItemTableAdapter taMenuItem = new Menu_ItemTableAdapter();
taMenuItem.InsertNewMenuItem(Name, Description, Price, _databaseId);
}
