} //CommentAdvancedInsert
public static List <Blog.Comment.Reply> CommentAdvancedSelect()
{
List <Blog.Comment.Reply> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_Select"
, inputParamMapper : null, map : delegate(IDataReader reader, short set)
{
Blog.Comment.Reply b = new Blog.Comment.Reply();
int startingIndex = 0;
b.ID = reader.GetSafeInt32(startingIndex++);
b.BlogPostID = reader.GetSafeInt32(startingIndex++);
b.ParentCommentID = reader.GetSafeInt32(startingIndex++);
b.UserName = reader.GetSafeString(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (list == null)
{
list = new List <Blog.Comment.Reply>();
}
list.Add(b);
}
);
return(list);
} //CommentAdvancedSelect
} //CommentReplySelect
public static List <Blog.Comment.Reply> CommentReplySelectByCommentId(int commentId)
{
List <Blog.Comment.Reply> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentReply_SelectByCommentId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CommentId", commentId);
}, map : delegate(IDataReader reader, short set)
{
Blog.Comment.Reply b = new Blog.Comment.Reply();
int startingIndex = 0;
b.ParentCommentID = reader.GetSafeInt32(startingIndex++);
b.UserName = reader.GetSafeString(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (list == null)
{
list = new List <Blog.Comment.Reply>();
}
list.Add(b);
}
);
return(list);
} // CommentReplySelectByBlogId
} // CommentAdvancedSelectByBlogId -- in blogsapicontroller
public static Blog.Comment.Reply CommentAdvancedSelectById(int commentAdvancedId)
{
Blog.Comment.Reply row = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ID", commentAdvancedId);
}, map : delegate(IDataReader reader, short set)
{
Blog.Comment.Reply b = new Blog.Comment.Reply();
int startingIndex = 0;
b.ID = reader.GetSafeInt32(startingIndex++);
b.ParentCommentID = reader.GetSafeInt32(startingIndex++);
b.UserName = reader.GetSafeString(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (row == null)
{
row = b;
}
}
);
return(row);
} // CommentAdvancedSelectById
