public void DefaultSearchFriends(ref HomeBAL hBAL) { SqlConnection SocialConn = new SqlConnection(connstr); using (SqlCommand comm = new SqlCommand("proc_FriendsSearch", SocialConn)) { comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@userid", hBAL.userid); SocialConn.Open(); hBAL.Search_Reader = comm.ExecuteReader(CommandBehavior.CloseConnection); } }
public string GetAllCategoriesForTree() { List <Category> categories = new List <Category>(); DataTable dt = new HomeBAL().GetAllCategories(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { categories.Add( new Category { CategoryId = Convert.ToInt32(row["CategoryId"]), CategoryName = row["CategoryName"].ToString(), ParentCategoryId = (Convert.ToInt32(row["ParentCategoryId"]) != 0) ? Convert.ToInt32(row["ParentCategoryId"]) : (int?)null }); } List <TreeNode> headerTree = FillRecursive(categories, null); #region BindingHeaderMenus string root_li = string.Empty; string down1_names = string.Empty; string down2_names = string.Empty; foreach (var item in headerTree) { root_li += "<li class=\"dropdown mega-menu-fullwidth\">" + "<a href=\"/Product/ListProduct?cat=" + item.CategoryId + "\" class=\"dropdown-toggle\" data-hover=\"dropdown\" data-toggle=\"dropdown\">" + item.CategoryName + "</a>"; down1_names = ""; foreach (var down1 in item.Children) { down2_names = ""; foreach (var down2 in down1.Children) { down2_names += "<li><a href=\"/Product/ListProduct?cat=" + down2.CategoryId + "\">" + down2.CategoryName + "</a></li>"; } down1_names += "<div class=\"col-md-2 col-sm-6\">" + "<h3 class=\"mega-menu-heading\"><a href=\"/Product/ListProduct?cat=" + down1.CategoryId + "\">" + down1.CategoryName + "</a></h3>" + "<ul class=\"list-unstyled style-list\">" + down2_names + "</ul>" + "</div>"; } root_li += "<ul class=\"dropdown-menu\">" + "<li>" + "<div class=\"mega-menu-content\">" + "<div class=\"container\">" + "<div class=\"row\">" + down1_names + "</div>" + "</div>" + "<div>" + "</li>" + "</ul>" + "</li>"; } #endregion return("<ul class=\"nav navbar-nav\">" + root_li + "</ul>"); } return("Record Not Found!!"); }