public List<ArticleComment> AllCommentByArticleId(string articleId) { SqlConnection connection = new SqlConnection(dbConnectionString); string query = "SELECT * FROM tbl_comment WHERE article_id = '"+articleId+"' ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List<ArticleComment> commentList = new List<ArticleComment>(); while (reader.Read()) { ArticleComment comment = new ArticleComment(); comment.CommentArticleId = reader["id"].ToString(); comment.CommentUserName = reader["user_name"].ToString(); comment.CommentDescription = reader["comment_description"].ToString(); comment.Date = reader["date"].ToString(); commentList.Add(comment); } reader.Close(); connection.Close(); return commentList; }
public void CommentArticle(ArticleComment articleComment) { SqlConnection connection = new SqlConnection(dbConnectionString); string query = "INSERT INTO tbl_comment(user_name,article_id,comment_description,date) VALUES ('" + articleComment.CommentUserName + "','" + articleComment.CommentArticleId + "','" + articleComment.CommentDescription + "','" + DateTime.Now + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
protected void detailPost_ItemCommand(object source, RepeaterCommandEventArgs e) { string articleID = Request.QueryString["articleId"]; User aUser = (User)Session["user"]; ArticleComment articleComment = new ArticleComment(); articleComment.CommentUserName = aUser.UserName; articleComment.CommentDescription = Request.Form["commentDescription"]; articleComment.CommentArticleId = articleID; commentManager.CommentArticle(articleComment); }
protected void commentButton_Click(object sender, EventArgs e) { string articleID = Request.QueryString["articleId"]; User aUser = (User)Session["user"]; ArticleComment articleComment = new ArticleComment(); articleComment.CommentUserName = aUser.UserName; articleComment.CommentDescription = Request.Form["commentDescription"]; articleComment.CommentArticleId = articleID; commentManager.CommentArticle(articleComment); }
public void CommentArticle(ArticleComment articleComment) { commentGateway.CommentArticle(articleComment); }