This is a migrated thread and some comments may be shown as answers.

[Solved] treeview structure dynamically from database

8 Answers 141 Views

TreeView

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

8 Answers, 1 is accepted

answered on 30 Jul 2012, 07:02 AM

Hi Alex,

Below is my code, still i am having problem, getting error "Sequence contain no elements", can't display treeview structure. Any idea, please.

Controller
public ActionResult DataBindingToModel()
{
ReferencesFiles _ReferencesFiles = new ReferencesFiles();
var _department = new ReferencesFiles().DepartmentTreeview().AsEnumerable();
return PartialView("_TreeviewDisplay", _department.ToList());
}

Class
public IEnumerable<SYSDepartmentTreeviewModel> DepartmentTreeview()
{
using (var context = new AUSFLEETEntities())
{
var _depart = from p in context.SYS_DEPARTMENT

select new SYSDepartmentTreeviewModel
{
DEPARTMENT_ID = p.DEPARTMENT_ID,
DEPARTMENT_DESCRIPTION = p.DEPARTMENT_DESCRIPTION
Branchs = (from a in context.SYS_BRANCH
where a.DEPARTMENT_ID == p.DEPARTMENT_ID
select new SYSBranchTreeviewModel
{
DEPARTMENT_ID = p.DEPARTMENT_ID,
BRANCH_ID=a.BRANCH_ID,
BRANCH_DESCRIPTION = a.BRANCH_DESCRIPTION,

Regions = (from c in context.SYS_REGION
where a.BRANCH_ID == c.BRANCH_ID
select new SYSRegionTreeviewModel
{
BRANCH_ID = c.BRANCH_ID,
REGION_ID= c.REGION_ID,
REGION_DESCRIPTION = c.REGION_DESCRIPTION
})

})
};
return _depart.ToList();
}
}

Model

[KnownType(typeof(SYSDepartmentTreeviewModel))]
public class SYSDepartmentTreeviewModel
{
public int DEPARTMENT_ID { get; set; }
public string DEPARTMENT_DESCRIPTION { get; set; }
public IEnumerable <SYSBranchTreeviewModel> Branchs { get; set; }
}
[KnownType(typeof(SYSBranchTreeviewModel))]
public class SYSBranchTreeviewModel
{
public int BRANCH_ID { get; set; }
public string BRANCH_DESCRIPTION { get; set; }
public int DEPARTMENT_ID { get; set; }
public IEnumerable<SYSDepartmentTreeviewModel> Departments { get; set; }
public IEnumerable<SYSRegionTreeviewModel> Regions { get; set; }
}
[KnownType(typeof(SYSRegionTreeviewModel))]
public class SYSRegionTreeviewModel
{
public int REGION_ID { get; set; }
public string REGION_DESCRIPTION { get; set; }
public int BRANCH_ID { get; set; }
public IEnumerable<SYSBranchTreeviewModel> Branchs { get; set; }
}

PartialView

@model IEnumerable<SYSDepartmentTreeviewModel>
@(Html.Telerik().TreeView()
.Name("TreeView")
.BindTo(Model, mappings =>
{
mappings.For<SYSDepartmentTreeviewModel>(binding => binding
.ItemDataBound((item, department) =>
{
item.Text = department.DEPARTMENT_DESCRIPTION;
})
.Children(department => department.Branchs)
);
mappings.For<SYSBranchTreeviewModel>(binding => binding
.ItemDataBound((item, branch) =>
{
item.Text = branch.BRANCH_DESCRIPTION;
})
.Children(branch => branch.Regions)
);
})
)