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);
}
}
}
}
