Page 5328 CRM Coupling Fields

Base Application, Microsoft.Integration.Dataverse

src/Layers/W1/BaseApp/Integration/Dataverse/CRMCouplingFields.Page.al136 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.Integration.SyncEngine;page 5328 "CRM Coupling Fields"{    Caption = 'Dynamics 365 Sales Coupled Fields';    Editable = false;    PageType = ListPart;    ShowFilter = false;    SourceTable = "Coupling Fields Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Group)            {                field("Field Name"; Rec."Field Name")                {                    ApplicationArea = Suite;                }                field(Value; Rec.Value)                {                    ApplicationArea = Suite;                }                field("Integration Value"; Rec."Integration Value")                {                    ApplicationArea = Suite;                }                field(Direction; Rec.Direction)                {                    ApplicationArea = Suite;                }                field("Validate Field"; Rec."Validate Field")                {                    ApplicationArea = Suite;                }            }        }    }    actions    {    }    procedure SetSourceRecord(CouplingRecordBuffer: Record "Coupling Record Buffer")    var        IntegrationFieldMapping: Record "Integration Field Mapping";        CRMRecordRef: RecordRef;        NAVRecordRef: RecordRef;        RecordID: RecordID;        CRMRecordIsSet: Boolean;    begin        RecordID := CouplingRecordBuffer."NAV Record ID";        NAVRecordRef := RecordID.GetRecord();        NAVRecordRef.Find();        CRMRecordIsSet := not IsNullGuid(CouplingRecordBuffer."CRM ID");        if CRMRecordIsSet then begin            CRMRecordRef.Open(CouplingRecordBuffer."CRM Table ID");            FindCRMRecRefByPK(CRMRecordRef, CouplingRecordBuffer."CRM ID");        end;        Rec.DeleteAll();        IntegrationFieldMapping.Reset();        IntegrationFieldMapping.SetRange("Integration Table Mapping Name", CouplingRecordBuffer."CRM Table Name");        IntegrationFieldMapping.SetRange(Status, IntegrationFieldMapping.Status::Enabled);        if IntegrationFieldMapping.FindSet() then            repeat                Rec.Init();                if CouplingRecordBuffer."Is Option" then                    Rec."Field Name" := GetFieldCaption(CouplingRecordBuffer."NAV Table ID", IntegrationFieldMapping."Field No.")                else                    case IntegrationFieldMapping.Direction of                        IntegrationFieldMapping.Direction::Bidirectional,                      IntegrationFieldMapping.Direction::ToIntegrationTable:                            begin                                Rec."Field Name" := GetFieldCaption(CouplingRecordBuffer."CRM Table ID", IntegrationFieldMapping."Integration Table Field No.");                                Rec."Mapped Field Name" := GetFieldCaption(CouplingRecordBuffer."NAV Table ID", IntegrationFieldMapping."Field No.");                            end;                        IntegrationFieldMapping.Direction::FromIntegrationTable:                            begin                                Rec."Field Name" := GetFieldCaption(CouplingRecordBuffer."NAV Table ID", IntegrationFieldMapping."Field No.");                                Rec."Mapped Field Name" := GetFieldCaption(CouplingRecordBuffer."CRM Table ID", IntegrationFieldMapping."Integration Table Field No.");                            end;                    end;                if IntegrationFieldMapping."Field No." <> 0 then                    Rec.Value := GetFieldValue(NAVRecordRef, IntegrationFieldMapping."Field No.");                if CRMRecordIsSet and (IntegrationFieldMapping."Integration Table Field No." <> 0) then                    Rec."Integration Value" := GetFieldValue(CRMRecordRef, IntegrationFieldMapping."Integration Table Field No.");                if CouplingRecordBuffer."Is Option" then                    Rec."Integration Value" := CouplingRecordBuffer."CRM Name";                Rec.Direction := IntegrationFieldMapping.Direction;                Rec."Validate Field" := IntegrationFieldMapping."Validate Field";                Rec.Insert();            until IntegrationFieldMapping.Next() = 0;    end;    local procedure GetFieldCaption(TableNo: Integer; FieldNo: Integer) FieldCaption: Text[50]    var        FieldRef: FieldRef;        RecRef: RecordRef;    begin        RecRef.Open(TableNo);        FieldRef := RecRef.Field(FieldNo);        FieldCaption := CopyStr(FieldRef.Caption, 1, MaxStrLen(FieldCaption));        RecRef.Close();    end;    local procedure GetFieldValue(RecordRef: RecordRef; FieldNo: Integer): Text[250]    var        IntegrationRecordSynch: Codeunit "Integration Record Synch.";        FieldRef: FieldRef;    begin        FieldRef := RecordRef.Field(FieldNo);        exit(CopyStr(IntegrationRecordSynch.GetTextValue(FieldRef), 1, 250));    end;    local procedure FindCRMRecRefByPK(var RecordRef: RecordRef; CRMId: Guid): Boolean    var        FieldRef: FieldRef;        PrimaryKeyRef: KeyRef;    begin        PrimaryKeyRef := RecordRef.KeyIndex(1);        FieldRef := PrimaryKeyRef.FieldIndex(1);        FieldRef.SetRange(CRMId);        exit(RecordRef.FindFirst());    end;}