Table 5392 CRM Annotation Coupling

Base Application, Microsoft.Integration.D365Sales

src/Layers/W1/BaseApp/Integration/D365Sales/CRMAnnotationCoupling.Table.al120 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.D365Sales;using System;using System.Environment.Configuration;using System.Utilities;table 5392 "CRM Annotation Coupling"{    Caption = 'CRM Annotation Coupling';    DataClassification = CustomerContent;    fields    {        field(2; "Record Link Record ID"; RecordID)        {            Caption = 'Record Link Record ID';            DataClassification = CustomerContent;        }        field(3; "CRM Annotation ID"; Guid)        {            Caption = 'CRM Annotation ID';            DataClassification = SystemMetadata;        }        field(4; "Last Synch. DateTime"; DateTime)        {            Caption = 'Last Synch. DateTime';            DataClassification = SystemMetadata;        }        field(5; "CRM Created On"; DateTime)        {            Caption = 'CRM Created On';            DataClassification = SystemMetadata;        }        field(6; "CRM Modified On"; DateTime)        {            Caption = 'CRM Modified On';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; "Record Link Record ID", "CRM Annotation ID")        {            Clustered = true;        }        key(Key2; "Last Synch. DateTime")        {        }        key(Key3; "CRM Created On")        {        }        key(Key4; "CRM Modified On")        {        }    }    fieldgroups    {    }    var        RecordLinkAlreadyCoupledErr: Label 'Record Link %1 is already coupled to another CRM Annotation.', Comment = '%1 - an integer';        CRMAnnotationAlreadyCoupledErr: Label 'CRM Annotation %1 is already coupled to another Record Link.', Comment = '%1 - a GUID';    [Scope('OnPrem')]    procedure CoupleRecordLinkToCRMAnnotation(RecordLink: Record "Record Link"; CRMAnnotation: Record "CRM Annotation")    begin        if Get(RecordLink.RecordId, CRMAnnotation.AnnotationId) then            exit;        if FindByRecordId(RecordLink.RecordId) then            Error(RecordLinkAlreadyCoupledErr, RecordLink."Link ID");        if FindByCRMId(CRMAnnotation.AnnotationId) then            Error(CRMAnnotationAlreadyCoupledErr, CRMAnnotation.AnnotationId);        Init();        "Record Link Record ID" := RecordLink.RecordId;        "CRM Annotation ID" := CRMAnnotation.AnnotationId;        "Last Synch. DateTime" := CurrentDateTime;        "CRM Created On" := CRMAnnotation.CreatedOn;        "CRM Modified On" := CRMAnnotation.ModifiedOn;        Insert();    end;    [Scope('OnPrem')]    procedure FindByRecordId(RecordId: RecordID): Boolean    begin        SetRange("Record Link Record ID", RecordId);        exit(FindFirst());    end;    [Scope('OnPrem')]    procedure FindByCRMId(CRMId: Guid): Boolean    begin        SetRange("CRM Annotation ID", CRMId);        exit(FindFirst());    end;    procedure ExtractNoteText(AnnotationText: Text): Text    var        Regex: Codeunit Regex;        HttpUtility: DotNet HttpUtility;        LF: Char;    begin        LF := 10;        AnnotationText := Regex.Replace(AnnotationText, '</p>', Format(LF));        AnnotationText := Regex.Replace(AnnotationText, '<.*?>', '');        AnnotationText := AnnotationText.Trim();        AnnotationText := HttpUtility.HtmlDecode(AnnotationText);        exit(AnnotationText);    end;}