public List<Dish> SearchDishByKeyword(string pKeyword)
{
List<Dish> dishList = new List<Dish>();
DataContextDataContext dc = new DataContextDataContext();
ISingleResult<search_dish_by_keywordResult> rs = dc.search_dish_by_keyword(pKeyword);
foreach (search_dish_by_keywordResult r in rs)
{
List<Tag> tagList = new List<Tag>();
ISingleResult<get_tag_by_dishResult> rs2 = dc.get_tag_by_dish(r.name);
foreach (get_tag_by_dishResult r2 in rs2)
{
Tag tag = new Tag(r2.name, (int)r2.popularity);
tagList.Add(tag);
}
List<Comment> commentList = new List<Comment>();
ISingleResult<get_comment_by_dishResult> rs3 = dc.get_comment_by_dish(r.name);
foreach (get_comment_by_dishResult r3 in rs3)
{
Comment comment = new Comment(r3.id, r3.content, r3.about_dish, r3.user_from);
commentList.Add(comment);
}
Dish dish = new Dish(r.name,
r.description,
(double)r.price,
r.pict_path,
(int)r.popularity,
tagList,
commentList);
dishList.Add(dish);
}
return dishList;
}