protected string ViewSideMenu() { anm_Utility ut = new anm_Utility(); string category = ""; if (Request.QueryString["news"] != null) { category = ut.GetCategoryFromNews(Request.QueryString["news"]); } if (Request.QueryString["category"] != null) { category = Request.QueryString["category"]; } if (category == "") { string menu = ""; if (ut.GetSetting("SideMenu") == "True") { menu = ut.GetSideMenu(); } return(menu); } else { string apath = anm_Utility.GetWebAppRoot(); string idfather = ut.GetIdFather(category); String[] categories = new String[20]; string res = ""; int i = 1; categories[0] = category; while (!idfather.Equals("0")) { categories[i] = idfather; idfather = ut.GetIdFather(idfather); i++; } for (int j = 0; categories[j] != null; j++) { string cat = ut.GetCategory(categories[j]); string url = ut.GetCategoryUrl(categories[j]); if (url == "" || url == null) { res = "<li><a href='" + apath + "/subscribe/" + categories[j] + ".aspx'><img src='" + apath + "/images/rssicon.gif' alt='rss' style='border: none;' /></a> <strong><a href='" + apath + "/category" + categories[j] + ".aspx'>" + cat + "</a></strong></li>" + res; } else { res = "<li> <strong><a href='" + url + "'>" + cat + "</a></strong></li>" + res; } } string linksons = ""; string strConn = ConfigurationManager.ConnectionStrings["anmcs"].ToString(); SqlConnection myConnection = new SqlConnection(strConn); SqlCommand myCommand = new SqlCommand("anm_getSonCategories", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("@idcategory", SqlDbType.NVarChar).Value = category; myConnection.Open(); SqlDataReader reader = myCommand.ExecuteReader(); while (reader.Read()) { string url = reader["url"].ToString(); string idc = reader["idcategory"].ToString(); string cat = reader["category"].ToString(); if (url == "" || url == null) { linksons += "<li class='menulinksons'><a href='" + apath + "/subscribe/" + idc + ".aspx'><img src='" + apath + "/images/rssicon.gif' alt='rss' style='border: none;' /></a> <strong><a href='" + apath + "/category" + idc + ".aspx'>" + cat + "</a></strong></li>"; } else { linksons += "<li class='menulinksons'> <strong><a href='" + url + "'>" + cat + "</a></strong></li>"; } } myConnection.Close(); if (linksons != "") { //res += "<ul class='menulinksons'>" + linksons + "</ul>"; res += linksons; } if (ut.GetSetting("SideMenu") == "True") { return("<h2>" + HttpContext.GetGlobalResourceObject("language", "Menu") + "</h2><div class='sp'><ul>" + res + "</ul></div>"); } else { return(""); } } }