public List<MenuItem> getAllMenuItemsFromMenu(string menuName)
        {
            List<MenuItem> returnList = new List<MenuItem>();
            CrystalMenuDataContext db = new CrystalMenuDataContext();
            var mainMenu = from p in db.Menus
                           where p.Name==menuName
                           select p;
            if (mainMenu.Count() == 0) return new List<MenuItem>();
            int ID = mainMenu.First().ID;
            var menuItems = from p in db.MenuItems
                            where p.MenuID == ID
                            select p;

            foreach (var item in menuItems)
            {
                MenuItem it = new CRySTAL.MenuItem();
                it.price = (decimal)item.Price;
                it.servedDuring = (MenuItem.MealTimes)item.ServedDuring;
                it.subcategory1 = item.Subcategory1;
                it.category1 = item.Category1;
                it.description = item.Description;
                it.name = item.Name;
                returnList.Add(it);
            }
            return returnList;
        }
 public List<string> getMenuCategoriesFromMenu(string menuName)
 {
     List<MenuItem> returnList = new List<MenuItem>();
     CrystalMenuDataContext db = new CrystalMenuDataContext();
     var mainMenu = from p in db.Menus
                    where p.Name==menuName
                    select p;
     if (mainMenu.Count() == 0) return new List<string>();
     int ID = mainMenu.First().ID;
     var catagories = (from p in db.MenuItems
                       where p.MenuID == ID
                       select p.Category1).Distinct();
     return catagories.ToList();
 }
 public List<string> getMenuNames()
 {
     CrystalMenuDataContext db = new CrystalMenuDataContext();
     var menuNames = from p in db.Menus
                    select p.Name;
     return menuNames.ToList();
 }
 public List<string> getMenuSubcategories(string Category)
 {
     List<MenuItem> returnList = new List<MenuItem>();
     CrystalMenuDataContext db = new CrystalMenuDataContext();
     var mainMenu = from p in db.Menus
                    where p.IsDefault == true
                    select p;
     if (mainMenu.Count() == 0) return new List<string>();
     int ID = mainMenu.First().ID;
     var catagories = (from p in db.MenuItems
                       where p.MenuID == ID &&
                       p.Category1 == Category
                       select p.Subcategory1).Distinct();
     return catagories.ToList();
 }