protected void Page_Load(object sender, EventArgs e) { TreeView treeForum; Conector con = new Conector(); /////////////////////////////////////Forum ID->Server ID//////////////////////////////////// MembershipUser m = Membership.GetUser(); if (m!=null) { SqlDataReader is_allrady_Reg = con.select("SELECT TOP (1) Server_id_user FROM IDs_Server_and_Forum WHERE (Forum_id_user = '******')"); if (!is_allrady_Reg.Read()) { int id_server; SqlDataReader id_server_new = con.select("SELECT TOP (1) Forum_id_user FROM IDs_Server_and_Forum ORDER BY Forum_id_user DESC"); if (id_server_new.Read()) { id_server = Convert.ToInt32(id_server_new[0].ToString()); } else id_server = 0; con.insert("INSERT INTO IDs_Server_and_Forum (Server_id_user, Forum_id_user) VALUES (" + id_server + ",'" + m.ProviderUserKey.ToString() + "')"); con.insert("INSERT INTO Server_info (ID_Client) VALUES (" + id_server + ")"); } } //////////////////////////////////////////////////////////////////////////////////////////// SqlDataReader Forum; SqlDataReader SabForum; int i = 0; Forum = con.select("SELECT id, name FROM forum"); treeForum = this.TreeView1; ContentPlaceHolder menu = (ContentPlaceHolder)Master.FindControl("menu"); Menu men = (Menu)menu.FindControl("NavigationMenu"); if (Roles.IsUserInRole("Users") || Roles.IsUserInRole("Admins")) { MenuItem it = new MenuItem("Создать раздачю"); it.NavigateUrl= "~/Forum/Create_topic.aspx"; men.Items.Add(it); } while (Forum.Read()) { TreeNode t =new TreeNode(Forum[1].ToString()); t.NavigateUrl="~/Forum/ShowForum.aspx?forum="+Forum[0].ToString(); treeForum.Nodes.Add(t); SabForum = con.select("SELECT name, id FROM subforum WHERE (forum = "+Forum[0].ToString()+")"); while(SabForum.Read()) { TreeNode t1 = new TreeNode(SabForum[0].ToString()); t1.NavigateUrl="~/Forum/ShowSabForum.aspx?forum="+Forum[0].ToString()+"&subforum="+SabForum[1].ToString(); treeForum.Nodes[i].ChildNodes.Add(t1); } i++; } con.con_close(); }
protected void Page_Load(object sender, EventArgs e) { TreeView treeForum; Conector con = new Conector(); /////////////////////////////////////Forum ID->Server ID//////////////////////////////////// MembershipUser m = Membership.GetUser(); if (m != null) { SqlDataReader is_allrady_Reg = con.select("SELECT TOP (1) Server_id_user FROM IDs_Server_and_Forum WHERE (Forum_id_user = '******')"); if (!is_allrady_Reg.Read()) { int id_server; SqlDataReader id_server_new = con.select("SELECT TOP (1) Forum_id_user FROM IDs_Server_and_Forum ORDER BY Forum_id_user DESC"); if (id_server_new.Read()) { id_server = Convert.ToInt32(id_server_new[0].ToString()); } else { id_server = 0; } con.insert("INSERT INTO IDs_Server_and_Forum (Server_id_user, Forum_id_user) VALUES (" + id_server + ",'" + m.ProviderUserKey.ToString() + "')"); con.insert("INSERT INTO Server_info (ID_Client) VALUES (" + id_server + ")"); } } //////////////////////////////////////////////////////////////////////////////////////////// SqlDataReader Forum; SqlDataReader SabForum; int i = 0; Forum = con.select("SELECT id, name FROM forum"); treeForum = this.TreeView1; ContentPlaceHolder menu = (ContentPlaceHolder)Master.FindControl("menu"); Menu men = (Menu)menu.FindControl("NavigationMenu"); if (Roles.IsUserInRole("Users") || Roles.IsUserInRole("Admins")) { MenuItem it = new MenuItem("Создать раздачю"); it.NavigateUrl = "~/Forum/Create_topic.aspx"; men.Items.Add(it); } while (Forum.Read()) { TreeNode t = new TreeNode(Forum[1].ToString()); t.NavigateUrl = "~/Forum/ShowForum.aspx?forum=" + Forum[0].ToString(); treeForum.Nodes.Add(t); SabForum = con.select("SELECT name, id FROM subforum WHERE (forum = " + Forum[0].ToString() + ")"); while (SabForum.Read()) { TreeNode t1 = new TreeNode(SabForum[0].ToString()); t1.NavigateUrl = "~/Forum/ShowSabForum.aspx?forum=" + Forum[0].ToString() + "&subforum=" + SabForum[1].ToString(); treeForum.Nodes[i].ChildNodes.Add(t1); } i++; } con.con_close(); }