Table 5331 CRM Integration Record

Base Application, Microsoft.Integration.Dataverse

src/Layers/W1/BaseApp/Integration/Dataverse/CRMIntegrationRecord.Table.al902 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.D365Sales;using Microsoft.Integration.SyncEngine;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using System.Reflection;table 5331 "CRM Integration Record"{    Caption = 'CRM Integration Record';    DataClassification = CustomerContent;    fields    {        field(2; "CRM ID"; Guid)        {            Caption = 'CRM ID';            Description = 'An ID of a record in Microsoft Dynamics CRM';            trigger OnValidate()            begin                Clear("Last Synch. CRM Job ID");                "Last Synch. CRM Modified On" := 0DT;                "Last Synch. CRM Result" := "Last Synch. CRM Result"::" ";                Skipped := false;            end;        }        field(3; "Integration ID"; Guid)        {            Caption = 'Integration ID';            trigger OnValidate()            begin                Clear("Last Synch. Job ID");                "Last Synch. Modified On" := 0DT;                "Last Synch. Result" := "Last Synch. Result"::" ";                Skipped := false;            end;        }        field(4; "Last Synch. Modified On"; DateTime)        {            Caption = 'Last Synch. Modified On';        }        field(5; "Last Synch. CRM Modified On"; DateTime)        {            Caption = 'Last Synch. CRM Modified On';        }        field(6; "Table ID"; Integer)        {            Caption = 'Table ID';            Editable = false;            FieldClass = Normal;            trigger OnValidate()            begin                CheckTableID();            end;        }#pragma warning disable AS0044        field(7; "Last Synch. Result"; Option)        {            Caption = 'Last Synch. Result';            OptionCaption = ' ,Success,Failure';            OptionMembers = " ",Success,Failure;        }        field(8; "Last Synch. CRM Result"; Option)        {            Caption = 'Last Synch. CRM Result';            OptionCaption = ' ,Success,Failure';            OptionMembers = " ",Success,Failure;        }#pragma warning restore AS0044        field(9; "Last Synch. Job ID"; Guid)        {            Caption = 'Last Synch. Job ID';        }        field(10; "Last Synch. CRM Job ID"; Guid)        {            Caption = 'Last Synch. CRM Job ID';        }        field(11; Skipped; Boolean)        {            Caption = 'Skipped';            Editable = false;            trigger OnValidate()            begin                if not Skipped then                    if "Table ID" = Database::Customer then                        "Statistics Uploaded" := false;            end;        }        field(13; "Statistics Uploaded"; Boolean)        {            Caption = 'Statistics Uploaded';        }        field(14; "Archived Sales Order"; Boolean)        {            Caption = 'Archived Sales Order';            Editable = false;        }        field(15; "Archived Sales Order Updated"; Boolean)        {            Caption = 'Archived Sales Order Updated';            Editable = false;        }    }    keys    {        key(Key1; "CRM ID", "Integration ID")        {            Clustered = true;        }        key(Key2; "Integration ID")        {        }        key(Key3; "Last Synch. Modified On", "Integration ID")        {        }        key(Key4; "Last Synch. CRM Modified On", "CRM ID")        {        }        key(Key5; Skipped, "Table ID")        {        }        key(Key6; "Table ID")        {        }        key(Key7; "Statistics Uploaded", Skipped, "Table ID")        {        }        key(Key8; "Integration ID", "Statistics Uploaded", Skipped, "Table ID")        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        CheckTableID();    end;    trigger OnDelete()    var        CRMConnectionSetup: Record "CRM Connection Setup";        CRMIntegrationRecord: Record "CRM Integration Record";        SalesHeader: Record "Sales Header";        SalesLine: Record "Sales Line";    begin        if Rec."Table ID" = Database::"Sales Header" then            if CRMConnectionSetup.IsBidirectionalSalesOrderIntEnabled() then                if SalesHeader.GetBySystemId(Rec."Integration ID") then begin                    SalesLine.SetRange("Document No.", SalesHeader."No.");                    SalesLine.SetRange("Document Type", SalesLine."Document Type"::Order);                    if SalesLine.FindSet() then                        repeat                            CRMIntegrationRecord.SetRange("Integration ID", SalesLine.SystemId);                            CRMIntegrationRecord.SetRange("Table ID", Database::"Sales Line");                            if CRMIntegrationRecord.FindFirst() then                                CRMIntegrationRecord.Delete();                        until SalesLine.Next() = 0;                end;    end;    var        CRMProductName: Codeunit "CRM Product Name";#pragma warning disable AA0470        IntegrationRecordNotFoundErr: Label 'The integration record for entity %1 was not found.';#pragma warning restore AA0470        CRMIdAlreadyMappedErr: Label 'Cannot couple %1 to this %3 record, because the %3 record is already coupled to %2.', Comment = '%1 ID of the record, %2 ID of the already mapped record, %3 = Dataverse service name';        RecordRefAlreadyMappedErr: Label 'Cannot couple %1 to this %3 record, because the %3 record is already coupled to %2.', Comment = '%1 ID of the record, %2 ID of the already mapped record, %3 = table caption';        RecordIdAlreadyMappedErr: Label 'Cannot couple the %2 record to %1, because %1 is already coupled to another %2 record.', Comment = '%1 ID from the record, %2 ID of the already mapped record';        ZeroTableIdErr: Label 'Table ID must be specified.';        ZeroTableIdTxt: Label 'Table ID is zero in CRM Integration Record. System ID: %1, CRM ID: %2', Locked = true;        FixedTableIdTxt: Label 'Table ID has been fixed in CRM Integration Record. New Table ID: %1, System ID: %2, CRM ID: %3', Locked = true;        CrmTelemetryCategoryTok: Label 'AL CRM Integration', Locked = true;    local procedure CheckTableID()    begin        if "Table ID" = 0 then            if not IsNullGuid("Integration ID") then                if not IsTemporary() then                    Error(ZeroTableIdErr);    end;    [Scope('OnPrem')]    procedure GetTableID(): Integer    begin        if "Table ID" <> 0 then            exit("Table ID");        if IsNullGuid("Integration ID") then            exit(0);        if RepairTableIdByLocalRecord() then            exit("Table ID");        Session.LogMessage('0000DQ9', StrSubstNo(ZeroTableIdTxt, "Integration ID", "CRM ID"), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CrmTelemetryCategoryTok);        exit(0);    end;    internal procedure RepairTableIdByLocalRecord(): Boolean    var        IntegrationTableMapping: Record "Integration Table Mapping";    begin        if "Table ID" <> 0 then            exit(true);        if IsNullGuid("Integration ID") then            exit(true);        if FindMappingByLocalRecordId(IntegrationTableMapping) then begin            "Table ID" := IntegrationTableMapping."Table ID";            Modify();            Session.LogMessage('0000DQ7', StrSubstNo(FixedTableIdTxt, "Table ID", "Integration ID", "CRM ID"), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CrmTelemetryCategoryTok);            exit(true);        end;        exit(false);    end;    internal procedure RepairTableIdByCRMRecord(): Boolean    var        IntegrationTableMapping: Record "Integration Table Mapping";    begin        if "Table ID" <> 0 then            exit(true);        if IsNullGuid("Integration ID") then            exit(true);        if FindMappingByCRMRecordId(IntegrationTableMapping) then            if IntegrationTableMapping."Table ID" <> 0 then begin                "Table ID" := IntegrationTableMapping."Table ID";                Modify();                Session.LogMessage('0000DQ8', StrSubstNo(FixedTableIdTxt, "Table ID", "Integration ID", "CRM ID"), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CrmTelemetryCategoryTok);                exit(true);            end;        exit(false);    end;    local procedure FindMappingByLocalRecordId(var IntegrationTableMapping: Record "Integration Table Mapping"): Boolean    var        LocalRecordRef: RecordRef;    begin        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);        IntegrationTableMapping.SetRange("Delete After Synchronization", false);        IntegrationTableMapping.SetFilter("Table ID", '<>0');        if IntegrationTableMapping.FindSet() then            repeat                LocalRecordRef.Close();                LocalRecordRef.Open(IntegrationTableMapping."Table ID");                if LocalRecordRef.GetBySystemId("Integration ID") then                    exit(true);            until IntegrationTableMapping.Next() = 0;        exit(false);    end;    local procedure FindMappingByCRMRecordId(var IntegrationTableMapping: Record "Integration Table Mapping"): Boolean    var        CRMRecordRef: RecordRef;        CRMIdFieldRef: FieldRef;        PrimaryKeyRef: KeyRef;        CRMTableView: Text;    begin        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);        IntegrationTableMapping.SetRange("Delete After Synchronization", false);        IntegrationTableMapping.SetFilter("Integration Table ID", '<>0');        if IntegrationTableMapping.FindSet() then            repeat                CRMRecordRef.Close();                CRMTableView := IntegrationTableMapping.GetIntegrationTableFilter();                CRMRecordRef.Open(IntegrationTableMapping."Integration Table ID");                PrimaryKeyRef := CRMRecordRef.KeyIndex(1);                CRMIdFieldRef := PrimaryKeyRef.FieldIndex(1);                CRMRecordRef.SetView(CRMTableView);                CRMIdFieldRef.SetRange("CRM ID");                if not CRMRecordRef.IsEmpty() then                    exit(true);            until IntegrationTableMapping.Next() = 0;        exit(false);    end;    local procedure GetCRMIdFromRecRef(CRMRecordRef: RecordRef): Guid    var        CRMIdFieldRef: FieldRef;        PrimaryKeyRef: KeyRef;    begin        PrimaryKeyRef := CRMRecordRef.KeyIndex(1);        CRMIdFieldRef := PrimaryKeyRef.FieldIndex(1);        exit(CRMIdFieldRef.Value);    end;    procedure GetCRMRecordID(IntegrationTableID: Integer; var CRMRecID: RecordID) Found: Boolean    var        RecRef: RecordRef;    begin        Found := GetCRMRecordRef(IntegrationTableID, RecRef);        CRMRecID := RecRef.RecordId;        RecRef.Close();    end;    procedure GetCRMRecordRef(IntegrationTableID: Integer; var RecRef: RecordRef): Boolean    var        FieldRef: FieldRef;        KeyRef: KeyRef;    begin        if IntegrationTableID = 0 then            exit(false);        RecRef.Open(IntegrationTableID);        KeyRef := RecRef.KeyIndex(1);        FieldRef := KeyRef.FieldIndex(1);        FieldRef.SetRange("CRM ID");        exit(RecRef.FindFirst());    end;    procedure GetLatestJobIDFilter(): Text    var        IntegrationSynchJob: Record "Integration Synch. Job";    begin        if IsNullGuid("Last Synch. Job ID") and IsNullGuid("Last Synch. CRM Job ID") then            exit('');        IntegrationSynchJob.SetFilter(ID, '%1|%2', "Last Synch. Job ID", "Last Synch. CRM Job ID");        exit(IntegrationSynchJob.GetFilter(ID));    end;    procedure GetLatestError(var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"): Boolean    begin        if not IsNullGuid("Last Synch. CRM Job ID") then            exit(GetErrorForJobID("Last Synch. CRM Job ID", IntegrationSynchJobErrors));        if not IsNullGuid("Last Synch. Job ID") then            exit(GetErrorForJobID("Last Synch. Job ID", IntegrationSynchJobErrors))    end;    local procedure GetErrorForJobID(JobID: Guid; var IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"): Boolean    var        IntegrationSynchJob: Record "Integration Synch. Job";        IntegrationTableMapping: Record "Integration Table Mapping";        CRMRecId: RecordID;        RecId: RecordId;    begin        if IntegrationSynchJob.Get(JobID) then            case IntegrationSynchJob."Synch. Direction" of                IntegrationSynchJob."Synch. Direction"::ToIntegrationTable:                    if FindRecordId(RecId) then                        exit(IntegrationSynchJob.GetErrorForRecordID(RecId, IntegrationSynchJobErrors));                IntegrationSynchJob."Synch. Direction"::FromIntegrationTable:                    if IntegrationTableMapping.Get(IntegrationSynchJob."Integration Table Mapping Name") then                        if GetCRMRecordID(IntegrationTableMapping."Integration Table ID", CRMRecId) then                            exit(IntegrationSynchJob.GetErrorForRecordID(CRMRecId, IntegrationSynchJobErrors));            end;    end;    procedure InsertRecord(CRMID: Guid; SysId: Guid; TableId: Integer)    begin        Reset();        Init();        "CRM ID" := CRMID;        "Integration ID" := SysId;        "Table ID" := TableId;        Insert(true);    end;    procedure IsCRMRecordRefCoupled(CRMRecordRef: RecordRef): Boolean    begin        exit(FindByCRMID(GetCRMIdFromRecRef(CRMRecordRef)));    end;    procedure IsIntegrationIdCoupled(IntegrationID: Guid; TableId: Integer): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        exit(FindRowFromIntegrationID(IntegrationID, TableId, CRMIntegrationRecord));    end;    procedure IsRecordCoupled(DestinationRecordID: RecordID): Boolean    var        CRMId: Guid;    begin        exit(FindIDFromRecordID(DestinationRecordID, CRMId));    end;    procedure FindByCRMID(CRMID: Guid): Boolean    begin        Reset();        SetRange("CRM ID", CRMID);        exit(FindFirst());    end;    procedure FindValidByCRMID(CRMID: Guid) Found: Boolean    var        RecRef: RecordRef;        RecId: RecordId;    begin        Clear("CRM ID");        Reset();        SetRange("CRM ID", CRMID);        if FindFirst() then            if FindRecordId(RecId) then                Found := RecRef.Get(RecId);    end;    procedure FindRecordId(var RecId: RecordId): Boolean    var        RecRef: RecordRef;        FldRef: FieldRef;        EmptyRecId: RecordId;        FoundRecId: RecordId;        TableId: Integer;    begin        TableId := GetTableID();        if TableId = 0 then            exit(false);        RecRef.Open(TableId);        FldRef := RecRef.FIELD(RecRef.SystemIdNo());        FldRef.SetRange("Integration ID");        if RecRef.FindFirst() then            FoundRecId := RecRef.RecordId();        if FoundRecId <> EmptyRecId then            RecId := FoundRecId;        exit(FoundRecId <> EmptyRecId);    end;    procedure FindSystemIdByRecordId(var SysId: Guid; RecId: RecordId): Boolean    var        RecRef: RecordRef;    begin        if not RecRef.Get(RecId) then            exit(false);        exit(FindSystemIdByRecordRef(SysId, RecRef));    end;    procedure FindSystemIdByRecordRef(var SysId: Guid; RecordRef: RecordRef): Boolean    begin        if RecordRef.Number() = 0 then            exit(false);        SysId := RecordRef.Field(RecordRef.SystemIdNo()).Value();        exit(not IsNullGuid(SysId));    end;    procedure FindByRecordID(RecID: RecordID): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromRecordID(RecID, CRMIntegrationRecord) then begin            Copy(CRMIntegrationRecord);            exit(true);        end;    end;    procedure FindValidByRecordID(RecID: RecordID; IntegrationTableID: Integer) Found: Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMRecId: RecordID;    begin        Clear("CRM ID");        if FindRowFromRecordID(RecID, CRMIntegrationRecord) then begin            Copy(CRMIntegrationRecord);            Found := GetCRMRecordID(IntegrationTableID, CRMRecId);        end;    end;    procedure FindRecordIDFromID(SourceCRMID: Guid; DestinationTableID: Integer; var DestinationRecordId: RecordID): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        RecId: RecordId;    begin        if FindRowFromCRMID(SourceCRMID, DestinationTableID, CRMIntegrationRecord) then begin            if CRMIntegrationRecord.FindRecordId(RecId) then                DestinationRecordId := RecId;            exit(true);        end;    end;    procedure FindIDFromRecordID(SourceRecordID: RecordID; var DestinationCRMID: Guid): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromRecordID(SourceRecordID, CRMIntegrationRecord) then begin            DestinationCRMID := CRMIntegrationRecord."CRM ID";            exit(true);        end;    end;    procedure FindIDFromRecordRef(SourceRecordRef: RecordRef; var DestinationCRMID: Guid): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromRecordRef(SourceRecordRef, CRMIntegrationRecord) then begin            DestinationCRMID := CRMIntegrationRecord."CRM ID";            exit(true);        end;    end;    local procedure FindIntegrationIDFromCRMID(SourceCRMID: Guid; DestinationTableID: Integer; var DestinationIntegrationID: Guid): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromCRMID(SourceCRMID, DestinationTableID, CRMIntegrationRecord) then begin            DestinationIntegrationID := CRMIntegrationRecord."Integration ID";            exit(true);        end;    end;    procedure CoupleCRMIDToRecordID(CRMID: Guid; RecordID: RecordID)    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMIntegrationRecord2: Record "CRM Integration Record";        ErrCRMID: Guid;        SysId: Guid;    begin        if not FindSystemIdByRecordId(SysId, RecordID) then            Error(IntegrationRecordNotFoundErr, Format(RecordID, 0, 1));        // Find coupling between CRMID and TableNo        if not FindRowFromCRMID(CRMID, RecordID.TableNo, CRMIntegrationRecord) then            // Find rogue coupling beteen CRMID and table 0            if not FindRowFromCRMID(CRMID, 0, CRMIntegrationRecord) then begin                // Find other coupling to the record                if CRMIntegrationRecord2.FindIDFromRecordID(RecordID, ErrCRMID) then                    Error(RecordIdAlreadyMappedErr, Format(RecordID, 0, 1));                CRMIntegrationRecord.InsertRecord(CRMID, SysId, RecordID.TableNo);                exit;            end;        // Update Integration ID        if CRMIntegrationRecord."Integration ID" <> SysId then begin            if CRMIntegrationRecord2.FindIDFromRecordID(RecordID, ErrCRMID) then                Error(RecordIdAlreadyMappedErr, Format(RecordID, 0, 1));            CRMIntegrationRecord.SetNewIntegrationId(SysId);        end;    end;    procedure CoupleCRMIDToRecordRef(CRMID: Guid; RecordRef: RecordRef)    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMIntegrationRecord2: Record "CRM Integration Record";        ErrCRMID: Guid;        SysId: Guid;    begin        if not FindSystemIdByRecordRef(SysId, RecordRef) then            Error(IntegrationRecordNotFoundErr, Format(RecordRef.RecordId(), 0, 1));        // Find coupling between CRMID and TableNo        if not FindRowFromCRMID(CRMID, RecordRef.Number(), CRMIntegrationRecord) then            // Find rogue coupling beteen CRMID and table 0            if not FindRowFromCRMID(CRMID, 0, CRMIntegrationRecord) then begin                // Find other coupling to the record                if CRMIntegrationRecord2.FindIDFromRecordRef(RecordRef, ErrCRMID) then                    Error(RecordRefAlreadyMappedErr, CRMId, ErrCRMID, RecordRef.Caption());                CRMIntegrationRecord.InsertRecord(CRMID, SysId, RecordRef.Number());                exit;            end;        // Update Integration ID        if CRMIntegrationRecord."Integration ID" <> SysId then begin            if CRMIntegrationRecord2.FindIDFromRecordRef(RecordRef, ErrCRMID) then                Error(RecordRefAlreadyMappedErr, CRMId, ErrCRMID, RecordRef.Caption());            CRMIntegrationRecord.SetNewIntegrationId(SysId);        end;    end;    procedure CoupleRecordIdToCRMID(RecordID: RecordID; CRMID: Guid)    var        CRMIntegrationRecord: Record "CRM Integration Record";        RecRef: RecordRef;        SystemIdFieldRef: FieldRef;        IntegrationID: Guid;    begin        RecRef.Get(RecordID);        SystemIdFieldRef := RecRef.Field(RecRef.SystemIdNo);        IntegrationID := SystemIdFieldRef.Value();        if not FindRowFromIntegrationID(IntegrationID, RecRef.Number, CRMIntegrationRecord) then begin            AssertRecordIDCanBeCoupled(RecordID, CRMID);            CRMIntegrationRecord.InsertRecord(CRMID, IntegrationID, RecRef.Number);        end else            if CRMIntegrationRecord."CRM ID" <> CRMID then begin                AssertRecordIDCanBeCoupled(RecordID, CRMID);                CRMIntegrationRecord.SetNewCRMId(CRMID);            end;    end;    procedure RemoveCouplingToRecord(RecordID: RecordID): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        SysId: Guid;    begin        if not FindSystemIdByRecordId(SysId, RecordID) then            Error(IntegrationRecordNotFoundErr, Format(RecordID, 0, 1));        if FindRowFromIntegrationID(SysId, RecordID.TableNo, CRMIntegrationRecord) then begin            Copy(CRMIntegrationRecord);            CRMIntegrationRecord.Delete(true);            exit(true);        end;    end;    procedure RemoveCouplingToRecord(RecordRef: RecordRef): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        SysId: Guid;    begin        if not FindSystemIdByRecordRef(SysId, RecordRef) then            Error(IntegrationRecordNotFoundErr, RecordRef.Field(RecordRef.SystemIdNo()).Value());        if FindRowFromIntegrationID(SysId, RecordRef.Number, CRMIntegrationRecord) then begin            Copy(CRMIntegrationRecord);            CRMIntegrationRecord.Delete(true);            exit(true);        end;    end;    procedure RemoveCouplingToCRMID(CRMID: Guid; DestinationTableID: Integer): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromCRMID(CRMID, DestinationTableID, CRMIntegrationRecord) then begin            Copy(CRMIntegrationRecord);            CRMIntegrationRecord.Delete(true);            exit(true);        end;    end;    procedure SetNewCRMId(CRMId: Guid)    begin        Delete();        Validate("CRM ID", CRMId);        Insert();    end;    procedure SetNewIntegrationId(IntegrationId: Guid)    begin        Delete();        Validate("Integration ID", IntegrationId);        Insert();    end;    procedure AssertRecordIDCanBeCoupled(RecordID: RecordID; CRMID: Guid)    var        CRMIntegrationRecord: Record "CRM Integration Record";        ErrRecordID: RecordID;        ErrIntegrationID: Guid;    begin        if FindIntegrationIDFromCRMID(CRMID, RecordID.TableNo, ErrIntegrationID) then            if not UncoupleCRMIDIfRecordDeleted(RecordID.TableNo, ErrIntegrationID) then begin                CRMIntegrationRecord.FindRecordIDFromID(CRMID, RecordID.TableNo, ErrRecordID);                Error(CRMIdAlreadyMappedErr, Format(RecordID, 0, 1), ErrRecordID, CRMProductName.CDSServiceName());            end;    end;    procedure SetLastSynchResultFailed(SourceRecRef: RecordRef; DirectionToIntTable: Boolean; JobId: Guid)    var        MarkedAsSkipped: Boolean;    begin        SetLastSynchResultFailed(SourceRecRef, DirectionToIntTable, JobId, MarkedAsSkipped);    end;    procedure SetLastSynchResultFailed(SourceRecRef: RecordRef; DirectionToIntTable: Boolean; JobId: Guid; var MarkedAsSkipped: Boolean)    var        Found: Boolean;    begin        if DirectionToIntTable then            Found := FindByRecordID(SourceRecRef.RecordId)        else            Found := FindByCRMID(GetCRMIdFromRecRef(SourceRecRef));        if Found then begin            if MarkedAsSkipped then                Skipped := true;            if DirectionToIntTable then begin                if (not Skipped) and ("Last Synch. CRM Result" = "Last Synch. CRM Result"::Failure) then                    Skipped := IsSameFailureRepeatedTwice(SourceRecRef, "Last Synch. CRM Job ID", JobId);                "Last Synch. CRM Job ID" := JobId;                "Last Synch. CRM Result" := "Last Synch. CRM Result"::Failure            end else begin                if (not Skipped) and ("Last Synch. Result" = "Last Synch. Result"::Failure) then                    Skipped := IsSameFailureRepeatedTwice(SourceRecRef, "Last Synch. Job ID", JobId);                "Last Synch. Job ID" := JobId;                "Last Synch. Result" := "Last Synch. Result"::Failure;            end;            if Skipped then                MarkedAsSkipped := true;            Modify(true);        end;    end;    procedure IsSkipped(SourceRecordRef: RecordRef; DirectionToIntTable: Boolean): Boolean    var        Found: Boolean;    begin        if DirectionToIntTable then            Found := FindByRecordID(SourceRecordRef.RecordId())        else            Found := FindByCRMID(GetCRMIdFromRecRef(SourceRecordRef));        exit(Skipped);    end;    procedure SetLastSynchModifiedOns(SourceCRMID: Guid; DestinationTableID: Integer; CRMLastModifiedOn: DateTime; LastModifiedOn: DateTime; JobId: Guid; Direction: Option)    var        CRMIntegrationRecord: Record "CRM Integration Record";        IntegrationTableMapping: Record "Integration Table Mapping";    begin        if not FindRowFromCRMID(SourceCRMID, DestinationTableID, CRMIntegrationRecord) then            exit;        case Direction of            IntegrationTableMapping.Direction::FromIntegrationTable:                begin                    CRMIntegrationRecord."Last Synch. Job ID" := JobId;                    CRMIntegrationRecord."Last Synch. Result" := "Last Synch. Result"::Success;                end;            IntegrationTableMapping.Direction::ToIntegrationTable:                begin                    CRMIntegrationRecord."Last Synch. CRM Job ID" := JobId;                    CRMIntegrationRecord."Last Synch. CRM Result" := "Last Synch. CRM Result"::Success;                end;        end;        if LastModifiedOn > CRMIntegrationRecord."Last Synch. Modified On" then            CRMIntegrationRecord."Last Synch. Modified On" := LastModifiedOn;        if CRMLastModifiedOn > CRMIntegrationRecord."Last Synch. CRM Modified On" then            CRMIntegrationRecord."Last Synch. CRM Modified On" := CRMLastModifiedOn;        CRMIntegrationRecord.Modify(true);    end;    procedure SetLastSynchCRMModifiedOn(CRMID: Guid; DestinationTableID: Integer; CRMLastModifiedOn: DateTime)    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        if FindRowFromCRMID(CRMID, DestinationTableID, CRMIntegrationRecord) then begin            if CRMLastModifiedOn > CRMIntegrationRecord."Last Synch. CRM Modified On" then                CRMIntegrationRecord."Last Synch. CRM Modified On" := CRMLastModifiedOn;            CRMIntegrationRecord.Modify(true);        end;    end;    [Scope('OnPrem')]    procedure IsSameFailureRepeatedTwice(RecRef: RecordRef; LastJobID: Guid; NewJobID: Guid): Boolean    var        IntegrationSynchJob: Record "Integration Synch. Job";        IntegrationSynchJobErrors: Record "Integration Synch. Job Errors";        LastError: Text;        NewError: Text;    begin        if IsNullGuid(LastJobID) or IsNullGuid(NewJobID) then            exit(false);        if IntegrationSynchJob.Get(LastJobID) then            if IntegrationSynchJob.GetErrorForRecordID(RecRef.RecordId, IntegrationSynchJobErrors) then                LastError := IntegrationSynchJobErrors.Message;        if IntegrationSynchJob.Get(NewJobID) then            if IntegrationSynchJob.GetErrorForRecordID(RecRef.RecordId, IntegrationSynchJobErrors) then                NewError := IntegrationSynchJobErrors.Message;        exit((LastError = NewError) and (NewError <> ''));    end;    procedure IsModifiedAfterLastSynchonizedCRMRecord(CRMID: Guid; DestinationTableID: Integer; CurrentModifiedOn: DateTime) IsModified: Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        TypeHelper: Codeunit "Type Helper";        Handled: Boolean;    begin        OnBeforeIsModifiedAfterLastSynchronizedCRMRecord(CRMID, DestinationTableID, CurrentModifiedOn, IsModified, Handled);        if Handled then            exit(IsModified);        if FindRowFromCRMID(CRMID, DestinationTableID, CRMIntegrationRecord) then begin            if (CRMIntegrationRecord."Last Synch. Result" = CRMIntegrationRecord."Last Synch. Result"::Failure) and (CRMIntegrationRecord.Skipped = false) then                exit(true);            exit(TypeHelper.CompareDateTime(CurrentModifiedOn, CRMIntegrationRecord."Last Synch. CRM Modified On") > 0);        end;    end;    procedure IsModifiedAfterLastSynchronizedRecord(RecordID: RecordID; CurrentModifiedOn: DateTime) IsModified: Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        TypeHelper: Codeunit "Type Helper";        Handled: Boolean;    begin        OnBeforeIsModifiedAfterLastSynchronizedRecord(RecordID, CurrentModifiedOn, IsModified, Handled);        if Handled then            exit(IsModified);        if FindRowFromRecordID(RecordID, CRMIntegrationRecord) then begin            if (CRMIntegrationRecord."Last Synch. CRM Result" = CRMIntegrationRecord."Last Synch. CRM Result"::Failure) and (CRMIntegrationRecord.Skipped = false) then                exit(true);            exit(TypeHelper.CompareDateTime(CurrentModifiedOn, CRMIntegrationRecord."Last Synch. Modified On") > 0);        end;    end;    procedure IsModifiedAfterLastSynchronizedRecord(RecordRef: RecordRef; CurrentModifiedOn: DateTime) IsModified: Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMOptionMapping: Record "CRM Option Mapping";        TypeHelper: Codeunit "Type Helper";        Handled: Boolean;    begin        if RecordRef.Number() = 0 then            exit(false);        if IsNullGuid(RecordRef.Field(RecordRef.SystemIdNo()).Value()) then            exit(false);        OnBeforeIsModifiedAfterLastSynchronizedRecord(RecordRef.RecordId(), CurrentModifiedOn, IsModified, Handled);        if Handled then            exit(IsModified);        if FindRowFromRecordRef(RecordRef, CRMIntegrationRecord) then begin            if (CRMIntegrationRecord."Last Synch. CRM Result" = CRMIntegrationRecord."Last Synch. CRM Result"::Failure) and (CRMIntegrationRecord.Skipped = false) then                exit(true);            exit(TypeHelper.CompareDateTime(CurrentModifiedOn, CRMIntegrationRecord."Last Synch. Modified On") > 0);        end;        CRMOptionMapping.SetRange("Record ID", RecordRef.RecordId);        if CRMOptionMapping.FindFirst() then begin            if (CRMOptionMapping."Last Synch. CRM Result" = CRMOptionMapping."Last Synch. CRM Result"::Failure) and (CRMOptionMapping.Skipped = false) then                exit(true);            exit(TypeHelper.CompareDateTime(CurrentModifiedOn, CRMOptionMapping."Last Synch. Modified On") > 0);        end;    end;    local procedure UncoupleCRMIDIfRecordDeleted(TableId: Integer; IntegrationId: Guid): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        RecId: RecordId;    begin        CRMIntegrationRecord."Table ID" := TableId;        CRMIntegrationRecord."Integration ID" := IntegrationId;        if not CRMIntegrationRecord.FindRecordId(RecId) then begin            if FindRowFromIntegrationID(IntegrationId, TableId, CRMIntegrationRecord) then                CRMIntegrationRecord.Delete();            exit(true);        end;    end;    procedure DeleteIfRecordDeleted(CRMID: Guid; DestinationTableID: Integer): Boolean    var        IntegrationID: Guid;    begin        if FindIntegrationIDFromCRMID(CRMID, DestinationTableID, IntegrationID) then            exit(UncoupleCRMIDIfRecordDeleted(DestinationTableID, IntegrationID));    end;    local procedure FindRowFromRecordID(SourceRecordID: RecordID; var CRMIntegrationRecord: Record "CRM Integration Record"): Boolean    var        SysId: Guid;    begin        if FindSystemIdByRecordId(SysId, SourceRecordID) then            exit(FindRowFromIntegrationID(SysId, SourceRecordID.TableNo, CRMIntegrationRecord));    end;    local procedure FindRowFromRecordRef(SourceRecordRef: RecordRef; var CRMIntegrationRecord: Record "CRM Integration Record"): Boolean    var        SysId: Guid;    begin        if FindSystemIdByRecordRef(SysId, SourceRecordRef) then            exit(FindRowFromIntegrationID(SysId, SourceRecordRef.Number, CRMIntegrationRecord));    end;    local procedure FindRowFromCRMID(CRMID: Guid; DestinationTableID: Integer; var CRMIntegrationRecord: Record "CRM Integration Record"): Boolean    begin        CRMIntegrationRecord.SetRange("CRM ID", CRMID);        if DestinationTableID <> 0 then            CRMIntegrationRecord.SetFilter("Table ID", Format(DestinationTableID));        exit(CRMIntegrationRecord.FindFirst());    end;    local procedure FindRowFromIntegrationID(IntegrationID: Guid; TableID: Integer; var CRMIntegrationRecord: Record "CRM Integration Record"): Boolean    begin        CRMIntegrationRecord.SetCurrentKey("Integration ID", "Table ID");        CRMIntegrationRecord.SetFilter("Integration ID", IntegrationID);        CRMIntegrationRecord.SetRange("Table ID", TableID);        exit(CRMIntegrationRecord.FindFirst());    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeIsModifiedAfterLastSynchronizedCRMRecord(CRMID: Guid; DestinationTableID: Integer; CurrentModifiedOn: DateTime; var IsModified: Boolean; var Handled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeIsModifiedAfterLastSynchronizedRecord(RecordID: RecordID; CurrentModifiedOn: DateTime; var IsModified: Boolean; var Handled: Boolean);    begin    end;}