Making a Tree like Structure in Json With Recursion

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sagar Malde6y ago
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.