//public static List<BlogComment> GetBlogCommentsByWebBlogEntryID(int BlogEntryID)
//{
// Database db = DatabaseFactory.CreateDatabase();
// DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBlogCommentByBlogEntryID");
// db.AddInParameter(dbCommand, "BlogEntryID", DbType.Int32, BlogEntryID);
// List<BlogComment> arr = null;
// // Populate the datareader
// using (IDataReader dr = db.ExecuteReader(dbCommand))
// {
// // Call the PopulateObject method passing the datareader to return the object array
// arr = Next2Friends.Data.BlogComment.PopulateBlogCommentWithJoin(dr);
// dr.Close();
// }
// return arr;
//}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of MemberComments
/// </summary>
public static List <MemberComment> PopulateMemberCommentWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List <MemberComment> arr = new List <MemberComment>();
MemberComment obj;
while (dr.Read())
{
obj = new MemberComment();
if (list.IsColumnPresent("MemberCommentID"))
{
obj._memberCommentID = (int)dr["MemberCommentID"];
}
if (list.IsColumnPresent("MemberID"))
{
obj._memberID = (int)dr["MemberID"];
}
if (list.IsColumnPresent("MemberIDFrom"))
{
obj._memberIDFrom = (int)dr["MemberIDFrom"];
}
if (list.IsColumnPresent("Text"))
{
obj._text = (string)dr["Text"];
}
if (list.IsColumnPresent("DTCreated"))
{
obj._dTCreated = (DateTime)dr["DTCreated"];
}
if (list.IsColumnPresent("WebMemberID"))
{
obj.WebMemberID = (string)dr["WebMemberID"];
}
if (list.IsColumnPresent("NickName"))
{
obj.NickName = (string)dr["NickName"];
}
if (list.IsColumnPresent("PhotoUrl"))
{
obj.PhotoUrl = (string)dr["PhotoUrl"];
}
arr.Add(obj);
}
dr.Close();
return(arr);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of MemberComments
/// </summary>
public static List<MemberComment> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<MemberComment> arr = new List<MemberComment>();
MemberComment obj;
while (dr.Read())
{
obj = new MemberComment();
if (list.IsColumnPresent("MemberCommentID")) { obj._memberCommentID = (int)dr["MemberCommentID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("MemberIDFrom")) { obj._memberIDFrom = (int)dr["MemberIDFrom"]; }
if (list.IsColumnPresent("Text")) { obj._text = (string)dr["Text"]; }
if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
