Create a new validate method on the standard table

-

 Today we have a requirement to create a new validate method on the standard table level so below are the example


[ExtensionOf(tableStr(EntAssetWorkOrderLifecycleState))]

final class IHSEntAssetWorkOrderLifecycleStateDbt_Extension

{

    /// <summary>

    ///    Checks whether the instal location enable or not.

    /// </summary>

    /// <param name="_custAccount">

    ///    The <c>_custAccount</c> value that specifies the customer account.

    /// </param>

    /// <returns>

    ///    true if the transactions exist for that customer Account; otherwise, false.

    /// </returns>

    static boolean ihsExistAssetLocation(NoYesId _installAssetLocation)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select firstonly RecId from workOrderLifecycleState

            where workOrderLifecycleState.IHSAutoInstallAssetLocation == _installAssetLocation;


        return (workOrderLifecycleState.RecId != 0);

    }

========================================================================

    static boolean ihsExistAuctionPlan(NoYesId _auctionPlan)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select firstonly RecId from workOrderLifecycleState

            where workOrderLifecycleState.IHSEnableAuctionPlan == _auctionPlan;


        return (workOrderLifecycleState.RecId != 0);

    }

=========================================================================

    static boolean ihsExistEWasteManagement(NoYesId _ewasteManagement)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select firstonly RecId from workOrderLifecycleState

            where workOrderLifecycleState.IHSEnableEWasteManagement == _ewasteManagement;


        return (workOrderLifecycleState.RecId != 0);

    }

==========================================================================

    static EntAssetWorkOrderLifecycleState ihsFindByAssetLocation(NoYesId _installAssetLocation)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select *  from workOrderLifecycleState

            where workOrderLifecycleState.IHSAutoInstallAssetLocation == _installAssetLocation;


        return workOrderLifecycleState;

    }

=====================================================================

    static EntAssetWorkOrderLifecycleState ihsFindByAuctionPlan(NoYesId _auctionPlan)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select *  from workOrderLifecycleState

            where workOrderLifecycleState.IHSEnableAuctionPlan == _auctionPlan;


        return workOrderLifecycleState;

    }

=====================================================================

    static EntAssetWorkOrderLifecycleState ihsFindByEWasteManagement(NoYesId _ewasteManagement)

    {

        EntAssetWorkOrderLifecycleState workOrderLifecycleState;


        select *  from workOrderLifecycleState

            where workOrderLifecycleState.IHSEnableEWasteManagement == _ewasteManagement;


        return workOrderLifecycleState;

    }

======================================================================

    public boolean validateField(FieldId _fieldIdToCheck)

    {

        boolean ret;


        ret = next validateField(_fieldIdToCheck);


        if (ret && _fieldIdToCHeck == fieldNum(EntAssetWorkOrderLifecycleState, IHSAutoInstallAssetLocation) && this.IHSAutoInstallAssetLocation)

        {

            ret = ret && this.ihsValidateWorkOrderId();

        }


        if (ret && _fieldIdToCHeck == fieldNum(EntAssetWorkOrderLifecycleState, IHSEnableAuctionPlan) && this.IHSEnableAuctionPlan)

        {

            ret = ret && this.ihsValidateAuctionPlan();

        }


        if (ret && _fieldIdToCHeck == fieldNum(EntAssetWorkOrderLifecycleState, IHSEnableEWasteManagement) && this.IHSEnableEWasteManagement)

        {

            ret = ret && this.ihsValidateEWasteManagement();

        }


        return ret;

    }

======================================================================

    public boolean ihsValidateWorkOrderId()

    {

        boolean                         ret = true;


        if(EntAssetWorkOrderLifecycleState::ihsExistAssetLocation(this.IHSAutoInstallAssetLocation))

        {

            EntAssetWorkOrderLifecycleState EntAssetWorkOrderLifecycleStateloc = EntAssetWorkOrderLifecycleState::ihsFindByAssetLocation(NoYes::Yes);


            ret = checkFailed(strFmt("Parameter already enabled for %1 state", EntAssetWorkOrderLifecycleStateloc.WorkOrderLifecycleStateId));

        }

        return ret;

    }

==============================================================================

    public boolean ihsValidateAuctionPlan()

    {

        boolean                         ret = true;


        if(EntAssetWorkOrderLifecycleState::ihsExistAuctionPlan(this.IHSEnableAuctionPlan))

        {

            EntAssetWorkOrderLifecycleState EntAssetWorkOrderLifecycleStateloc = EntAssetWorkOrderLifecycleState::ihsFindByAuctionPlan(NoYes::Yes);


            ret = checkFailed(strFmt("Parameter already enabled for %1 state", EntAssetWorkOrderLifecycleStateloc.WorkOrderLifecycleStateId));

        }

        return ret;

    }

========================================================================

    public boolean ihsValidateEWasteManagement()

    {

        boolean                         ret = true;


        if(EntAssetWorkOrderLifecycleState::ihsExistEWasteManagement(this.IHSEnableEWasteManagement))

        {

            EntAssetWorkOrderLifecycleState EntAssetWorkOrderLifecycleStateloc = EntAssetWorkOrderLifecycleState::ihsFindByEWasteManagement(NoYes::Yes);


            ret = checkFailed(strFmt("Parameter already enabled for %1 state", EntAssetWorkOrderLifecycleStateloc.WorkOrderLifecycleStateId));

        }

        return ret;

    }


}

Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more