protected void ButtonAddComment_Click(object sender, EventArgs e)
{
if (TextBoxComment.Visible == false)
{
if (Session["Customer"] != null)
{
TextBoxComment.Visible = true;
ButtonAddComment.Text = "Publish Comment";
}
else
{
Response.Write("<Script>alert('login first to add comment')</script>");
}
}
else
{
customer = (Customer)Session["Customer"];
string str = TextBoxComment.Text;
Comment comment = new Comment(Guid.NewGuid(), str, dish.name, customer.name);
customer.PublishComment(comment);
Response.Redirect(System.Configuration.ConfigurationManager.AppSettings["DishDetail"] + "?DishName=" + dish.name );
//TextBoxComment.Visible = false;
//ButtonAddComment.Text = "Add comment";
}
}
//List<Reservation> timeoutReservationList = new List<Reservation>();
//List<Delivery> timeoutDelivery = new List<Delivery>();
//Function: initiate the all the dishes, by query the configure information in db
//从数据库吧dish信息读出来，dish是Admin通过adddish加的
public static void InitAllDish()
{
dishList = new List<Dish>();
DataContextDataContext dc = new DataContextDataContext();
ISingleResult<select_all_dishResult> rs = dc.select_all_dish();
foreach (select_all_dishResult r in rs)
{
List<Tag> tagList = new List<Tag>();
List<Comment> commentList = new List<Comment>();
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);
}
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);
}
}
public void PublishComment(Comment pC)
{
DataContextDataContext dc = new DataContextDataContext();
dc.insert_comment(pC.id,pC.content,pC.aboutDish,pC.userFrom);
}
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;
}
public Dish GetDishByName(string pDishName)
{
Dish dish = null;
DataContextDataContext dc = new DataContextDataContext();
ISingleResult<get_dish_by_nameResult> rs = dc.get_dish_by_name(pDishName);
foreach (get_dish_by_nameResult r in rs)
{
List<Tag> tagList = new List<Tag>();
List<Comment> commentList = new List<Comment>();
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);
}
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 = new Dish(
r.name,
r.description,
(double)r.price,
r.pict_path,
(int)r.popularity,
tagList,
commentList);
}
return dish;
}