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