ForumEditor.ascx.cs

//
// Active Forums - http://www.dnnsoftware.com
// Copyright (c) 2013
// by DNN Corp.
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions 
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL 
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF 
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
// DEALINGS IN THE SOFTWARE.
//
using System;
using System.Data;

using DotNetNuke.Entities.Modules;
using System.Web.UI.WebControls;
using DotNetNuke.Framework;
using Telerik.Web.UI;

namespace DotNetNuke.Modules.ActiveForums.Controls
{
    public partial class ForumEditor : PortalModuleBase
    {

        protected override void OnLoad(EventArgs e)
		{
			base.OnLoad(e);

            jQuery.RequestDnnPluginsRegistration();

            BindForums();
        }
        private void BindForums()
        {
            using (IDataReader dr = DataProvider.Instance().Forums_List(PortalId, ModuleId, -1, -1, false))
            {
                ctlForums.Nodes.Clear();
                var dt = new DataTable("Forums");
                dt.Load(dr);
                dr.Close();

                var groupNode = new RadTreeNode();
                string strParent = "-1";



                int totalGroupForum = 0;
                string tmpGroup = string.Empty;
                int i = 0;
                int groupCount = 0;
                int forumCount = 0;
                bool hasChildren = false;
                foreach (DataRow row in dt.Rows)
                {
                    if (tmpGroup != row["ForumGroupId"].ToString())
                    {
                        if (hasChildren)
                        {
                            ctlForums.Nodes.Add(groupNode);
                        }
                        drpForums.Items.Add(new ListItem(row["GroupName"].ToString(), row["ForumGroupId"].ToString()));
                        groupNode = new RadTreeNode
                                        {Text = row["GroupName"].ToString(), Value = row["ForumGroupId"].ToString()};
                        tmpGroup = row["ForumGroupId"].ToString();
                    }
                    drpForums.Items.Add(new ListItem("-----" + row["ForumName"], row["ForumId"].ToString()));
                    var node = new RadTreeNode {Text = row["ForumName"].ToString(), Value = row["ForumId"].ToString()};
                    groupNode.Nodes.Add(node);
                    hasChildren = true;
                }
                ctlForums.Nodes.Add(groupNode);
            }

        }
    }
}