} //CommentSelect
public static List <CommentAdvanced> CommentSelectByBlogId(int blogPostId)
{
List <CommentAdvanced> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_SelectByBlogId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@BlogPostId", blogPostId);
}, map : delegate(IDataReader reader, short set)
{
CommentAdvanced b = new CommentAdvanced();
int startingIndex = 0;
b.BlogPostID = reader.GetSafeInt32(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.Author = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (list == null)
{
list = new List <CommentAdvanced>();
}
list.Add(b);
}
);
return(list);
} // CommentSelectByBlogId -- replaced by GetCommentsByBlogId in BlogsAPIController
} // CommentInsert
public static List <CommentAdvanced> CommentSelect()
{
List <CommentAdvanced> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_Select"
, inputParamMapper : null, map : delegate(IDataReader reader, short set)
{
CommentAdvanced b = new CommentAdvanced();
int startingIndex = 0;
b.ID = reader.GetSafeInt32(startingIndex++);
b.BlogPostID = reader.GetSafeInt32(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.Author = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (list == null)
{
list = new List <CommentAdvanced>();
}
list.Add(b);
}
);
return(list);
} //CommentSelect
} // CommentSelectByBlogId -- replaced by GetCommentsByBlogId in BlogsAPIController
public static CommentAdvanced CommentSelectById(int id)
{
CommentAdvanced row = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ID", id);
}, map : delegate(IDataReader reader, short set)
{
CommentAdvanced b = new CommentAdvanced();
int startingIndex = 0;
b.ID = reader.GetSafeInt32(startingIndex++);
b.BlogPostID = reader.GetSafeInt32(startingIndex++);
b.ParentCommentID = reader.GetSafeInt32Nullable(startingIndex++);
b.Title = reader.GetSafeString(startingIndex++);
b.Content = reader.GetSafeString(startingIndex++);
b.Author = reader.GetSafeString(startingIndex++);
b.DateCreated = reader.GetSafeDateTime(startingIndex++);
b.DateModified = reader.GetSafeDateTime(startingIndex++);
if (row == null)
{
row = b;
}
}
);
return(row);
} // CommentSelectById
private static List <CommentAdvanced> BlogCommentSelectReplies(int ParentCommentId)
{
List <CommentAdvanced> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CommentAdvanced_SelectByParentCommentId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
SqlParameter parameter = paramCollection.Add("@ParentCommentId", SqlDbType.Int);
parameter.Value = ParentCommentId;
}, map : delegate(IDataReader reader, short set)
{
CommentAdvanced temp = BindBlogComment(reader);
// Now, we have fully hydrated our temp model
if (list == null)
{
list = new List <CommentAdvanced>();
}
// Add the temp model into the resulting list.
list.Add(temp);
}
);
return(list);
}
private static CommentAdvanced BindBlogComment(IDataReader reader)
{
CommentAdvanced temp = new CommentAdvanced();
int startingIndex = 0; //startingOrdinal
temp.ID = reader.GetSafeInt32(startingIndex++);
temp.BlogPostID = reader.GetSafeInt32(startingIndex++);
temp.ParentCommentID = reader.GetSafeInt32(startingIndex++);
temp.Author = reader.GetSafeString(startingIndex++);
temp.Title = reader.GetSafeString(startingIndex++);
temp.Content = reader.GetSafeString(startingIndex++);
temp.DateCreated = reader.GetSafeDateTime(startingIndex++);
temp.DateModified = reader.GetSafeDateTime(startingIndex++);
// Get all of our children
temp.Replies = BlogCommentSelectReplies(temp.ID);
return(temp);
}
