public static string SearchDish(int id) //поиск названия блюда по id { SmartRestaurantEntities dbs = new SmartRestaurantEntities(); var dish = dbs.list_of_dishes.FirstOrDefault(w => w.id_dish == id).name_dish; return(dish); }
public static List <dynamic> SelectListDishAva() //вывод списка доступных блюд { SmartRestaurantEntities dbs = new SmartRestaurantEntities(); var avaList = (from p in dbs.list_of_dishes join m in dbs.menu on p.id_selection equals m.id_selection where p.availability == true select new { p.id_dish, p.name_dish, m.id_selection, m.name_selection, p.price }).ToList <dynamic>(); return(avaList); }