//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; }