/// <summary>
 /// Updates the comment status.
 /// </summary>
 /// <param name="commentStatus">The comment status.</param>
 /// <param name="commentId">The comment id.</param>
 /// <param name="userId">The user id.</param>
 private void UpdateCommentStatus(CommentStatus commentStatus, int commentId, int userId)
 {
     database.NonQuery("Comment_UpdateStatus", new
     {
         CommentStatus = commentStatus.ToString(),
         commentId,
         userId
     }
                       );
 }
        protected override string BuildPostContentString()
        {
            string result = string.Format(_content,
                                          BlogId,
                                          Credentials.UserName.HtmlEncode(),
                                          Credentials.Password.HtmlEncode(),
                                          PostId,
                                          CommentStatus.ToString(),
                                          Offset,
                                          Number);

            return(result);
        }
 /// <summary>
 /// Retrieves the comment by status and user id.
 /// </summary>
 /// <param name="userId">The user id.</param>
 /// <param name="commentstatus">The commentstatus.</param>
 /// <returns></returns>
 public List <Comment> RetrieveCommentByStatusAndUserId(int userId, CommentStatus commentstatus)
 {
     return(database.PopulateCollection("Comment_RetrieveCommentByStatusAndUserId", new{ userId, commentstatus = commentstatus.ToString() }, database.AutoPopulate <Comment>));
 }
 /// <summary>
 /// Retrieves the comment by status and user id.
 /// </summary>
 /// <param name="userId">The user id.</param>
 /// <param name="commentstatus">The commentstatus.</param>
 /// <returns></returns>
 public List<Comment> RetrieveCommentByStatusAndUserId(int userId, CommentStatus commentstatus)
 {
     return database.PopulateCollection("Comment_RetrieveCommentByStatusAndUserId", new{userId, commentstatus = commentstatus.ToString()}, database.AutoPopulate<Comment>);
 }
 /// <summary>
 /// Updates the comment status.
 /// </summary>
 /// <param name="commentStatus">The comment status.</param>
 /// <param name="commentId">The comment id.</param>
 /// <param name="userId">The user id.</param>
 private void UpdateCommentStatus(CommentStatus commentStatus, int commentId, int userId)
 {
     database.NonQuery("Comment_UpdateStatus", new
                                                    {
                                                        CommentStatus = commentStatus.ToString(),
                                                        commentId,
                                                        userId
                                                    }
         );
 }