/// <summary> /// The bind data. /// </summary> private void BindData() { var ds = this.Get <YafDbBroker>().BoardLayout( this.PageContext.PageBoardID, this.PageContext.PageUserID, this.PageContext.PageCategoryID, this.PageContext.PageForumID); if (ds.Tables["Forum"].HasRows()) { this.ForumList.DataSource = ds.Tables["Forum"].Rows; this.SubForums.Visible = true; } this.Pager.PageSize = this.Get <YafBoardSettings>().TopicsPerPage; // when userId is null it returns the count of all deleted messages /*int? userId = null; * * // get the userID to use for the deleted posts count... * if (!this.Get<YafBoardSettings>().ShowDeletedMessagesToAll) * { * // only show deleted messages that belong to this user if they are not admin/mod * if (!this.PageContext.IsAdmin && !this.PageContext.ForumModeratorAccess) * { * userId = this.PageContext.PageUserID; * } * }*/ int?userId = this.PageContext.PageUserID; var dt = LegacyDb.announcements_list( this.PageContext.PageForumID, userId, null, DateTime.UtcNow, 0, 10, this.Get <YafBoardSettings>().UseStyledNicks, true, this.Get <YafBoardSettings>().UseReadTrackingByDatabase); if (dt != null) { dt = this.StyleTransformDataTable(dt); } var baseSize = this.Get <YafBoardSettings>().TopicsPerPage; this.Announcements.DataSource = dt; /*if (!m_bIgnoreQueryString && Request.QueryString["p"] != null) * { * // show specific page (p is 1 based) * int tPage = (int)Security.StringToLongOrRedirect(Request.QueryString["p"]); * * if (tPage > 0) * { * Pager.CurrentPageIndex = tPage - 1; * } * }*/ var pagerCurrentPageIndex = this.Pager.CurrentPageIndex; DataTable dtTopics; if (this._showTopicListSelected == 0) { dtTopics = LegacyDb.topic_list( this.PageContext.PageForumID, userId, DateTimeHelper.SqlDbMinTime(), DateTime.UtcNow, pagerCurrentPageIndex, baseSize, this.Get <YafBoardSettings>().UseStyledNicks, true, this.Get <YafBoardSettings>().UseReadTrackingByDatabase); if (dtTopics != null) { dtTopics = this.StyleTransformDataTable(dtTopics); } } else { int[] days = { 1, 2, 7, 14, 31, 2 * 31, 6 * 31, 356 }; var date = DateTime.UtcNow.AddDays(-days[this._showTopicListSelected]); dtTopics = LegacyDb.topic_list( this.PageContext.PageForumID, userId, date, DateTime.UtcNow, pagerCurrentPageIndex, baseSize, this.Get <YafBoardSettings>().UseStyledNicks, true, this.Get <YafBoardSettings>().UseReadTrackingByDatabase); if (dtTopics != null) { dtTopics = this.StyleTransformDataTable(dtTopics); } } this.TopicList.DataSource = dtTopics; this.DataBind(); // setup the show topic list selection after data binding this.ShowList.SelectedIndex = this._showTopicListSelected; this.Get <IYafSession>().ShowList = this._showTopicListSelected; if (dtTopics != null && dtTopics.HasRows()) { this.Pager.Count = dtTopics.AsEnumerable().First().Field <int>("TotalRows"); } }