public SideBar(string permitslist)
        {
            sidebarbd = new SideBarDB();

            if (permitslist.Equals("all"))
            {
                permitslist = sidebarbd.getAllPermit();
            }

            string[] permits = permitslist.Split('|');
            category = new Categories[permits.Length];

            for (int i = 0; i < permits.Length; i++)
            {
                category[i] = new Categories(permits[i]);
            }

            sidebarbd = null;
        }
        public Categories(string permits)
        {
            SideBarDB sidebardb = new SideBarDB();

            int    k          = permits.IndexOf('.');
            string idnamemenu = permits.Substring(0, k);

            categoryname  = sidebardb.getNameByIdFromDB(idnamemenu);
            categoryid    = categoryname.ToString().Replace(" ", string.Empty) + "collapse";
            subcategoryid = permits.Split(',');

            subcategoryname = new string[subcategoryid.Length];
            subcategorlink  = new string[subcategoryid.Length];
            for (int i = 0; i < subcategoryid.Length; i++)
            {
                subcategoryname[i] = sidebardb.getNameByIdFromDB(subcategoryid[i]);
                Console.WriteLine(subcategoryname[i]);
                subcategorlink[i] = sidebardb.getLinkByIdFromDB(subcategoryid[i]);
                Console.WriteLine(subcategorlink[i]);
            }
        }