public List<Ingredient> GetFoodIngredientList(string foodName)
{
FoodManager foodManager = new FoodManager();
Table<DAL.Food> foodTable = foodManager.GetFoodTable();
Table<DAL.IngredientsInFood> ingredientsInFoodTable = GetIngredientsInFoodTable();
Table<DAL.Ingredient> ingredientTable = GetIngredientsTable();
Table<DAL.IngredientDetail> ingredientDetailTable = GetIngredientDetailTable();
var res = (from food in foodTable
join ingreInFood in ingredientsInFoodTable on food.foodID equals ingreInFood.foodID
join ingre in ingredientTable on ingreInFood.ingredientID equals ingre.ingredientID
join ingreDetails in ingredientDetailTable on ingre.ingredientDetailsID equals ingreDetails.ingredientDetailsID
where food.name == foodName
select new Ingredient
{
Name = ingreDetails.name,
Description = ingreDetails.description,
Quantity = ingre.quantity
});
return res.ToList();
}
