Codeunit 5352 CRM Order Status Update Job

Base Application, Microsoft.Integration.D365Sales

src/Layers/W1/BaseApp/Integration/D365Sales/CRMOrderStatusUpdateJob.Codeunit.al269 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 Microsoft.Integration.Dataverse;using Microsoft.Integration.SyncEngine;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using System.Threading;codeunit 5352 "CRM Order Status Update Job"{    TableNo = "Job Queue Entry";    trigger OnRun()    begin        UpdateOrders(Rec.GetLastLogEntryNo());    end;    var        CRMProductName: Codeunit "CRM Product Name";        ConnectionNotEnabledErr: Label 'The %1 connection is not enabled.', Comment = '%1 = CRM product name';        OrderStatusUpdatedMsg: Label 'Sent messages about status change of sales orders.';        OrderStatusReleasedTxt: Label 'The order status has changed to Released.';        OrderShipmentCreatedTxt: Label 'A shipment has been created for the order.';        OrderInvoiceCreatedTxt: Label 'An invoice has been created for the order.';        FailedToCreatePostErr: Label 'Failed to create a post on the entity wall of %1 with id %2.', Locked = true;        CategoryTok: Label 'AL Dataverse Integration', Locked = true;    local procedure UpdateOrders(JobLogEntryNo: Integer)    var        CRMConnectionSetup: Record "CRM Connection Setup";        ConnectionName: Text;    begin        CRMConnectionSetup.Get();        if not CRMConnectionSetup."Is Enabled" then            Error(ConnectionNotEnabledErr, CRMProductName.FULL());        ConnectionName := Format(CreateGuid());        CRMConnectionSetup.RegisterConnectionWithName(ConnectionName);        SetDefaultTableConnection(          TABLECONNECTIONTYPE::CRM, CRMConnectionSetup.GetDefaultCRMConnection(ConnectionName));        UpdateSalesOrders(JobLogEntryNo);        CRMConnectionSetup.UnregisterConnectionWithName(ConnectionName);    end;    local procedure UpdateSalesOrders(JobLogEntryNo: Integer)    var        IntegrationTableMapping: Record "Integration Table Mapping";        IntegrationTableSynch: Codeunit "Integration Table Synch.";        SynchActionType: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete;        Counter: Integer;    begin        IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse);        IntegrationTableMapping.SetRange("Table ID", DATABASE::"Sales Header");        OnUpdateSalesOrdersOnBeforeFindIntegrationTableMapping(IntegrationTableMapping);        if IntegrationTableMapping.FindFirst() then            IntegrationTableSynch.BeginIntegrationSynchJob(TABLECONNECTIONTYPE::CRM, IntegrationTableMapping, DATABASE::"Sales Header")        else            IntegrationTableSynch.BeginIntegrationSynchJobLoging(TABLECONNECTIONTYPE::CRM, CODEUNIT::"CRM Order Status Update Job", JobLogEntryNo, DATABASE::"Sales Header");        Counter := CreateStatusPostOnModifiedOrders();        IntegrationTableSynch.UpdateSynchJobCounters(SynchActionType::Modify, Counter);        IntegrationTableSynch.EndIntegrationSynchJobWithMsg(GetOrderStatusUpdateFinalMessage());    end;    procedure GetOrderStatusUpdateFinalMessage(): Text    begin        exit(OrderStatusUpdatedMsg);    end;    [EventSubscriber(ObjectType::Table, Database::"Job Queue Entry", 'OnFindingIfJobNeedsToBeRun', '', false, false)]    local procedure OnFindingIfJobNeedsToBeRun(var Sender: Record "Job Queue Entry"; var Result: Boolean)    var        CRMConnectionSetup: Record "CRM Connection Setup";        CRMPostBuffer: Record "CRM Post Buffer";    begin        if Result then            exit;        if Sender."Object Type to Run" <> Sender."Object Type to Run"::Codeunit then            exit;        if Sender."Object ID to Run" <> CODEUNIT::"CRM Order Status Update Job" then            exit;        if not CRMConnectionSetup.Get() then            exit;        if not CRMConnectionSetup."Is Enabled" then            exit;        CRMPostBuffer.SetFilter("Table ID", Format(DATABASE::"Sales Header") + '|' + Format(Database::Customer));        if not CRMPostBuffer.IsEmpty() then            Result := true;    end;    [TryFunction]    local procedure TryCreatePost(var CRMSalesorder: Record "CRM Salesorder"; Message: Text)    var        CRMPost: Record "CRM Post";    begin        CRMPost.PostId := CreateGuid();        CRMPost.RegardingObjectId := CRMSalesorder.SalesOrderId;        CRMPost.RegardingObjectTypeCode := CRMPost.RegardingObjectTypeCode::salesorder;        CRMPost.Text := CopyStr(Message, 1, MaxStrLen(CRMPost.Text));        CRMPost.Insert();    end;    [TryFunction]    local procedure TryCreatePost(var CRMAccount: Record "CRM Account"; Message: Text)    var        CRMPost: Record "CRM Post";    begin        CRMPost.PostId := CreateGuid();        CRMPost.RegardingObjectId := CRMAccount.AccountId;        CRMPost.RegardingObjectTypeCode := CRMPost.RegardingObjectTypeCode::account;        CRMPost.Text := CopyStr(Message, 1, MaxStrLen(CRMPost.Text));        CRMPost.Insert();    end;    local procedure FindCoupledCRMSalesOrder(var CRMSalesorder: Record "CRM Salesorder"; SalesHeader: Record "Sales Header"): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMIntegrationManagement: Codeunit "CRM Integration Management";    begin        if not CRMIntegrationManagement.IsCRMIntegrationEnabled() then            exit(false);        if not CRMIntegrationRecord.FindIDFromRecordID(SalesHeader.RecordId, CRMSalesorder.SalesOrderId) then            exit(false);        if not CRMSalesorder.Find() then            exit(false);        exit(true);    end;    local procedure FindCoupledCRMAccount(var CRMAccount: Record "CRM Account"; Customer: Record Customer): Boolean    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMIntegrationManagement: Codeunit "CRM Integration Management";    begin        if not CRMIntegrationManagement.IsCRMIntegrationEnabled() then            exit(false);        if not CRMIntegrationRecord.FindIDFromRecordID(Customer.RecordId, CRMAccount.AccountId) then            exit(false);        if not CRMAccount.Find() then            exit(false);        exit(true);    end;    [Scope('OnPrem')]    procedure CreateStatusPostOnModifiedOrders() CreatedPosts: Integer    var        CRMPostBuffer: Record "CRM Post Buffer";        TempCRMPostBuffer: Record "CRM Post Buffer" temporary;    begin        CRMPostBuffer.ReadIsolation := CRMPostBuffer.ReadIsolation::ReadCommitted;        CRMPostBuffer.SetRange("Table ID", DATABASE::"Sales Header");        if not CRMPostBuffer.FindSet() then            exit;        repeat            TempCRMPostBuffer.TransferFields(CRMPostBuffer);            TempCRMPostBuffer.Insert();        until CRMPostBuffer.Next() = 0;        if TempCRMPostBuffer.FindSet() then            repeat                CreatedPosts += ProcessCRMPostBufferEntry(TempCRMPostBuffer);            until TempCRMPostBuffer.Next() = 0;    end;    local procedure ProcessCRMPostBufferEntry(var TempCRMPostBuffer: Record "CRM Post Buffer" temporary): Integer    var        CRMSalesorder: Record "CRM Salesorder";        CRMAccount: Record "CRM Account";        SalesHeader: Record "Sales Header";        Customer: Record Customer;        SalesHeaderFound: Boolean;        CustomerFound: Boolean;    begin        if TempCRMPostBuffer."Table ID" <> DATABASE::"Sales Header" then            if TempCRMPostBuffer."Table ID" <> Database::Customer then                exit(0);        if SalesHeader.Get(TempCRMPostBuffer.RecId) then            SalesHeaderFound := true        else            if Customer.Get(TempCRMPostBuffer.RecId) then                CustomerFound := true;        if not (CustomerFound or SalesHeaderFound) then begin            DeleteCRMPostBufferEntry(TempCRMPostBuffer);            exit(0);        end;        if SalesHeaderFound then begin            if SalesHeader."Document Type" <> SalesHeader."Document Type"::Order then                exit(0);            if not FindCoupledCRMSalesOrder(CRMSalesorder, SalesHeader) then begin                DeleteCRMPostBufferEntry(TempCRMPostBuffer);                exit(0);            end;            case TempCRMPostBuffer.ChangeType of                TempCRMPostBuffer.ChangeType::SalesDocReleased:                    if not TryCreatePost(CRMSalesorder, OrderStatusReleasedTxt) then begin                        ClearLastError();                        Session.LogMessage('0000KOV', StrSubstNo(FailedToCreatePostErr, CRMSalesorder.TableCaption(), CRMSalesorder.OrderNumber), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);                    end;                TempCRMPostBuffer.ChangeType::SalesShptHeaderCreated:                    if not TryCreatePost(CRMSalesorder, OrderShipmentCreatedTxt) then begin                        ClearLastError();                        Session.LogMessage('0000KOV', StrSubstNo(FailedToCreatePostErr, CRMSalesorder.TableCaption(), CRMSalesorder.OrderNumber), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);                    end;                TempCRMPostBuffer.ChangeType::SalesInvHeaderCreated:                    if not TryCreatePost(CRMSalesorder, OrderInvoiceCreatedTxt) then begin                        ClearLastError();                        Session.LogMessage('0000KOV', StrSubstNo(FailedToCreatePostErr, CRMSalesorder.TableCaption(), CRMSalesorder.OrderNumber), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);                    end;            end;            DeleteCRMPostBufferEntry(TempCRMPostBuffer);            exit(1);        end;        if CustomerFound then begin            if not FindCoupledCRMAccount(CRMAccount, Customer) then begin                DeleteCRMPostBufferEntry(TempCRMPostBuffer);                exit(0);            end;            if not TryCreatePost(CRMAccount, TempCRMPostBuffer.Message) then begin                ClearLastError();                Session.LogMessage('0000M64', StrSubstNo(FailedToCreatePostErr, CRMAccount.TableCaption(), CRMAccount.AccountNumber), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok);            end;            DeleteCRMPostBufferEntry(TempCRMPostBuffer);            exit(1);        end;    end;    local procedure DeleteCRMPostBufferEntry(var TempCRMPostBuffer: Record "CRM Post Buffer" temporary)    var        CRMPostBuffer: Record "CRM Post Buffer";    begin        if CRMPostBuffer.Get(TempCRMPostBuffer.ID) then            CRMPostBuffer.Delete();    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateSalesOrdersOnBeforeFindIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping")    begin    end;}