Page 5384 CDS New Man. Int. Table Wizard

Base Application, Microsoft.Integration.SyncEngine

src/Layers/W1/BaseApp/Integration/Dataverse/CDSNewManIntTableWizard.Page.al656 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.SyncEngine;using Microsoft.Integration.Dataverse;using System.Environment;using System.Reflection;using System.Utilities;page 5384 "CDS New Man. Int. Table Wizard"{    ApplicationArea = All;    Caption = 'Create New Integration Mappings';    PageType = NavigatePage;    SourceTable = "Man. Integration Table Mapping";    layout    {        area(content)        {            group(StandardBanner)            {                ShowCaption = false;                Editable = false;                Visible = TopBannerVisible and not FinishActionEnabled;                field(MediaResourcesStandard; MediaResourcesStandard."Media Reference")                {                    Editable = false;                    ShowCaption = false;                }            }            group(FinishedBanner)            {                ShowCaption = false;                Editable = false;                Visible = TopBannerVisible and FinishActionEnabled;                field(MediaResourcesDone; MediaResourcesDone."Media Reference")                {                    Editable = false;                    ShowCaption = false;                }            }            group(Step1)            {                Visible = Step1Visible;                group(Control0)                {                    InstructionalText = 'Choose the tables and fields to set up a new integration mapping.';                    Visible = Step1Visible;                    ShowCaption = false;                }                group(ChooseName)                {                    Caption = 'Enter the name of the new integration table mapping.';                    field(Name; IntegrationMappingName)                    {                        Caption = 'Integration Table Mapping Name';                        ToolTip = 'Specifies the name of the new integration table mapping.';                        ShowMandatory = true;                        trigger OnValidate()                        var                            IntegrationTableMapping: Record "Integration Table Mapping";#pragma warning disable AA0470                            IntegrationMappingNameExistErr: Label 'Integration table name %1 already exists. Please specify a different name';#pragma warning restore AA0470                        begin                            IntegrationTableMapping.SetRange(Name, IntegrationMappingName);                            if not IntegrationTableMapping.IsEmpty then                                Error(IntegrationMappingNameExistErr, IntegrationMappingName);                        end;                    }                }                group(whatisnext)                {                    ShowCaption = false;                    InstructionalText = 'To specify details for the new integration table mapping, choose Next.';                }            }            group(Step2)            {                Caption = 'Choose the table and integration table for the mapping.';                Visible = Step2Visible;                field(TableId; IntegrationMappingTableIdValue)                {                    AssistEdit = true;                    Caption = 'Table';                    Editable = false;                    ToolTip = 'Specifies the name of the Business Central table to map to the integration table.';                    ShowMandatory = true;                    trigger OnAssistEdit()                    var                        TableMetadata: Record "Table Metadata";                        IntegrationTableMapping: Record "Integration Table Mapping";                        TableFilterTxt: Text;                    begin                        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);                        if IntegrationTableMapping.FindSet() then                            repeat                                if TableFilterTxt = '' then                                    TableFilterTxt := '<>' + Format(IntegrationTableMapping."Table ID")                                else                                    TableFilterTxt += '&<>' + Format(IntegrationTableMapping."Table ID");                            until IntegrationTableMapping.Next() = 0;                        TableMetadata.SetRange(TableType, TableMetadata.TableType::Normal);                        TableMetadata.SetRange(ObsoleteState, TableMetadata.ObsoleteState::No);                        TableMetadata.SetFilter(TableMetadata.ID, TableFilterTxt);                        if Page.RunModal(Page::"Available Table Selection List", TableMetadata) = Action::LookupOK then begin                            IntegrationMappingTableId := TableMetadata.ID;                            IntegrationMappingTableIdValue := TableMetadata.Caption;                        end;                    end;                }                field(IntegrationTableID; IntegrationMappingIntTableIdValue)                {                    AssistEdit = true;                    Caption = 'Integration Table';                    Editable = false;                    ToolTip = 'Specifies the name of the integration table to map to the Business Central table.';                    ShowMandatory = true;                    trigger OnAssistEdit()                    var                        TableMetadata: Record "Table Metadata";                        IntegrationTableMapping: Record "Integration Table Mapping";                        TableFilterTxt: Text;                    begin                        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);                        if IntegrationTableMapping.FindSet() then                            repeat                                if TableFilterTxt = '' then                                    TableFilterTxt := '<>' + Format(IntegrationTableMapping."Integration Table ID")                                else                                    TableFilterTxt += '&<>' + Format(IntegrationTableMapping."Integration Table ID");                            until IntegrationTableMapping.Next() = 0;                        TableMetadata.SetRange(TableType, TableMetadata.TableType::CRM);                        TableMetadata.SetRange(ObsoleteState, TableMetadata.ObsoleteState::No);                        TableMetadata.SetFilter(TableMetadata.ID, TableFilterTxt);                        if Page.RunModal(Page::"Available Table Selection List", TableMetadata) = Action::LookupOK then begin                            IntegrationMappingIntTableId := TableMetadata.ID;                            IntegrationMappingIntTableIdValue := TableMetadata.Caption;                        end;                    end;                }                field(IntegrationTableUID; IntegrationTableUIDValue)                {                    AssistEdit = true;                    Caption = 'Integration Table Unique Identifier Field Name';                    Editable = false;                    ToolTip = 'Specifies the caption of the unique identifier field in the integration table.';                    ShowMandatory = true;                    trigger OnAssistEdit()                    var                        "Field": Record "Field";                        FieldSelection: Codeunit "Field Selection";                    begin                        Field.SetRange(TableNo, IntegrationMappingIntTableId);                        Field.SetRange(Type, Field.Type::GUID);                        if FieldSelection.Open(Field) then begin                            IntegrationTableUID := Field."No.";                            IntegrationTableUIDValue := Field."Field Caption";                        end;                    end;                }                field(IntTblModifiedOnId; IntTblModifiedOnIdValue)                {                    AssistEdit = true;                    Caption = 'Integration Table Modified On Field Name';                    Editable = false;                    ToolTip = 'Specifies the name of the field that shows when the integration table was last modified.';                    ShowMandatory = true;                    trigger OnAssistEdit()                    var                        Field: Record "Field";                        FieldSelection: Codeunit "Field Selection";                    begin                        Field.SetRange(TableNo, IntegrationMappingIntTableId);                        Field.SetRange(Type, Field.Type::DateTime);                        if FieldSelection.Open(Field) then begin                            IntTblModifiedOnId := Field."No.";                            IntTblModifiedOnIdValue := Field."Field Caption"                        end;                    end;                }                field(SyncOnlyCoupledRecords; SyncOnlyCoupledRecords)                {                    Caption = 'Sync Only Coupled Records';                    ToolTip = 'Specifies if the synchronization engine will process only currently coupled records or couple the newly created records as well.';                }                field(Direction; Direction)                {                    Caption = 'Direction';                    ToolTip = 'Specifies the synchronization direction.';                    OptionCaption = 'Bidirectional,ToIntegrationTable,FromIntegrationTable';                }                group(advanced)                {                    Caption = 'Advanced';                    Visible = AdvancedVisible;                    field(TableFilterValue; TableFilter)                    {                        Caption = 'Table Filter';                        Editable = false;                        ToolTip = 'Specifies the synchronization inclusion filter on the Business Central table. Records that fall outside this filter are not synchronized.';                        trigger OnAssistEdit()                        var                            FilterPageBuilder: FilterPageBuilder;                        begin                            FilterPageBuilder.AddTable(IntegrationMappingTableIdValue, IntegrationMappingTableId);                            if TableFilter <> '' then                                FilterPageBuilder.SetView(IntegrationMappingTableIdValue, TableFilter);                            if FilterPageBuilder.RunModal() then                                TableFilter := FilterPageBuilder.GetView(IntegrationMappingTableIdValue, false);                        end;                    }                    field(IntegrationTableFilterValue; IntegrationTableFilter)                    {                        Caption = 'Integration Table Filter';                        Editable = false;                        ToolTip = 'Specifies the synchronization inclusion filter on the table in the system you are integrating with. Records that fall outside this filter are not synchronized.';                        trigger OnAssistEdit()                        var                            IntegrationTableMapping: Record "Integration Table Mapping";                            FilterPageBuilder: FilterPageBuilder;                        begin                            Codeunit.Run(Codeunit::"CRM Integration Management");                            FilterPageBuilder.AddTable(IntegrationMappingIntTableIdValue, IntegrationMappingIntTableId);                            if IntegrationTableFilter <> '' then                                FilterPageBuilder.SetView(IntegrationMappingIntTableIdValue, IntegrationTableFilter);                            Commit();                            if FilterPageBuilder.RunModal() then begin                                IntegrationTableFilter := FilterPageBuilder.GetView(IntegrationMappingIntTableIdValue, false);                                IntegrationTableMapping.SuggestToIncludeEntitiesWithNullCompany(IntegrationTableFilter);                            end;                        end;                    }                    field("Table Config Templates"; TableConfigTemplates)                    {                        Caption = 'Table Config Templates';                        ToolTip = 'Specifies configuration templates to use when creating new records in the Business Central table (specified by the Table ID field) during synchronization.';                        Editable = false;                        trigger OnAssistEdit()                        var                            TableConfigTemplate: Record "Table Config Template";                            TableConfigTemplates: Page "Table Config Templates";                        begin                            TableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationMappingName);                            TableConfigTemplates.SetTableView(TableConfigTemplate);                            TableConfigTemplates.RunModal();                            SetConfigTemplateValues();                        end;                    }                    field("Int. Table Config Templates"; IntTableConfigTemplates)                    {                        Caption = 'Integration Table Config Templates';                        ToolTip = 'Specifies configuration templates to use for creating new records in the integration table.';                        Editable = false;                        trigger OnAssistEdit()                        var                            IntTableConfigTemplate: Record "Int. Table Config Template";                            IntTableConfigTemplates: Page "Int. Table Config Templates";                        begin                            IntTableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationMappingName);                            IntTableConfigTemplates.SetTableView(IntTableConfigTemplate);                            IntTableConfigTemplates.RunModal();                            SetConfigTemplateValues();                        end;                    }                }                group(whatisnextField)                {                    ShowCaption = false;                    InstructionalText = 'To specify details for the new integration field mappings, choose Next.';                }            }            group(Step3)            {                Visible = Step3Visible;                group(Group23)                {                    ShowCaption = false;                    InstructionalText = 'Choose the fields for the new integration table mapping.';                    part(ManIntFieldMappingList; "Man. Int. Field Mapping Wizard")                    {                    }                }            }            group(Step4)            {                Visible = Step4Visible;                group(Group24)                {                    Caption = 'You''re almost done.';                    InstructionalText = 'Choose Finish to do the following:';                }                group(Group25)                {                    ShowCaption = false;                    InstructionalText = 'Create new integration table and field mappings.';                }                group(Group26)                {                    ShowCaption = false;                    InstructionalText = 'Insert new integration fields mappings with the status Disabled.';                }                group(Group27)                {                    ShowCaption = false;                    Visible = not SetupExistingIntegrationMapping;                    InstructionalText = 'Create a Synchronization Job Queue Entry with the status On hold.';                }                group(Group28)                {                    ShowCaption = false;                    Visible = SetupExistingIntegrationMapping;                    InstructionalText = 'To update existing data, choose Run Unconditional Full Synchronization on the Integration Table Mappings page. This action will synchronize data from the new field mappings you just added.';                }            }        }    }    actions    {        area(processing)        {            action(ActionAdvanced)            {                ApplicationArea = All;                Caption = 'Advanced';                Enabled = Step2Visible;                Image = ExpandAll;                InFooterBar = true;                trigger OnAction();                begin                    if AdvancedVisible then                        AdvancedVisible := false                    else                        AdvancedVisible := true;                    CurrPage.Update();                end;            }            action(ActionBack)            {                ApplicationArea = All;                Caption = 'Back';                Enabled = BackActionEnabled;                Image = PreviousRecord;                InFooterBar = true;                trigger OnAction();                begin                    NextStep(true);                end;            }            action(ActionNext)            {                ApplicationArea = All;                Caption = 'Next';                Enabled = NextActionEnabled;                Image = NextRecord;                InFooterBar = true;                trigger OnAction();                begin                    NextStep(false);                end;            }            action(ActionFinish)            {                ApplicationArea = All;                Caption = 'Finish';                Enabled = FinishActionEnabled;                Image = Approve;                InFooterBar = true;                trigger OnAction();                begin                    FinishAction();                end;            }        }    }    trigger OnInit();    begin        LoadTopBanners();    end;    trigger OnOpenPage();    begin        if not SetupExistingIntegrationMapping then            Step := Step::Start        else            Step := Step::Step3;        EnableControls();    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    begin        if Step <> Step::Closed then            if not Confirm(CloseWizardLbl, false) then                exit(false)            else                DeleteConfigTemplates();    end;    trigger OnClosePage()    begin        if FailedFields then            Message(FailedFieldsNotificationLbl);    end;    var        MediaRepositoryDone: Record "Media Repository";        MediaRepositoryStandard: Record "Media Repository";        MediaResourcesDone: Record "Media Resources";        MediaResourcesStandard: Record "Media Resources";        Step: Option Start,Step2,Step3,Finish,Closed;        BackActionEnabled: Boolean;        FinishActionEnabled: Boolean;        NextActionEnabled: Boolean;        Step1Visible: Boolean;        Step2Visible: Boolean;        Step3Visible: Boolean;        Step4Visible: Boolean;        TopBannerVisible: Boolean;        SyncOnlyCoupledRecords: Boolean;        SetupExistingIntegrationMapping: Boolean;        AdvancedVisible: Boolean;        FailedFields: Boolean;        IntegrationMappingName: Code[20];        TableConfigTemplates: Text;        IntTableConfigTemplates: Text;        IntegrationMappingTableId: Integer;        IntegrationMappingIntTableId: Integer;        IntegrationTableUID: Integer;        IntTblModifiedOnId: Integer;        IntegrationMappingTableIdValue: Text[80];        IntegrationMappingIntTableIdValue: Text[80];        IntegrationTableUIDValue: Text[80];        IntTblModifiedOnIdValue: Text[80];        TableFilter: Text;        IntegrationTableFilter: Text;        Direction: Option;        CategoryTok: Label 'AL Dataverse Integration', Locked = true;        FillinMandatoryFieldsLbl: Label 'Please fill in all the mandatory fields.';        CloseWizardLbl: Label 'Data is not saved.\\Are you sure that you want to exit?';        FailedFieldsNotificationLbl: Label 'Some runtime fields could not be created in the integration table. Try again later or contact your system administrator.';        CreatingFieldMappingsTok: Label 'Creating field mappings.', Locked = true;        CreatingRuntimeFieldMappingsTok: Label 'Creating runtime field mappings.', Locked = true;    local procedure EnableControls()    begin        ResetControls();        case Step of            Step::Start:                ShowStep1();            Step::Step2:                ShowStep2();            Step::Step3:                ShowStep3();            Step::Finish:                ShowStep4();        end;    end;    local procedure StoreRecordVar()    var        IntegrationTableMapping: Record "Integration Table Mapping";        ManIntegrationTableMapping: Record "Man. Integration Table Mapping";        TempManIntFieldMapping: Record "Man. Int. Field Mapping" temporary;        CDSSetupDefaults: Codeunit "CDS Setup Defaults";    begin        if not SetupExistingIntegrationMapping then            Rec.InsertIntegrationTableMapping(                    IntegrationTableMapping, IntegrationMappingName,                    IntegrationMappingTableId, IntegrationMappingIntTableId,                    IntegrationTableUID, IntTblModifiedOnId, SyncOnlyCoupledRecords,                    Direction);        if not ManIntegrationTableMapping.Get(IntegrationMappingName) then            Rec.CreateRecord(IntegrationMappingName,                    IntegrationMappingTableId, IntegrationMappingIntTableId,                    IntegrationTableUID, IntTblModifiedOnId,                    SyncOnlyCoupledRecords, Direction, TableFilter, IntegrationTableFilter);        //fields        CurrPage.ManIntFieldMappingList.Page.GetValues(TempManIntFieldMapping);        CreateFieldMappings(TempManIntFieldMapping);        CreateRuntimeFieldMappings(TempManIntFieldMapping);        if not SetupExistingIntegrationMapping then begin            IntegrationTableMapping.SetTableFilter(TableFilter);            IntegrationTableMapping.SetIntegrationTableFilter(IntegrationTableFilter);            IntegrationTableMapping."User Defined" := true;            IntegrationTableMapping.Modify(true);        end;        Commit();        CDSSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping);    end;    local procedure CreateFieldMappings(var TempManIntFieldMapping: Record "Man. Int. Field Mapping" temporary)    var        ManIntFieldMapping: Codeunit "Man. Int. Field Mapping";    begin        Session.LogMessage('0000QLQ', CreatingFieldMappingsTok, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);        ManIntFieldMapping.CreateFieldMappings(TempManIntFieldMapping, IntegrationMappingName, SetupExistingIntegrationMapping);    end;    local procedure CreateRuntimeFieldMappings(var TempManIntFieldMapping: Record "Man. Int. Field Mapping" temporary)    var        ManIntFieldMapping: Codeunit "Man. Int. Field Mapping";        RuntimeFields: List of [Text];    begin        Session.LogMessage('0000QLA', CreatingRuntimeFieldMappingsTok, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);        Clear(FailedFields);        ManIntFieldMapping.GetRuntimeFieldsToCreate(TempManIntFieldMapping, RuntimeFields);        ManIntFieldMapping.TryCreateRuntimeFields(RuntimeFields, IntegrationMappingIntTableId);        ManIntFieldMapping.CreateFieldMappingsForRuntimeFields(TempManIntFieldMapping, IntegrationMappingName, IntegrationMappingIntTableId, SetupExistingIntegrationMapping, FailedFields);    end;    local procedure FinishAction()    begin        StoreRecordVar();        Step := Step::Closed;        CurrPage.Close();    end;    local procedure NextStep(Backwards: Boolean)    begin        if not (SetupExistingIntegrationMapping) and (not Backwards) then begin            if Step = Step::Start then                if IntegrationMappingName = '' then                    Error(FillinMandatoryFieldsLbl);            if Step = Step::Step2 then                if (IntegrationMappingTableId = 0) or                    (IntegrationMappingIntTableId = 0) or                    (IntegrationTableUID = 0) or                    (IntTblModifiedOnId = 0)                then                    Error(FillinMandatoryFieldsLbl);        end;        if Backwards then            Step := Step - 1        else            Step := Step + 1;        EnableControls();    end;    local procedure ShowStep1()    begin        Step1Visible := true;        FinishActionEnabled := false;        BackActionEnabled := false;    end;    local procedure ShowStep2()    begin        SetConfigTemplateValues();        Step2Visible := true;    end;    local procedure ShowStep3()    begin        CurrPage.ManIntFieldMappingList.Page.SetValues(IntegrationMappingTableId, IntegrationMappingIntTableId, IntegrationMappingName);        Step3Visible := true;        NextActionEnabled := true;    end;    local procedure ShowStep4()    begin        Step4Visible := true;        NextActionEnabled := false;        FinishActionEnabled := true;    end;    local procedure ResetControls()    begin        FinishActionEnabled := false;        if not SetupExistingIntegrationMapping then begin            BackActionEnabled := true;            NextActionEnabled := true;        end;        Step1Visible := false;        Step2Visible := false;        Step3Visible := false;        Step4Visible := false;    end;    local procedure LoadTopBanners()    begin        if MediaRepositoryStandard.Get('AssistedSetup-NoText-400px.png', Format(CurrentClientType())) and            MediaRepositoryDone.Get('AssistedSetupDone-NoText-400px.png', Format(CurrentClientType()))        then            if MediaResourcesStandard.Get(MediaRepositoryStandard."Media Resources Ref") and                MediaResourcesDone.Get(MediaRepositoryDone."Media Resources Ref")        then                TopBannerVisible := MediaResourcesDone."Media Reference".HasValue();    end;    internal procedure SetValues(lIntegrationMappingName: Code[20]; lIntegrationMappingTableId: Integer; lIntegrationMappingIntTableId: Integer)    begin        IntegrationMappingName := lIntegrationMappingName;        IntegrationMappingTableId := lIntegrationMappingTableId;        IntegrationMappingIntTableId := lIntegrationMappingIntTableId;        SetupExistingIntegrationMapping := true;    end;    local procedure SetConfigTemplateValues()    var        IntegrationTableMapping: Record "Integration Table Mapping";    begin        TableConfigTemplates := IntegrationTableMapping.GetTableConfigTemplates(IntegrationMappingName);        IntTableConfigTemplates := IntegrationTableMapping.GetIntTableConfigTemplates(IntegrationMappingName);    end;    local procedure DeleteConfigTemplates()    var        TableConfigTemplate: Record "Table Config Template";        IntTableConfigTemplate: Record "Int. Table Config Template";    begin        TableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationMappingName);        TableConfigTemplate.DeleteAll();        IntTableConfigTemplate.SetRange("Integration Table Mapping Name", IntegrationMappingName);        IntTableConfigTemplate.DeleteAll();    end;}