Click here to Skip to main content
15,918,333 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C# sharp code which i have tried is below
C#
public void GetReportee()
{
    IList<Employee> lstEmployee = new List<Employee>();
    IList<Employee> ListOne = new List<Employee>();

    lstEmployee = objBCHReviewService.GetReportee(out ListOne);
     IList<Employee> listEmployeeTwo = new List<Employee>();
     int   count=1;
    ddlEmployee.Items.Insert(0, new ListItem("All", "0"));
    foreach (Employee emp in ListOne)
    {
        ddlEmployee.Items.Add(emp.FirstName);
        ddlEmployee.Items[count].Attributes.Add("style", "color:blue");
        listEmployeeTwo = lstEmployee.Where(x => x.ManagerEmployeeId == emp.EmployeeId).ToList();
        foreach (Employee em in listEmployeeTwo)
        {
            String EmpName = "&nbsp;&nbsp;&nbsp;" + em.FirstName;
            ddlEmployee.Items.Add(new ListItem(Server.HtmlDecode(EmpName), Convert.ToString(em.EmployeeId)));
        }
        count += listEmployeeTwo.Count() + 1;
    }

}

        public IList<employee> GetReportee(out IList<employee>ListOne)
        {
            IList<employee> objListOneEmployee = new List<employee>();
            IList<employee> objListEmployee = new List<employee>();

            Employee objEmployee = null;
            using (DbCommand dbcGetEmployee = db.GetStoredProcCommand("usp_GetEmployees"))
            {
                db.AddInParameter(dbcGetEmployee, "@EmployeeUID", DbType.String, "512677");
                IDataReader dr = db.ExecuteReader(dbcGetEmployee);
               while (dr.Read())
               {
                   objEmployee = new Employee();
                   if (dr["EmployeeId"] != DBNull.Value)
                       objEmployee.EmployeeId = Convert.ToInt16(dr["EmployeeId"]);
                   if (dr["FirstName"] != DBNull.Value)
                       objEmployee.FirstName = Convert.ToString(dr["FirstName"]);
                   if (dr["LastName"] != DBNull.Value)
                       objEmployee.LastName = Convert.ToString(dr["LastName"]);
                   objListOneEmployee.Add(objEmployee);
               }
                ListOne=objListOneEmployee;
               dr.NextResult();
                while(dr.Read())
                {
                    objEmployee = new Employee();
                    if (dr["EmployeeId"] != DBNull.Value)
                        objEmployee.EmployeeId = Convert.ToInt16(dr["EmployeeId"]);
                    if (dr["FirstName"] != DBNull.Value)
                        objEmployee.FirstName = Convert.ToString(dr["FirstName"]);
                    if (dr["ManagerEmployeeId"] != DBNull.Value)
                        objEmployee.ManagerEmployeeId = Convert.ToInt16(dr["ManagerEmployeeId"]);
                    if (dr["ManagerName"] != DBNull.Value)
                        objEmployee.ManagerName = Convert.ToString(dr["ManagerName"]);
                    objListEmployee.Add(objEmployee);
                }
                
                 
            }
            return objListEmployee;
        }



Please help me I want to get like this in my drop down.if am logging in the drop down it should contain names who all are having my EmployeeID as their SupervisorID
1)User1--( User1 supervisor id will be My EmployeeId)
    1.1)user2--(user2's supervisor id will be  User1's EmployeeId )
        1.1.1)user3--(user3's supervisor id will be  User2's EmployeeId )
        1.1.2)user4--(user4's supervisor id will be  User2's EmployeeId )
              1.1.2.1)user5--(user5's supervisor id will be  User4's EmployeeId )
                     1.1.2.1.1)--(user6's supervisor id will be  User5's EmployeeId) 
2)user7--( User1 supervisor id will be My EmployeeId)

        2.1)user8--(user8's supervisor id will be  User7's EmployeeId )
            2.1.1)user9--(user3's supervisor id will be  User8's EmployeeId )
            2.1.2)user10--(user4's supervisor id will be  User8's EmployeeId )
3)user11--( User1 supervisor id will be My EmployeeId)
Posted
Updated 22-Apr-15 10:15am
v3
Comments
maya.r.shobana 21-Apr-15 5:07am    
I'm a beginner and am new to the linq concept.please correct me if i have gone wrong some where .i have got only two hierarchy from the above code which i have tried
Maciej Los 22-Apr-15 16:16pm    
Please, provide more details, such as the structure of the table and sample data...
maya.r.shobana 27-Apr-15 4:31am    
hi Maciej,
I got the tree structure of the employee hierarchy.I used asp:treeview control for binding the data in drop down.anyways thank you for the reply.

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900