/// <summary>
/// Deletes the comment.
/// </summary>
/// <param name="comment">The comment.</param>
/// <returns></returns>
public int DeleteComment(EBlogComment comment)
{
return ExecuteNonQuery(
"DELETE TBlogComment WHERE CommentID = @CommentID;",
CreateParameter("CommentID", comment.CommentID)
);
}
/// <summary>
/// Changes the specified comment.
/// </summary>
/// <param name="comment">The comment.</param>
/// <returns></returns>
protected BBlogComment Change(EBlogComment comment)
{
return new BBlogComment()
{
Approved = comment.Approved,
CommentDate = comment.CommentDate,
CommentID = comment.CommentID,
Content = comment.Content,
PostID = comment.PostID,
Title = comment.Title,
UserID = comment.UserID,
WriterName = comment.WriterName
};
}
/// <summary>
/// Inserts the comment.
/// </summary>
/// <param name="comment">The comment.</param>
/// <returns></returns>
public int InsertComment(EBlogComment comment)
{
return ExecuteInsertQueryReturnID(
"TBlogComment",
new Dictionary<string, object>() {
{"PostID", comment.PostID},
{"UserID", comment.UserID},
{"WriterName", comment.WriterName},
{"Title", comment.Title},
{"Content", comment.Content},
{"CommentDate", comment.CommentDate},
{"Approved", comment.Approved},
});
}
/// <summary>
/// Updates the comment.
/// </summary>
/// <param name="comment">The comment.</param>
/// <returns></returns>
public int UpdateComment(EBlogComment comment)
{
return ExecuteNonQuery(
@"UPDATE TBlogComment
SET
PostID = @PostID,
UserID = @UserID,
WriterName = @WriterName,
Title = @Title,
[Content] = @Content,
CommentDate = @CommentDate,
Approved = @Approved
WHERE CommentID = @CommentID",
CreateParameter("@CommentID", DbType.Int32, comment.CommentID),
CreateParameter("@PostID", DbType.Int32, comment.PostID),
CreateParameter("@UserID", DbType.Guid, comment.UserID),
CreateParameter("@WriterName", DbType.String, comment.WriterName),
CreateParameter("@Title", DbType.String, comment.Title),
CreateParameter("@Content", DbType.String, comment.Content),
CreateParameter("@CommentDate", DbType.DateTime, comment.CommentDate),
CreateParameter("@Approved", DbType.Boolean, comment.Approved));
}
