Page 7208 CDS Full Synch. Review

Base Application, Microsoft.Integration.Dataverse

src/Layers/W1/BaseApp/Integration/Dataverse/CDSFullSynchReview.Page.al455 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.Dataverse;using Microsoft.CRM.Contact;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Integration.D365Sales;using Microsoft.Integration.SyncEngine;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;page 7208 "CDS Full Synch. Review"{    Caption = 'Dataverse Full Synchronization Review', Comment = 'Dataverse is the name of a Microsoft Service and should not be translated.';    Editable = false;    PageType = List;    SourceTable = "CRM Full Synch. Review Line";    InsertAllowed = false;    layout    {        area(content)        {            repeater(Group)            {                Editable = false;                field(Name; Rec.Name)                {                    ApplicationArea = Suite;                    Editable = false;                }                field("BC Page Id"; BCPageName)                {                    ApplicationArea = Suite;                    Caption = 'Business Central';                    Tooltip = 'Open the selected page';                    Width = 10;                    trigger OnDrillDown()                    begin                        Page.Run(BCPageId);                        CurrPage.Update();                    end;                }                field("CDS Page Id"; CDSPageName)                {                    ApplicationArea = Suite;                    Caption = 'Dataverse', Locked = true;                    ToolTip = 'Open the selected page and present the existing Dataverse records.', Comment = 'Dataverse is the name of a Microsoft Service and should not be translated.';                    Width = 10;                    trigger OnDrillDown()                    begin                        case CDSPageId of                            Page::"CRM TransactionCurrency List":                                OpenCRMTransactionCurrenciesListPage();                            Page::"CDS Couple Salespersons":                                OpenCRMSystemUserListPage();                            Page::"CRM Contact List":                                OpenCRMContactListPage();                            Page::"CRM Payment Terms List":                                OpenCRMPaymentTermsListPage();                            Page::"CRM Freight Terms List":                                OpenCRMFreightTermsListPage();                            Page::"CRM Shipping Method List":                                OpenCRMShippingMethodListPage();                            else                                OpenCRMAccountListPage();                        end;                    end;                }                field(Direction; Rec.Direction)                {                    ApplicationArea = Suite;                    ToolTip = 'Specifies the direction in which data will synchronize.';                }                field("Initial Synchronization Recommendation"; InitialSynchRecommendation)                {                    Caption = 'Recommendation';                    ApplicationArea = Suite;                    Enabled = (Rec."Initial Synch Recommendation" = Rec."Initial Synch Recommendation"::"Couple Records");                    StyleExpr = InitialSynchRecommendationStyle;                    ToolTip = 'Specifies the recommended action for the initial synchronization.';                    trigger OnDrillDown()                    var                        IntegrationFieldMapping: Record "Integration Field Mapping";                        IntegrationTableMapping: Record "Integration Table Mapping";                    begin                        if not (InitialSynchRecommendation in [MatchBasedCouplingTxt, CouplingCriteriaSelectedTxt]) then                            exit;                        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);                        case BCPageId of                            Page::"Currencies":                                IntegrationTableMapping.SetRange("Table ID", Database::Currency);                            Page::"Salespersons/Purchasers":                                IntegrationTableMapping.SetRange("Table ID", Database::"Salesperson/Purchaser");                            Page::"Contact List":                                IntegrationTableMapping.SetRange("Table ID", Database::Contact);                            Page::"Vendor List":                                IntegrationTableMapping.SetRange("Table ID", Database::Vendor);                            Page::"Customer List":                                IntegrationTableMapping.SetRange("Table ID", Database::Customer);                            Page::"Payment Terms":                                IntegrationTableMapping.SetRange("Table ID", Database::"Payment Terms");                            Page::"Shipment Methods":                                IntegrationTableMapping.SetRange("Table ID", Database::"Shipment Method");                            Page::"Shipping Agents":                                IntegrationTableMapping.SetRange("Table ID", Database::"Shipping Agent");                            else                                exit;                        end;                        IntegrationTableMapping.SetRange("Delete After Synchronization", false);                        if not IntegrationTableMapping.FindFirst() then                            exit;                        IntegrationFieldMapping.SetMatchBasedCouplingFilters(IntegrationTableMapping);                        if Page.RunModal(Page::"Match Based Coupling Criteria", IntegrationFieldMapping) = Action::LookupOK then                            CurrPage.Update(false);                    end;                }                field("Multi Company Synch. Enabled"; Rec."Multi Company Synch. Enabled")                {                    ApplicationArea = Suite;                    Visible = true;                    trigger OnValidate()                    begin                        Message(RefreshToApplyTxt);                    end;                }            }        }    }    actions    {        area(Processing)        {            group(Refresh)            {                Caption = 'Refresh recommendation';                action(RefreshRecommendations)                {                    ApplicationArea = Suite;                    Caption = 'Refresh recommendation';                    Image = Refresh;                    ToolTip = 'Refresh the initial synchronization recommendations.';                    trigger OnAction()                    begin                        Rec.DeleteAll();                        Rec.Generate();                        Commit();                    end;                }            }            group(Sync)            {                action(ScheduleFullSynch)                {                    ApplicationArea = Suite;                    Caption = 'Recommend Full Synchronization';                    Enabled = ActionRecommendFullSynchEnabled;                    Image = RefreshLines;                    ToolTip = 'Recommend full synchronization job for the selected line.';                    trigger OnAction()                    begin                        Rec."Initial Synch Recommendation" := Rec."Initial Synch Recommendation"::"Full Synchronization";                        Rec.Modify();                        CurrPage.Update();                    end;                }                action(ToggleMultiCompany)                {                    ApplicationArea = Suite;                    Caption = 'Toggle Multi-Company Synchronization';                    Visible = MultiCompanyCheckboxEnabled;                    Image = ToggleBreakpoint;                    ToolTip = 'Toggle multi-company synchronization for this table mapping.';                    trigger OnAction()                    begin                        Rec.Validate("Multi Company Synch. Enabled", (not Rec."Multi Company Synch. Enabled"));                        Commit();                        Rec.DeleteAll();                        Rec.Generate();                        Commit();                    end;                }            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref(RefreshRecommendations_Promoted; RefreshRecommendations)                {                }                actionref(ScheduleFullSynch_Promoted; ScheduleFullSynch)                {                }                actionref(ToggleMultiCompany_Promoted; ToggleMultiCompany)                {                }            }        }    }    trigger OnOpenPage()    var        CDSIntegrationImpl: Codeunit "CDS Integration Impl.";    begin        MultiCompanyCheckboxEnabled := CDSIntegrationImpl.MultipleCompaniesConnected();    end;    trigger OnAfterGetRecord()    var        IntegrationFieldMapping: Record "Integration Field Mapping";    begin        ActionStartEnabled := (not Rec.IsThereActiveSessionInProgress()) and Rec.IsThereBlankStatusLine();        ActionRecommendFullSynchEnabled := (not Rec.IsThereActiveSessionInProgress()) and (Rec."Initial Synch Recommendation" = Rec."Initial Synch Recommendation"::"Couple Records");        if Rec."Initial Synch Recommendation" <> Rec."Initial Synch Recommendation"::"Couple Records" then            InitialSynchRecommendation := Format(Rec."Initial Synch Recommendation")        else begin            IntegrationFieldMapping.SetRange("Integration Table Mapping Name", Rec.Name);            IntegrationFieldMapping.SetRange("Use For Match-Based Coupling", true);            if IntegrationFieldMapping.IsEmpty() then                InitialSynchRecommendation := MatchBasedCouplingTxt            else                InitialSynchRecommendation := CouplingCriteriaSelectedTxt        end;        if InitialSynchRecommendation = CouplingCriteriaSelectedTxt then            InitialSynchRecommendationStyle := 'Favorable'        else            InitialSynchRecommendationStyle := Rec.GetInitialSynchRecommendationStyleExpression(Format(Rec."Initial Synch Recommendation"));        GetCDSPageId();        GetBCPageId();        GetCDSPageName();        GetBCPageName();    end;    trigger OnInit()    begin        Codeunit.Run(Codeunit::"CRM Integration Management");        Commit();    end;    [Scope('OnPrem')]    procedure SetConnectionSetup(NewCDSConnectionSetup: Record "CDS Connection Setup"; NewUserPassword: SecretText)    begin        CDSConnectionSetup := NewCDSConnectionSetup;        UserPassword := NewUserPassword;    end;    local procedure GetCDSPageId()    begin        case Rec.Name of            'CONTACT':                CDSPageId := 5342;            'CURRENCY':                CDSPageId := 5345;            'CUSTOMER':                CDSPageId := 5341;            'SALESPEOPLE':                CDSPageId := 7209;            'VENDOR':                CDSPageId := 5341;            'PAYMENT TERMS':                CDSPageId := 7210;            'SHIPMENT METHOD':                CDSPageId := 7211;            'SHIPPING AGENT':                CDSPageId := 7212;        end;    end;    local procedure GetBCPageId()    begin        case Rec.Name of            'CONTACT':                BCPageId := Page::"Contact List";            'CURRENCY':                BCPageId := Page::Currencies;            'CUSTOMER':                BCPageId := Page::"Customer List";            'SALESPEOPLE':                BCPageId := Page::"Salespersons/Purchasers";            'VENDOR':                BCPageId := Page::"Vendor List";            'PAYMENT TERMS':                BCPageId := Page::"Payment Terms";            'SHIPMENT METHOD':                BCPageId := Page::"Shipment Methods";            'SHIPPING AGENT':                BCPageId := Page::"Shipping Agents";        end;    end;    local procedure GetCDSPageName()    begin        case Rec.Name of            'CONTACT':                CDSPageName := 'Contacts';            'CURRENCY':                CDSPageName := 'Transaction Currencies';            'CUSTOMER':                CDSPageName := 'Accounts';            'SALESPEOPLE':                CDSPageName := 'Users';            'VENDOR':                CDSPageName := 'Accounts';            'PAYMENT TERMS':                CDSPageName := 'Payment Terms';            'SHIPMENT METHOD':                CDSPageName := 'Freight Terms';            'SHIPPING AGENT':                CDSPageName := 'Shipping Methods';        end;    end;    local procedure GetBCPageName()    begin        case Rec.Name of            'CONTACT':                BCPageName := 'Contacts';            'CURRENCY':                BCPageName := 'Currencies';            'CUSTOMER':                BCPageName := 'Customers';            'SALESPEOPLE':                BCPageName := 'Salespeople/Purchasers';            'VENDOR':                BCPageName := 'Vendors';            'PAYMENT TERMS':                BCPageName := 'Payment Terms';            'SHIPMENT METHOD':                BCPageName := 'Shipment Methods';            'SHIPPING AGENT':                BCPageName := 'Shipping Agents';        end;    end;    local procedure OpenCRMContactListPage()    var        CRMContact: Record "CRM Contact";        LookupCRMTables: Codeunit "Lookup CRM Tables";        CRMContactList: Page "CRM Contact List";    begin        CRMContact.Reset();        CRMContact.SetView(LookupCRMTables.GetIntegrationTableMappingView(DATABASE::"CRM Contact"));        if not CRMContact.FindSet() then;        CRMContactList.SetRecord(CRMContact);        CRMContactList.SetTableView(CRMContact);        CRMContactList.Run();        CurrPage.Update();    end;    local procedure OpenCRMTransactionCurrenciesListPage()    var        CRMTransactionCurrency: Record "CRM Transactioncurrency";        LookupCRMTables: Codeunit "Lookup CRM Tables";        CRMTransactionCurrencyList: Page "CRM TransactionCurrency List";    begin        CRMTransactionCurrency.Reset();        CRMTransactionCurrency.SetView(LookupCRMTables.GetIntegrationTableMappingView(DATABASE::"CRM Transactioncurrency"));        if not CRMTransactionCurrency.FindSet() then;        CRMTransactionCurrencyList.SetRecord(CRMTransactionCurrency);        CRMTransactionCurrencyList.Run();        CurrPage.Update();    end;    local procedure OpenCRMAccountListPage()    var        CRMAccount: Record "CRM Account";        LookupCRMTables: Codeunit "Lookup CRM Tables";        CRMAccountList: Page "CRM Account List";    begin        CRMAccount.Reset();        CRMAccount.SetView(LookupCRMTables.GetIntegrationTableMappingView(DATABASE::"CRM Account"));        if BCPageId = PAGE::"Customer List" then            CRMAccount.SetRange(CustomerTypeCode, CRMAccount.CustomerTypeCode::Customer)        else            CRMAccount.SetRange(CustomerTypeCode, CRMAccount.CustomerTypeCode::Vendor);        if not CRMAccount.FindSet() then;        CRMAccountList.SetTableView(CRMAccount);        CRMAccountList.SetRecord(CRMAccount);        CRMAccountList.Run();        CurrPage.Update();    end;    local procedure OpenCRMSystemUserListPage()    var        CRMSystemUser: Record "CRM Systemuser";        CRMSystemuserList: Page "CRM Systemuser List";    begin        if CRMSystemUser.FindSet() then;        CRMSystemuserList.SetRecord(CRMSystemUser);        CRMSystemuserList.Run();        CurrPage.Update();    end;    local procedure OpenCRMPaymentTermsListPage()    var        CRMPaymentTermsList: Page "CRM Payment Terms List";    begin        CRMPaymentTermsList.Run();        CurrPage.Update();    end;    local procedure OpenCRMFreightTermsListPage()    var        CRMPFreightTermsList: Page "CRM Freight Terms List";    begin        CRMPFreightTermsList.Run();        CurrPage.Update();    end;    local procedure OpenCRMShippingMethodListPage()    var        CRMShippingMethodList: Page "CRM Shipping Method List";    begin        CRMShippingMethodList.Run();        CurrPage.Update();    end;    var        CDSConnectionSetup: Record "CDS Connection Setup";        UserPassword: SecretText;        ActionStartEnabled: Boolean;        ActionRecommendFullSynchEnabled: Boolean;        MultiCompanyCheckboxEnabled: Boolean;        BCPageId: Integer;        CDSPageId: Integer;        CDSPageName: Text;        BCPageName: Text;        InitialSynchRecommendation: Text;        InitialSynchRecommendationStyle: Text;        MatchBasedCouplingTxt: Label 'Select Coupling Criteria';        CouplingCriteriaSelectedTxt: Label 'Review Selected Coupling Criteria';        RefreshToApplyTxt: Label 'Choose action ''Refresh recommendation'' to apply the change.';}