Hi,
i have some troubles to get the treeview working with a self refererence table, something like this :
public partial class CATEGORIE
{
public int ID_CATEGORIE { get; set; }
public string CAT_TEXT { get; set; }
public Nullable<int> CAT_ID_PARENT { get; set; }
public Nullable<int> CAT_LEVEL { get; set; }
}
here is my client side code :
jQuery.ajax({
url: "/Produits/GetFilters",
success: function (data) {
$("#treeView").ejTreeView({
height : "300px",
fields: {
id: "ID", text: "CAT_TEXT",
hasChild: true, dataSource: data.cat, expanded: "expanded",
child: { dataSource: data.subcat, parentId: "CAT_ID_PARENT", text: "CAT_TEXT", id: "ID_CATEGORIE" }
},
showCheckbox: true
});
},
async: false
});
the controller return multiple json objects for other filters :
public JsonResult GetFilters()
{
var categories = (from n in ctx.CATEGORIES.Where(a => a.FA_LEVEL == 1).OrderBy(a => a.FA_DESIGNATION)
select new
{
ID_CATEGORIE = n.ID_CATEGORIE,
CAT_TEXT = n.CAT_TEXT,
CAT_ID_PARENT = n.CAT_ID_PARENT
}).ToList();
var subcategories = (from n in ctx.CATEGORIES.Where(a => a.CAT_LEVEL != 1 && a.CAT_LEVEL != 1).OrderBy(a => a.CAT_TEXT)
select new
{
ID_CATEGORIE = n.ID_CATEGORIE,
CAT_TEXT = n.CAT_TEXT,
CAT_ID_PARENT = n.CAT_ID_PARENT
}).ToList();
/* other stuff */
return Json(new { cat= categories subcat=subcategories, ........}, JsonRequestBehavior.AllowGet);
}
the problem is that only the first level is displayed .
my goal is to have unlimited nested levels displayed for my self reference table .
any help is welcome, thanks .
