public bool addComment(Comments newComment)
{
bool flag;
SqlConnection addCommentConnection = new SqlConnection("server=tf-PC\\SQLEXPRESS;database=blogData;uid=admin;pwd=s1y2x3");
addCommentConnection.Open();
string addString = "INSERT INTO Comments (commenterID,articleID,[content],commentTime) VALUES (@commenterID,@articleID,@content,@commentTime)";
SqlCommand addCommand = new SqlCommand(addString, addCommentConnection);
addCommand.Parameters.Add(new SqlParameter("commenterID", SqlDbType.Int));
addCommand.Parameters["commenterID"].Value = newComment.commenterID;
addCommand.Parameters.Add(new SqlParameter("articleID", SqlDbType.Int));
addCommand.Parameters["articleID"].Value = newComment.articleID;
addCommand.Parameters.Add(new SqlParameter("content", SqlDbType.NVarChar, 255));
addCommand.Parameters["content"].Value = newComment.content;
addCommand.Parameters.Add(new SqlParameter("commentTime", SqlDbType.DateTime));
addCommand.Parameters["commentTime"].Value = newComment.commentTime;
if (addCommand.ExecuteNonQuery() > 0)
{
flag = true;
}
else
{
flag = false;
}
addCommentConnection.Close();
return flag;
}
public IEnumerable<Comments> getAllCommentsByArticleID(int articleID)
{
SqlConnection loadConnection = new SqlConnection("server=tf-PC\\SQLEXPRESS;database=blogData;uid=admin;pwd=s1y2x3");
loadConnection.Open();
string loadArticlesCommentsString = "SELECT * FROM Comments WHERE articleID=@articleID";
SqlCommand loadCommand5 = new SqlCommand(loadArticlesCommentsString, loadConnection);
loadCommand5.Parameters.Add(new SqlParameter("articleID", SqlDbType.Int));
loadCommand5.Parameters["articleID"].Value = articleID;
SqlDataAdapter CommentAdapter = new SqlDataAdapter(loadCommand5);
DataSet loadDataSet = new DataSet();
CommentAdapter.Fill(loadDataSet, "Comments");
Comments[] comments = new Comments[loadDataSet.Tables["Comments"].Rows.Count];
for (int i = 0; i < loadDataSet.Tables["Comments"].Rows.Count; i++)
{
comments[i] = new Comments()
{
ID = Convert.ToInt32(loadDataSet.Tables["Comments"].Rows[i]["ID"]),
articleID = Convert.ToInt32(loadDataSet.Tables["Comments"].Rows[i]["articleID"]),
commenterID = Convert.ToInt32(loadDataSet.Tables["Comments"].Rows[i]["commenterID"]),
commentTime = Convert.ToDateTime(loadDataSet.Tables["Comments"].Rows[i]["commentTime"]),
content = loadDataSet.Tables["Comments"].Rows[i]["content"].ToString()
};
}
return comments;
}