public static UserProfile GetUserProfileByUserID(string employeeNO) { DataTable dtUser = GetDataSet.GetUesrProfileByUserID(employeeNO); UserProfile user = new UserProfile(); user.ID = dtUser.Rows[0]["ID"].ToString(); user.Name = dtUser.Rows[0]["name"].ToString(); user.EmployeeNO = dtUser.Rows[0]["employeeno"].ToString(); user.isBranchLeader = dtUser.Rows[0]["isBranchLeader"].ToString() == "1"; user.isExternal = dtUser.Rows[0]["isExternal"].ToString() == "1"; user.toRegularDate = Convert.ToDateTime(dtUser.Rows[0]["toRegularDate"]); List <Menu> lstMenu = new List <Menu>(); Menu menu = new Menu(); int dtUserRowsCount = dtUser.Rows.Count; for (int i = 0; i < dtUserRowsCount; i++) { menu = new Menu(); menu.Name = dtUser.Rows[i]["MENUNAME"].ToString(); menu.Path = dtUser.Rows[i]["MENUPATH"].ToString(); menu.ParentID = dtUser.Rows[i]["PARENTID"].ToString(); menu.Remarks = dtUser.Rows[i]["REMARKS"].ToString(); menu.Available = Convert.ToBoolean(dtUser.Rows[i]["Available"]); lstMenu.Add(menu); } user.Menu = lstMenu; List <Role> lstRole = new List <Role>(); Role role = new Role(); for (int i = 0; i < dtUserRowsCount; i++) { role = new Role(); role.RoleID = dtUser.Rows[i]["roleID"].ToString(); role.RoleName = dtUser.Rows[i]["roleName"].ToString(); lstRole.Add(role); } user.Role = lstRole; return(user); }