public Collection <Comment> GetAllComments(CommentType ctype)
{
using (SqlConnection connection = this.GetConnection())
{
connection.Open();
SqlCommand sc = new SqlCommand("GetAllComments", connection);
sc.CommandType = CommandType.StoredProcedure;
Collection <Comment> clist = SqlDataMap.CreateCommentsFromReader(sc.ExecuteReader());
return(clist);
}
}
public Collection <Comment> GetCommentsForPost(int postId, CommentType ctype)
{
using (SqlConnection connection = this.GetConnection())
{
connection.Open();
SqlCommand sc = new SqlCommand("GetCommentsByPost", connection);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.AddWithValue("PostId", postId);
if (ctype == CommentType.All)
{
sc.Parameters.AddWithValue("Approved", DBNull.Value);
}
else
{
int bitValue = 0;
if (ctype == CommentType.Approved)
{
bitValue = 1;
}
else if (ctype == CommentType.UnApproved)
{
bitValue = 0;
}
sc.Parameters.AddWithValue("Approved", bitValue);
}
Collection <Comment> clist = SqlDataMap.CreateCommentsFromReader(sc.ExecuteReader());
return(clist);
}
}