/// <summary> /// The page_ load. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void Page_Load(object sender, EventArgs e) { DataSet ds = this.Get <YafDBBroker>().BoardLayout(PageContext.PageBoardID, PageContext.PageUserID, PageContext.PageCategoryID, null); this.CategoryList.DataSource = ds.Tables[YafDBAccess.GetObjectName("Category")]; this.CategoryList.DataBind(); }
/// <summary> /// The bind data. /// </summary> private void BindData() { using (DataSet ds = DB.ds_forumadmin(PageContext.PageBoardID)) { this.CategoryList.DataSource = ds.Tables[YafDBAccess.GetObjectName("Category")]; } DataBind(); }
/// <summary> /// Bind data for this control. /// </summary> private void BindData() { // get list of forums and their moderating data using (DataSet ds = DB.forum_moderatelist(PageContext.PageUserID, PageContext.PageBoardID)) { this.CategoryList.DataSource = ds.Tables[YafDBAccess.GetObjectName("Category")]; } // bind data to controls DataBind(); }
/// <summary> /// The bind data. /// </summary> void BindData() { DataSet ds = this.Get <YafDBBroker>().BoardLayout(PageContext.PageBoardID, PageContext.PageUserID, PageContext.PageCategoryID, PageContext.PageForumID); if (ds.Tables[YafDBAccess.GetObjectName("Forum")].Rows.Count > 0) { this.ForumList.DataSource = ds.Tables[YafDBAccess.GetObjectName("Forum")].Rows; this.SubForums.Visible = true; } this.Pager.PageSize = PageContext.BoardSettings.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 (!PageContext.BoardSettings.ShowDeletedMessagesToAll) { // only show deleted messages that belong to this user if they are not admin/mod if (!PageContext.IsAdmin && !PageContext.ForumModeratorAccess) { userId = PageContext.PageUserID; } } DataTable dt = StyleTransformDataTable(DB.topic_list(PageContext.PageForumID, userId, 1, null, 0, 10, PageContext.BoardSettings.UseStyledNicks, true)); int nPageSize = Math.Max(5, this.Pager.PageSize - dt.Rows.Count); 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; * } * }*/ int nCurrentPageIndex = this.Pager.CurrentPageIndex; DataTable dtTopics; if (this._showTopicListSelected == 0) { dtTopics = StyleTransformDataTable( DB.topic_list(PageContext.PageForumID, userId, 0, null, nCurrentPageIndex * nPageSize, nPageSize, PageContext.BoardSettings.UseStyledNicks, true)); } else { DateTime date = DateTime.UtcNow; switch (this._showTopicListSelected) { case 1: date -= TimeSpan.FromDays(1); break; case 2: date -= TimeSpan.FromDays(2); break; case 3: date -= TimeSpan.FromDays(7); break; case 4: date -= TimeSpan.FromDays(14); break; case 5: date -= TimeSpan.FromDays(31); break; case 6: date -= TimeSpan.FromDays(2 * 31); break; case 7: date -= TimeSpan.FromDays(6 * 31); break; case 8: date -= TimeSpan.FromDays(365); break; } dtTopics = StyleTransformDataTable( DB.topic_list(PageContext.PageForumID, userId, 0, date, nCurrentPageIndex * nPageSize, nPageSize, PageContext.BoardSettings.UseStyledNicks, true)); } int nRowCount = 0; if (dtTopics.Rows.Count > 0) { nRowCount = (int)dtTopics.Rows[0]["RowCount"]; } int nPageCount = (nRowCount + nPageSize - 1) / nPageSize; this.TopicList.DataSource = dtTopics; DataBind(); // setup the show topic list selection after data binding this.ShowList.SelectedIndex = this._showTopicListSelected; YafContext.Current.Get <YafSession>().ShowList = this._showTopicListSelected; this.Pager.Count = nRowCount; }