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); }
private static ForumThreadInfo PopulateForumThreadInfo(SqlDataReader dr) { ForumThreadInfo forumThreadInfo = new ForumThreadInfo(); forumThreadInfo.DateLastPost = Convert.ToDateTime(dr["DateLastPost"]); forumThreadInfo.PinnedDate = Convert.ToDateTime(dr["PinnedDate"]); forumThreadInfo.LastPostAlias = Convert.ToString(dr["LastPostAlias"]); forumThreadInfo.Replies = Convert.ToInt32(dr["Replies"]); forumThreadInfo.StartedByAlias = Convert.ToString(dr["StartedByAlias"]); forumThreadInfo.Subject = Convert.ToString(dr["Subject"]); forumThreadInfo.ThreadID = Convert.ToInt32(dr["ThreadID"]); forumThreadInfo.Views = Convert.ToInt32(dr["Views"]); forumThreadInfo.LastPostID = Convert.ToInt32(dr["LastPostID"]); return(forumThreadInfo); }
private static ForumThreadInfo PopulateForumThreadInfo(SqlDataReader dr) { ForumThreadInfo forumThreadInfo = new ForumThreadInfo(); forumThreadInfo.DateLastPost = Convert.ToDateTime(dr["DateLastPost"]); forumThreadInfo.PinnedDate = Convert.ToDateTime(dr["PinnedDate"]); forumThreadInfo.LastPostAlias = Convert.ToString(dr["LastPostAlias"]); forumThreadInfo.Replies = Convert.ToInt32(dr["Replies"]); forumThreadInfo.StartedByAlias = Convert.ToString(dr["StartedByAlias"]); forumThreadInfo.Subject = Convert.ToString(dr["Subject"]); forumThreadInfo.ThreadID = Convert.ToInt32(dr["ThreadID"]); forumThreadInfo.Views = Convert.ToInt32(dr["Views"]); forumThreadInfo.LastPostID = Convert.ToInt32(dr["LastPostID"]); return forumThreadInfo; }