Page 5328 CRM Coupling Fields
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;}