public UserAccessRightsCollec Get(long RoleID) { UserAccessRightsCollec objCollec = new UserAccessRightsCollec(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@UserRoleID", RoleID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_UserAccessRights_By_USERROLE", paramList); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { UserAccessRights obj = new UserAccessRights(); obj.MenuID = Convert.ToString(dt.Rows[i]["Menu_ID"]); obj.MenuName = Convert.ToString(dt.Rows[i]["Menu_Item"]); obj.Permission = Convert.ToString(dt.Rows[i]["Access_Permission"]); obj.UserRoleID = Convert.ToInt64(dt.Rows[i]["UserRoleID"]); objCollec.Add(obj); } } return(objCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void LoadTree(long RoleID) { UserAccessRightsCollec objCollec = new UserAccessRightsCollec(); objCollec = objUserAccessRightsDL.Get(RoleID); foreach (UserAccessRights obj in objCollec) { if (treeView1.Nodes.Count > 0) { for (int i = 0; i < treeView1.Nodes.Count; i++) { LoadNode(treeView1.Nodes[i], obj); } } } }