Making a Tree like Structure in Json With Recursion

Question

I'm struggling to get my head around this one, i've had a few attempts and failed miserably.

Basically I have a list of Employees in a database, each with an ID. A Employee can have a parent Employee (Refer as Manager).

I need to output the structure in some sort of tree in json format like shown in this URL

https://raw.githubusercontent.com/bumbeishvili/Assets/master/Projects/D3/Organization%20Chart/redesignedChartLongData.json

Here is a very basic structure example.

Sagar Malde · Answer

Hi Mohsin, Assuming that this is your Model. (considering few fields only which are required and also taking this as your result tree view display you can create new class) public class Employee { public int empid { get ; set ; } public string EmpName { get ; set ; } public int LevelId { get ; set ; } public int ParentId { get ; set ; } public List emp = new List (); } Now you are having the list of employees in one variable List emp = // Employees from database; Now you first take the list of your Parent employees (whose ParentId is null) List ParentEmp = emp.Where(x => x.ParentId == null ).ToList(); Now create one recursive function which will give the Tree structured employee public List getEmpl(List emp) // Passing whole list of employee; { List em = new List (); emp = emp.OrderBy(x => x.ParentId).ToList(); List ParentEmp = emp.Where(x => x.ParentId == null ).ToList(); // fetching the parent employee foreach (Employee e in ParentEmp) { Employee es = new Employee { empid = e.empid, EmpName = e.EmpName, LevelId = e.LevelId, ParentId = e.ParentId, emp = BindEmployee(e.empid, emp) }; } return em; } //This will create a tree view public List BindEmployee( int EmpId, List emp) { List em = new List (); foreach (Employee e in emp.Where(x => x.ParentId == EmpId.ToString())) { Employee es = new Employee { empid = e.empid, EmpName = e.EmpName, LevelId = e.LevelId, ParentId = e.ParentId, emp = BindEmployee(e.empid, emp) }; } return em; } Thanks.