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()
{
//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);
}
//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();
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);
}
//Method to access the DB
private void Get_Data()
{
ds = new DataSet1();
mta = new MenuTableAdapter();
eta = new EmployeesTableAdapter();
mta.Fill(ds.Menu);
eta.Fill(ds.Employees);
}
public static List <Menu> GetAllMenus()
{
MenuTableAdapter menuTableAdapter = new MenuTableAdapter();
var dtMenu = menuTableAdapter.GetData();
return((from dsDinerMax3000.MenuRow menuRow in dtMenu.Rows
select new Menu
{
_databaseId = menuRow.Id,
Name = menuRow.Name,
MenuType = menuRow.MenuType,
Items = GetMenuItemsByMenuId(menuRow.Id)
}).ToList());
}
public void SaveNewMenu()
{
MenuTableAdapter menuTableAdapter = new MenuTableAdapter();
if (this is FoodMenu)
{
FoodMenu foodMenu = (FoodMenu)this;
menuTableAdapter.InsertMenu(foodMenu.Name, foodMenu.MenuType, "", foodMenu.HospitalDirections);
}
else
{
DrinkMenu drinkMenu = (DrinkMenu)this;
menuTableAdapter.InsertMenu(drinkMenu.Name, drinkMenu.MenuType, drinkMenu.Disclaimer, "");
}
}
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;
}
/*
* Function get_data()
* Fills database tables using DataSet.
*/
private void get_data()
{
ds = new DataSet1();
mt = new MenuTableAdapter();
it = new InventoryTableAdapter();
et = new EmployeesTableAdapter();
ot = new OrdersTableAdapter();
olt = new OrderlineTableAdapter();
st = new SuppliersTableAdapter();
pot = new PurchaseOrdersTableAdapter();
polt = new PurchaseOrderlineTableAdapter();
mt.Fill(ds.Menu);
it.Fill(ds.Inventory);
et.Fill(ds.Employees);
ot.Fill(ds.Orders);
olt.Fill(ds.Orderline);
st.Fill(ds.Suppliers);
pot.Fill(ds.PurchaseOrders);
polt.Fill(ds.PurchaseOrderline);
}
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);
}
