public static BlogEntry GetBlogEntry(Int32 blogEntryID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBlogEntry"); db.AddInParameter(dbCommand, "entryID", DbType.Int32, blogEntryID); List <BlogEntry> BlogEntList = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array BlogEntList = BlogEntry.PopulateObject(dr); dr.Close(); } if (BlogEntList.Count > 0) { return(BlogEntList[0]); } else { return(null); } }
public static List <BlogEntry> GetBlogEntryByMemberID(string WebMemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBlogEntryByMemberID"); db.AddInParameter(dbCommand, "WebMemberID", DbType.String, WebMemberID); List <BlogEntry> BlogEntList = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array BlogEntList = BlogEntry.PopulateObject(dr); dr.Close(); } return(BlogEntList); }
/// <summary> /// Gets the blog entries for the mobile application. /// </summary> public static BlogEntry[] GetMobileBlogEntry(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetMobileBlogEntry"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); List <BlogEntry> BlogEntList = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array BlogEntList = BlogEntry.PopulateObject(dr); dr.Close(); } return(BlogEntList.ToArray()); }