public static ForumThreadInfoCollection GetThreads(int forumID, int pageSize, int pageIndex) { SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["RiversideInternetForumsConnectionString"]); SqlCommand cmd = new SqlCommand("WS_GetThreads", conn); // Populate parameters cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ForumID", SqlDbType.Int, 4); cmd.Parameters.Add("@PageSize", SqlDbType.Int, 4); cmd.Parameters.Add("@PageIndex", SqlDbType.Int, 4); cmd.Parameters[0].Value = forumID; cmd.Parameters[1].Value = pageSize; cmd.Parameters[2].Value = pageIndex; conn.Open(); ForumThreadInfoCollection forumThreadInfoCollection = new ForumThreadInfoCollection(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ForumThreadInfo forumThreadInfo = PopulateForumThreadInfo(dr); forumThreadInfoCollection.Add(forumThreadInfo); } dr.Close(); conn.Close(); return(forumThreadInfoCollection); }
public static ForumThreadInfoCollection GetThreads(int forumID, int pageSize, int pageIndex) { SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["RiversideInternetForumsConnectionString"]); SqlCommand cmd = new SqlCommand("WS_GetThreads", conn); // Populate parameters cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ForumID", SqlDbType.Int, 4); cmd.Parameters.Add("@PageSize", SqlDbType.Int, 4); cmd.Parameters.Add("@PageIndex", SqlDbType.Int, 4); cmd.Parameters[0].Value = forumID; cmd.Parameters[1].Value = pageSize; cmd.Parameters[2].Value = pageIndex; conn.Open(); ForumThreadInfoCollection forumThreadInfoCollection = new ForumThreadInfoCollection(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ForumThreadInfo forumThreadInfo = PopulateForumThreadInfo(dr); forumThreadInfoCollection.Add(forumThreadInfo); } dr.Close(); conn.Close(); return forumThreadInfoCollection; }
public override void OnPreRender() { // Get threads that will be rendered and the total number of forum threads _forumThreadInfoCollection = ForumDB.GetThreads(ForumID, _threadsPerPage, _threadsPage); _threadCount = ForumDB.GetThreadCount(ForumID); }
public override void OnPreRender() { // Get threads that will be rendered and the total number of forum threads _forumThreadInfoCollection = ForumDB.GetThreads(ForumID, _threadsPerPage, _threadsPage); _threadCount = ForumDB.GetThreadCount(ForumID); }