Set role employee from favorite - D365

Set role employee from favorite - D365

Song Nghia - Technical Consultant

class SCA_SetRoleEmployeeDepentFavotite extends RunBaseBatch

{

    FilePath            filePath;
    Filename            filename;
    CommaTextIo         fileIO;
    Set                 fileSet;
    CommaIo             commaIo;
    str                 currentFile;
    container           lineCon;
    DialogField         fieldUserId;
    UserId              userId;
    UserInfo            userInfo;
    SCA_PrivilegesOfUser    privilegsOfUser;
    FromTime    startTime;
    str   elapsed;
    #AviFiles
    SysOperationProgress    progressor;
    int                     timeOfDayTmp;
    #OCCRetryCount
    #File
    #AviFiles
    #define.CurrentVersion(1)
    #localmacro.CurrentList
        userId
    #endmacro
    Public static void main(Args _args)
    {
        SCA_SetRoleEmployeeDepentFavotite    readFileData = SCA_SetRoleEmployeeDepentFavotite::construct();

        ;
        if (readFileData.prompt())
        {
            readFileData.run();
        }

    }

    public static SCA_SetRoleEmployeeDepentFavotite construct()
    {
        return new SCA_SetRoleEmployeeDepentFavotite();
    }


    public void run()
    {
        Name rolesName;
        startTime = timeNow();
        // Set Dialog field value to find CustTable
        if (userId)
        {

            this.getFavoriteItemOfEmployee(userId);

            rolesName = this.createRoleForUser(userId);

            if(rolesName)

                this.addRoleToUser(userId, rolesName);
            Info(strFmt("User Id: %1, Roles name: %2 completed", userId, rolesName));
        }

        else
        {
            error( 'Customer Account not found!');
        }

        elapsed = timeConsumed(startTime, timeNow());

        info(strFmt("Time run: %1", elapsed));
    }



    public boolean getFromDialog()

    {
        // Retrieve values from Dialog
        userId = fieldUserId.value();

        return super();
    }

    public Object dialog()
    {
        Dialog dialog;
        ;

        dialog = super();

        // Set a title for dialog

        dialog.caption( 'Create role for user');

        // Add a new field to Dialog

        fieldUserId = dialog.addField( extendedTypeStr(UserId), 'UserId' );

        return dialog;

    }



    public container pack()
    {
        return [#CurrentVersion, #CurrentList];

    }



    public boolean unpack(container _packedClass)
    {

        Version    version = RunBase::getVersion(_packedClass);

        switch (version)
        {

            case #CurrentVersion:

                [version,#CurrentList] = _packedClass;

                break;

            default:

                return false;
        }

        return true;
    }



    private void getAllMenuItemLoop(str _userId, str _menuItemName)
    {
        Name    privilegeName, grantType, grantAllow;

        [privilegeName, grantType,  grantAllow] =  this.findPrivileges(_menuItemName);

        if(privilegeName && grantType && grantAllow)
        {
            try
            {
                ttsbegin;

                if(!SCA_PrivilegesOfUser::find(_userId, privilegeName))

                {

                    privilegsOfUser.clear();

                    privilegsOfUser.UserId      =   _userId;

                    privilegsOfUser.Privilege   =   privilegeName;

                    privilegsOfUser.PrivilegeDescription    = strFmt("Privilege of user: %1", _userId);

                    privilegsOfUser.GrantType   =   grantType;

                    privilegsOfUser.GrantAllow  =   grantAllow;

                    privilegsOfUser.insert();
                }

                ttscommit;

                if(privilegeName && grantType && grantType)

                {
                        Info(strFmt("%1 %2 %3 ", privilegeName, grantType, grantAllow));

                }

            }

            catch
            {
                throw Error(strFmt("Cannot insert privilegs of user: %1", _userId ));

            }

        }

    }



    public  void getDisplayInForm(str displayName)
    {

        Form                myForm;
        FormBuildDesign     design;

        FormBuildControl    control;

        int                 cnt = 0;

        Set                 buttonsSet = new Set(Types::Class);

        Args                args;

        Object              _Object;

        FormControl         _FormControl;

        FormMenuButtonControl _buttonControl;

        FormBuildFunctionButtonControl  _menuButton;

        Name    privilegeName, grantType, grantAllow;



        void findButtons(FormBuildControl _buildControl)
        {

            FormBuildControl    buildControl;

            int                 i;

            ;

            if (_buildControl.controlCount() > 0)

            {
                for (i = 1; i <= _buildControl.controlCount(); i++)

                {
                    try
                    {
                        _menuButton = _buildControl.controlNum(i);

                        if(_menuButton.menuItemType() == MenuItemType::Display)

                        {

                            //info(_menuButton.menuItemName());

                            [privilegeName, grantType,  grantAllow] =  this.findPrivileges(_menuButton.menuItemName());

                            if(privilegeName && grantType && grantAllow)
                            {
                                try
                                {
                                    ttsbegin;

                                    if(!SCA_PrivilegesOfUser::find(userId, privilegeName))

                                    {

                                        privilegsOfUser.clear();

                                        privilegsOfUser.UserId      =   userId;

                                        privilegsOfUser.Privilege   =   privilegeName;

                                        privilegsOfUser.PrivilegeDescription    = strFmt("Privilege of user: %1", userId);

                                        privilegsOfUser.GrantType   =   grantType;

                                        privilegsOfUser.GrantAllow  =   grantAllow;

                                        privilegsOfUser.insert();

                                    }

                                    ttscommit;

                                    if(privilegeName && grantType && grantType)
                                    {
                                        progressor.setText(strFmt("%1 %2 %3 ", privilegeName, grantType, grantAllow));

                                        progressor.incCount();

                                        progressor.update(false);

                                        //Info(strFmt("%1 %2 %3 ", privilegeName, grantType, grantAllow));
                                    }

                                }

                                catch
                                {
                                    throw Error(strFmt("Cannot insert privilegs of user: %1", userId ));

                                }

                            }

                        }

                    }

                    catch

                    {



                    }

                    buildControl = _buildControl.controlNum(i);



                    findButtons(buildControl);

                }

            }
            else
            {
                if (classidget(_buildControl) == classnum(FormBuildButtonControl) ||

                    classidget(_buildControl) == classnum(FormBuildCommandButtonControl) ||

                    classidget(_buildControl) == classnum(FormBuildDropDialogButtonControl) ||

                    classidget(_buildControl) == classnum(FormBuildMenuButtonControl) ||

                    classidget(_buildControl) == classnum(FormBuildFunctionButtonControl))

                {
                    buttonsSet.add(_buildControl);

                }

            }

        }

        ;



        myForm = new Form(displayName);

        design = myForm.design();



        for (cnt = 1; cnt <= design.controlCount(); cnt++)
        {
            try

            {
                _menuButton =  design.controlNum(cnt).controlNum(cnt);

                if(_menuButton.menuItemType() == MenuItemType::Display)
                {
                    info(_menuButton.menuItemName());

                    [privilegeName, grantType,  grantAllow] =  this.findPrivileges(_menuButton.menuItemName());

                    if(privilegeName && grantType && grantAllow)
                    {
                        try
                        {
                            ttsbegin;

                            if(!SCA_PrivilegesOfUser::find(userId, privilegeName))
                            {
                                privilegsOfUser.clear();

                                privilegsOfUser.UserId      =   userId;

                                privilegsOfUser.Privilege   =   privilegeName;

                                privilegsOfUser.PrivilegeDescription    = strFmt("Privilege of user: %1", userId);

                                privilegsOfUser.GrantType   =   grantType;

                                privilegsOfUser.GrantAllow  =   grantAllow;

                                privilegsOfUser.insert();

                            }

                            ttscommit;

                            if(privilegeName && grantType && grantType)

                        Info(strFmt("%1 %2 %3 ", privilegeName, grantType, grantAllow));

                        }

                        catch

                        {
                            throw Error(strFmt("Cannot insert privilegs of user: %1", userId ));

                        }

                    }

                }

            }

            catch

            {



            }



            control = design.controlNum(cnt);

            findButtons(control);

        }

    }



    //Cho nay lay dc form name = > buoc thiep theo lay dc cai menuitem name

    public void  findMenuItem(str _menuItemName)
    {
        #AOT

        TreeNode root = TreeNode::findNode(#MenuItemsDisplayPath);

        TreeNode current;

        TreeNodeTraverser trav = new TreeNodeTraverser(root,false);

        current = trav.next();

        while (current)
        {

            if ((current.AOTgetProperty('ObjectType') == "Form") && (current.AOTgetProperty('Name') == _menuItemName))
            {

                info(strFmt("Menu Item inside display form %1",current.AOTgetProperty('Object')));

                this.getDisplayInForm(current.AOTgetProperty('Object'));

            }

            current = trav.next();

        }

    }



    private void getFavoriteItemOfEmployee(UserId _userId)
    {

        SysMenuNavigationFavoriteItemsTable favoriteTable;

        Name    privilegeName, grantType, grantAllow;

        // Define XML Document and its nodes

        XmlDocument     doc;

        Name            privilegesName;

        XmlElement      elementScript,

                        elementName;

        XMLParseError   xmlError;

        int             i;



        while select favoriteTable
            where favoriteTable.UserId == _userId

        {
            progressor = SysOperationProgress::newGeneral(#AviFileMove, "Processing...", 2500);

            progressor.setCaption("@SYS8577");

            progressor.setCaption(strFmt("Processing .. %1", favoriteTable.MenuItemName));

            [privilegeName, grantType,  grantAllow] =  this.findPrivileges(favoriteTable.MenuItemName);

            if(privilegeName && grantType && grantAllow)

            {

                try

                {

                    ttsbegin;

                    if(!SCA_PrivilegesOfUser::find(_userId, privilegeName))
                    {
                        privilegsOfUser.clear();

                        privilegsOfUser.UserId      =   _userId;

                        privilegsOfUser.Privilege   =   privilegeName;

                        privilegsOfUser.PrivilegeDescription    = strFmt("Privilege of user: %1", _userId);

                        privilegsOfUser.GrantType   =   grantType;

                        privilegsOfUser.GrantAllow  =   grantAllow;

                        privilegsOfUser.insert();

                    }

                    ttscommit;

                    if(privilegeName && grantType && grantType)
                    {
                        progressor.setText(strFmt("%1 %2 %3 ", privilegeName, grantType, grantAllow));

                        progressor.incCount();

                        progressor.update(false);

                    }

                }

                catch

                {

                    throw Error(strFmt("Cannot insert privilegs of user: %1", _userId ));

                }

            }



            this.findMenuItem(favoriteTable.MenuItemName);

        }



    }



    private container findPrivileges(Name _objectName)

    {

        System.IO.StreamReader reader;

        System.String stringLine;

        InteropPermission interopPermission;

        str file;

        int row = 1;

        int currentFileCount;

        str stringFile;



        container   conResult;

        Name        privilegesName, grantName, grantAllow;



        System.String[] filePaths = System.IO.Directory::GetFiles(@"C:\AOSService\PackagesLocalDirectory\", "*.xml*",System.IO.SearchOption::AllDirectories);



        int fileCount = filepaths.get_Length();



        for(currentFileCount = 0; currentFileCount < fileCount ; ++currentFileCount)
        {
            file = filepaths.GetValue(currentFileCount).ToString();

            if(strScan(file, "AxSecurityPrivilege", 0, strLen(file)) || strScan(file, "axsecurityprivilege", 0, strLen(file)) )
            {

                reader = new System.IO.StreamReader(file);

                stringLine = reader.ReadLine();

                stringFile = "";

                while (!System.String::IsNullOrEmpty(stringLine))
                {

                    stringFile += stringLine;

                    stringLine = reader.ReadLine();

                }

                //Get privilegs of meuitem display

                conResult = this.getXML(stringFile, _objectName);

              

                //get all source in fom dc goi toi



                if(conPeek(conResult, 1))
                {

                    return conResult;
                }

                reader.Close();

                reader.Dispose();

                CodeAccessPermission::revertAssert();

            }

        }



        return conResult;

    }



    /// 

    /// Find privilege from object Type and object name

    /// 

    /// 

    /// 

    private container getXML(str strXML, str objectName)
    {
        // Define XML Document and its nodes

        XmlDocument     doc;

        XmlNodeList     vtvNodeList;

        XmlNode         vtvNode;

        Name            privilegesName;

        str             grantAllow;

        //Nguyen doan script

        XmlElement      elementScript,

                        elementName,

                        elementEntryPoints,

                        elementEntryPointsRef,

                        elementRefGrant, elementGrantDetail;

        XmlElement      elementTemp;

        XMLParseError   xmlError;

        int             i ;



        try
        {
            doc = new XmlDocument();

            doc.loadXml(strXML);

            elementScript           = doc.getNamedElement("AxSecurityPrivilege");

            elementName             = elementScript.getNamedElement("Name");

            elementEntryPoints      = elementScript.getNamedElement("EntryPoints");

            vtvNodeList             = elementEntryPoints.childNodes();

            for(i = 0; i < vtvNodeList.length() ; i++ )

            {

                //Doan nay phia loop data ben trong, moi get het duoc

                //elementEntryPointsRef   = elementEntryPoints.getNamedElement//("AxSecurityEntryPointReference");

                elementEntryPointsRef      = vtvNodeList.item(i);

                elementRefGrant       = elementEntryPointsRef.getNamedElement("Grant");

      

                //Get quyen cao nhat cua privileges

                if(elementRefGrant.getNamedElement("Delete") && elementRefGrant.getNamedElement("Delete").text() == "Allow")

                {

                    if(elementEntryPointsRef.getNamedElement("ObjectName").text() == objectName)

                    {

                        return [elementName.text() ,

                            elementRefGrant.getNamedElement("Delete").name(),

                            elementRefGrant.getNamedElement("Delete").text()];

                    }

                }
                //else get read
                else
                {
                    if(elementRefGrant.getNamedElement("Read") && elementRefGrant.getNamedElement("Read").text() == "Allow")
                    {
                        if(elementEntryPointsRef.getNamedElement("ObjectName").text() == objectName)
                        {

                            return [elementName.text() ,

                            elementRefGrant.getNamedElement("Read").name(),

                            elementRefGrant.getNamedElement("Read").text()];

                        }

                    }

                }

            }

          

        }

        catch

        {

            return conNull();

        }



        return conNull();

    }



    private Name createRoleForUser(UserId _userId)
    {

        FileIoPermission    permission;

        XMLDocument         xmlDoc = XMLDocument::newBlank();

        XMLNode             rootNode;

        XMLNode             NodeEmpl,

                            NodeName,

                            NodeDescript,

                            NodeLabel,

                            NodeDirectAccess,

                            NodeDuty,

                            NodePrivileges,

                            NodeNamePri;

        XMLElement          xmlElement;

        XMLText             xmlText;

        HCMWorker           HCMWorker;

        Name                fileRoleName;

        FilePath            linkFile;

        SCA_PrivilegesOfUser    privilegesOfUser;

        ;

        fileRoleName = strFmt("SCA_%1_%2_Maintain", _userId, System.DateTime::get_UtcNow().ToString('yyyyMdHHmmss'));

        linkFile = @'C:\AOSService\PackagesLocalDirectory\Scancom\Scancom\AxSecurityRole\' + fileRoleName + ".xml";

        try
        {
            permission= new FileIoPermission(linkFile,'w');

            permission.assert();

            xmlDoc = XMLDocument::newBlank();

            // Create first line containing version info

            rootNode = xmlDoc.documentElement();

            xmlElement = xmlDoc.createElement('AxSecurityRole');

            rootNode = xmlDoc.appendChild(xmlElement);



            // Create a node for the name

            xmlElement  = xmlDoc.createElement('Name');

            NodeName    = rootNode.appendChild(xmlElement);

            xmlText     = xmlDoc.createTextNode(fileRoleName);

            NodeName.appendChild(xmlText);



            xmlElement  = xmlDoc.createElement('Description');

            NodeDescript    = rootNode.appendChild(xmlElement);

            xmlText     = xmlDoc.createTextNode("Description of role");

            NodeDescript.appendChild(xmlText);

  

            xmlElement  = xmlDoc.createElement("Label");

            NodeLabel    = rootNode.appendChild(xmlElement);

            xmlText     = xmlDoc.createTextNode("Label of role");

            NodeLabel.appendChild(xmlText);

  

            xmlElement  = xmlDoc.createElement('Privileges');

            NodeName    = rootNode.appendChild(xmlElement);

            while select privilegesOfUser

                where privilegesOfUser.UserId == _userId

            {

                // Create a node for the address

                xmlElement  = xmlDoc.createElement('AxSecurityPrivilegeReference');

                NodePrivileges    = NodeName.appendChild(xmlElement);



                xmlElement  = xmlDoc.createElement('Name');

                xmlText     = xmlDoc.createTextNode(privilegesOfUser.Privilege);

                NodeNamePri   = NodePrivileges.appendChild(xmlElement);

                NodeNamePri.appendChild(xmlText);



            }

            // Save the file

            xmldoc.save(linkFile);

            return fileRoleName;

        }

        catch

        {

            throw Error("Create role error");

        }



    }



    private void addRoleToUser(UserId _userId, Name _roleName)
    {

        SecurityRole        role;

        SecurityUserRole    userRole;



        //Synchonice table sercurity role before insert data

        appl.dbSynchronize(tableNum("SecurityRole"));



        select role where role.AotName == _roleName;



        select * from userRole

            where userRole.SecurityRole == role.RecId &&

            userRole.User == _userId;



        userRole.User = _userId;

        userRole.SecurityRole = role.RecId;

        userRole.AssignmentMode = RoleAssignmentMode::Manual;

        userRole.AssignmentStatus = RoleAssignmentStatus::Enabled;



        SecuritySegregationOfDuties::assignUserToRole(userRole, null);



        //Synchonice table sercurity

        appl.dbSynchronize(tableNum("SecurityUserRole"));

    }



    private void getFiles()

    {

        System.String[]                 files;

        System.Collections.IEnumerator  enumerator;

        str file;



        try

        {

            fileSet = new Set(Types::Container);

            files = System.IO.Directory::GetFiles(filePath, '*.xml');

            enumerator = files.GetEnumerator();

            while(enumerator.MoveNext())

            {

                file = enumerator.get_Current();

                fileSet.add([file]);

            }

        }

        catch(Exception::Internal)

        {

            this.processCLRErrorException();

        }

        catch(Exception::CLRError)

        {

            this.processCLRErrorException();

        }

    }



    private void openFile()

    {

        FileIOPermission fileIOPermission;

        fileIOPermission = new FileIOPermission(filename, #io_read);

        fileIOPermission.assert();



        commaIo = new CommaIo(filename, #io_read);



        if(commaIo && commaIo.status() == IO_Status::Ok)

        {

            commaIo.inRecordDelimiter(#delimiterCRLF);

        }

        else

        {

            throw error(strFmt("Error when opening file %1", filename));

        }

    }



    private boolean readLine()

    {

        boolean readLine;

        if(commaIo && commaIo.status() == IO_Status::Ok)

        {

            lineCon = commaIo.read();

            readLine = lineCon != conNull();

        }

        else

        {

            lineCon = conNull();

            readLine = false;

        }

        return readLine;

    }



    private void processCLRErrorException( boolean _throw = true )

    {

        str strError;

        CLRObject exc;

        CLRObject innerExc;

        CLRObject clrExcMessage;

        exc = CLRInterop::getLastException();

        if(exc)

        {

            clrExcMessage = exc.get_Message();

            innerExc = exc.get_InnerException();

            while(innerExc != null)

            {

                clrExcMessage = innerExc.get_Message();

                innerExc = innerExc.get_InnerException();

            }

            strError = CLRInterop::getAnyTypeForObject(clrExcMessage);

            error(strError);

            if (_throw)

            {

                throw error("Update has been cancelled");

            }

        }

    }
}
Previous Post
Next Post

post written by: