Codeunit 5470 Graph Collection Mgt - Item

Base Application, Microsoft.Integration.Graph

src/Layers/W1/BaseApp/Integration/Graph/GraphCollectionMgtItem.Codeunit.al470 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.Graph;using Microsoft.API.Upgrade;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using System;using System.DateTime;using System.Reflection;using System.Text;codeunit 5470 "Graph Collection Mgt - Item"{    trigger OnRun()    begin    end;    var        TypeHelper: Codeunit "Type Helper";        ItemUOMDescriptionTxt: Label 'Graph CDM - Unit of Measure complex type on Item Entity page', Locked = true;        ItemUOMConversionsDescriptionTxt: Label 'Graph CDM - Unit of Measure Conversions complex type on Item Entity page', Locked = true;        ValueMustBeEqualErr: Label 'Conversions must be specified with %1 with value %2.', Locked = true;        BaseUnitOfMeasureCannotHaveConversionsErr: Label 'Base Unit Of Measure must be specified on the item first.', Locked = true;    [Scope('Cloud')]    procedure InsertItemFromSalesDocument(var Item: Record Item; var TempFieldSet: Record "Field" temporary; UnitOfMeasureJSON: Text)    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";        RecordRef: RecordRef;        ItemModified: Boolean;    begin        if IsNullGuid(Item.SystemId) then            Item.Insert(true)        else            Item.Insert(true, true);        UpdateOrCreateItemUnitOfMeasureFromSalesDocument(UnitOfMeasureJSON, Item, TempFieldSet, ItemModified);        RecordRef.GetTable(Item);        GraphMgtGeneralTools.ProcessNewRecordFromAPI(RecordRef, TempFieldSet, Item."Last DateTime Modified");        RecordRef.SetTable(Item);        Item.Modify(true);    end;    [Scope('Cloud')]    procedure InsertItem(var Item: Record Item; var TempFieldSet: Record "Field" temporary; BaseUnitOfMeasureJSON: Text)    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";        RecordRef: RecordRef;    begin        if IsNullGuid(Item.SystemId) then            Item.Insert(true)        else            Item.Insert(true, true);        ProcessComplexTypes(          Item,          BaseUnitOfMeasureJSON);        RecordRef.GetTable(Item);        GraphMgtGeneralTools.ProcessNewRecordFromAPI(RecordRef, TempFieldSet, Item."Last DateTime Modified");        RecordRef.SetTable(Item);        Item.Modify(true);    end;    [Scope('Cloud')]    procedure InsertItem(var Item: Record Item; var TempFieldSet: Record "Field" temporary)    begin        if IsNullGuid(Item.SystemId) then            Item.Insert(true)        else            Item.Insert(true, true);        ModifyItem(Item, TempFieldSet);    end;    [Scope('Cloud')]    procedure ModifyItem(var Item: Record Item; var TempFieldSet: Record "Field" temporary)    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";        RecordRef: RecordRef;    begin        RecordRef.GetTable(Item);        GraphMgtGeneralTools.ProcessNewRecordFromAPI(RecordRef, TempFieldSet, Item."Last DateTime Modified");        RecordRef.SetTable(Item);        Item.Modify(true);    end;    procedure ProcessComplexTypes(var Item: Record Item; BaseUOMJSON: Text)    begin        UpdateUnitOfMeasure(BaseUOMJSON, Item.FieldNo("Base Unit of Measure"), Item);    end;    procedure ItemUnitOfMeasureToJSON(var Item: Record Item; UnitOfMeasureCode: Code[10]): Text    var        ItemUnitOfMeasure: Record "Item Unit of Measure";        GraphMgtComplexTypes: Codeunit "Graph Mgt - Complex Types";        JSONManagement: Codeunit "JSON Management";        JsonObject: DotNet JObject;        ItemUOMConversionJObject: DotNet JObject;        UnitOfMeasureJSON: Text;    begin        UnitOfMeasureJSON := GraphMgtComplexTypes.GetUnitOfMeasureJSON(UnitOfMeasureCode);        if UnitOfMeasureCode = Item."Base Unit of Measure" then            exit(UnitOfMeasureJSON);        if not ItemUnitOfMeasure.Get(Item."No.", UnitOfMeasureCode) then            exit(UnitOfMeasureJSON);        JSONManagement.InitializeObject(UnitOfMeasureJSON);        JSONManagement.GetJSONObject(JsonObject);        ItemUOMConversionJObject := ItemUOMConversionJObject.JObject();        JSONManagement.AddJPropertyToJObject(          ItemUOMConversionJObject, UOMConversionComplexTypeToUnitOfMeasure(), Item."Base Unit of Measure");        JSONManagement.AddJPropertyToJObject(          ItemUOMConversionJObject, UOMConversionComplexTypeFromToConversionRate(), ItemUnitOfMeasure."Qty. per Unit of Measure");        JSONManagement.AddJObjectToJObject(JsonObject, UOMConversionComplexTypeName(), ItemUOMConversionJObject);        exit(JSONManagement.WriteObjectToString());    end;    procedure UpdateOrCreateItemUnitOfMeasureFromSalesDocument(UnitOfMeasureJSONString: Text; var Item: Record Item; var TempFieldSet: Record "Field" temporary; var ItemModified: Boolean)    var        UnitOfMeasure: Record "Unit of Measure";        TempUnitOfMeasure: Record "Unit of Measure" temporary;        ItemUnitOfMeasure: Record "Item Unit of Measure";        TempItemUnitOfMeasure: Record "Item Unit of Measure" temporary;        ExpectedBaseUOMCode: Code[10];        HasUOMConversions: Boolean;    begin        if UnitOfMeasureJSONString = '' then            exit;        ParseJSONToUnitOfMeasure(UnitOfMeasureJSONString, TempUnitOfMeasure);        HasUOMConversions :=          ParseJSONToItemUnitOfMeasure(UnitOfMeasureJSONString, Item, TempItemUnitOfMeasure, TempUnitOfMeasure, ExpectedBaseUOMCode);        if HasUOMConversions then begin            VerifyBaseUOMIsSet(Item, ExpectedBaseUOMCode);            if not UnitOfMeasure.Get(ExpectedBaseUOMCode) then begin                UnitOfMeasure.Code := ExpectedBaseUOMCode;                UnitOfMeasure.Insert();            end;            if Item."Base Unit of Measure" = '' then begin                Item.Validate("Base Unit of Measure", UnitOfMeasure.Code);                RegisterFieldSet(TempFieldSet, Item.FieldNo("Unit of Measure Id"));                RegisterFieldSet(TempFieldSet, Item.FieldNo("Base Unit of Measure"));                ItemModified := true;            end;            InsertOrUpdateItemUnitOfMeasureRecord(ItemUnitOfMeasure, TempItemUnitOfMeasure);        end else begin            InsertOrUpdateUnitOfMeasureRecord(UnitOfMeasure, TempUnitOfMeasure);            if Item."Base Unit of Measure" = '' then begin                Item.Validate("Base Unit of Measure", UnitOfMeasure.Code);                RegisterFieldSet(TempFieldSet, Item.FieldNo("Unit of Measure Id"));                RegisterFieldSet(TempFieldSet, Item.FieldNo("Base Unit of Measure"));                ItemModified := true;            end else begin                // Create on the fly if it does not exist                if ItemUnitOfMeasure.Get(Item."No.", UnitOfMeasure.Code) then                    exit;                ItemUnitOfMeasure."Item No." := Item."No.";                ItemUnitOfMeasure.Code := UnitOfMeasure.Code;                ItemUnitOfMeasure."Qty. per Unit of Measure" := 1;                ItemUnitOfMeasure.Insert(true);            end;        end;    end;    procedure UpdateUnitOfMeasure(UnitOfMeasureJSONString: Text; UnitOfMeasureFieldNo: Integer; var Item: Record Item)    var        UnitOfMeasure: Record "Unit of Measure";        TempUnitOfMeasure: Record "Unit of Measure" temporary;        ItemUnitOfMeasure: Record "Item Unit of Measure";        TempItemUnitOfMeasure: Record "Item Unit of Measure" temporary;        ItemRecordRef: RecordRef;        UnitOfMeasureFieldRef: FieldRef;        PreviousUnitOfMeasureJSONString: Text;        PreviousUOMCode: Code[10];        HasUOMConversions: Boolean;        BaseUnitOfMeasureCode: Code[10];    begin        if UnitOfMeasureJSONString = '' then            exit;        ItemRecordRef.GetTable(Item);        UnitOfMeasureFieldRef := ItemRecordRef.Field(UnitOfMeasureFieldNo);        if UnitOfMeasureJSONString = 'null' then begin            UnitOfMeasureFieldRef.Validate('');            ItemRecordRef.SetTable(Item);            exit;        end;        PreviousUOMCode := UnitOfMeasureFieldRef.Value();        PreviousUnitOfMeasureJSONString := ItemUnitOfMeasureToJSON(Item, PreviousUOMCode);        if UnitOfMeasureJSONString = PreviousUnitOfMeasureJSONString then            exit;        ParseJSONToUnitOfMeasure(UnitOfMeasureJSONString, TempUnitOfMeasure);        HasUOMConversions :=          ParseJSONToItemUnitOfMeasure(UnitOfMeasureJSONString, Item, TempItemUnitOfMeasure, TempUnitOfMeasure, BaseUnitOfMeasureCode);        if HasUOMConversions and (UnitOfMeasureFieldNo = Item.FieldNo("Base Unit of Measure")) then            Error(BaseUnitOfMeasureCannotHaveConversionsErr);        InsertOrUpdateUnitOfMeasureRecord(UnitOfMeasure, TempUnitOfMeasure);        if HasUOMConversions then            InsertOrUpdateItemUnitOfMeasureRecord(ItemUnitOfMeasure, TempItemUnitOfMeasure);        if PreviousUOMCode <> UnitOfMeasure.Code then            UnitOfMeasureFieldRef.Validate(UnitOfMeasure.Code);        ItemRecordRef.SetTable(Item);    end;    local procedure InsertOrUpdateUnitOfMeasureRecord(var UnitOfMeasure: Record "Unit of Measure"; var TempUnitOfMeasure: Record "Unit of Measure" temporary)    var        DoModify: Boolean;    begin        if TempUnitOfMeasure.Code = '' then            exit;        if not UnitOfMeasure.Get(TempUnitOfMeasure.Code) then begin            UnitOfMeasure.TransferFields(TempUnitOfMeasure, true);            UnitOfMeasure.Insert(true);            exit;        end;        if not (TempUnitOfMeasure.Description in [UnitOfMeasure.Description, '']) then begin            UnitOfMeasure.Validate(Description, TempUnitOfMeasure.Description);            DoModify := true;        end;        if not (TempUnitOfMeasure.Symbol in [UnitOfMeasure.Symbol, '']) then begin            UnitOfMeasure.Validate(Symbol, TempUnitOfMeasure.Symbol);            DoModify := true;        end;        if DoModify then            UnitOfMeasure.Modify(true);    end;    local procedure InsertOrUpdateItemUnitOfMeasureRecord(var ItemUnitOfMeasure: Record "Item Unit of Measure"; var TempItemUnitOfMeasure: Record "Item Unit of Measure" temporary)    begin        if not ItemUnitOfMeasure.Get(TempItemUnitOfMeasure."Item No.", TempItemUnitOfMeasure.Code) then begin            ItemUnitOfMeasure.TransferFields(TempItemUnitOfMeasure, true);            ItemUnitOfMeasure.Insert(true);        end else begin            if TempItemUnitOfMeasure."Qty. per Unit of Measure" = ItemUnitOfMeasure."Qty. per Unit of Measure" then                exit;            ItemUnitOfMeasure.Validate("Qty. per Unit of Measure", TempItemUnitOfMeasure."Qty. per Unit of Measure");            ItemUnitOfMeasure.Modify(true);        end;    end;    procedure ParseJSONToUnitOfMeasure(UnitOfMeasureJSONString: Text; var UnitOfMeasure: Record "Unit of Measure")    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";        JSONManagement: Codeunit "JSON Management";        JsonObject: DotNet JObject;        UnitCode: Text;    begin        JSONManagement.InitializeObject(UnitOfMeasureJSONString);        JSONManagement.GetJSONObject(JsonObject);        GraphMgtGeneralTools.GetMandatoryStringPropertyFromJObject(JsonObject, UOMComplexTypeUnitCode(), UnitCode);        UnitOfMeasure.Code := CopyStr(UnitCode, 1, MaxStrLen(UnitOfMeasure.Code));        JSONManagement.GetStringPropertyValueFromJObjectByName(JsonObject, UOMComplexTypeUnitName(), UnitOfMeasure.Description);        JSONManagement.GetStringPropertyValueFromJObjectByName(JsonObject, UOMComplexTypeSymbol(), UnitOfMeasure.Symbol);    end;    local procedure ParseJSONToItemUnitOfMeasure(UnitOfMeasureJSONString: Text; var Item: Record Item; var TempItemUnitOfMeasure: Record "Item Unit of Measure" temporary; var UnitOfMeasure: Record "Unit of Measure"; var BaseUnitOfMeasureCode: Code[10]): Boolean    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";        JSONManagement: Codeunit "JSON Management";        JsonObject: DotNet JObject;        ConversionsTxt: Text;        FromToConversionRateTxt: Text;        BaseUnitOfMeasureTxt: Text;    begin        JSONManagement.InitializeObject(UnitOfMeasureJSONString);        JSONManagement.GetJSONObject(JsonObject);        if not JSONManagement.GetStringPropertyValueFromJObjectByName(JsonObject, UOMConversionComplexTypeName(), ConversionsTxt) then            exit(false);        if ConversionsTxt = '' then            exit(false);        if ConversionsTxt = 'null' then            exit(false);        JSONManagement.InitializeObject(ConversionsTxt);        JSONManagement.GetJSONObject(JsonObject);        GraphMgtGeneralTools.GetMandatoryStringPropertyFromJObject(          JsonObject, UOMConversionComplexTypeToUnitOfMeasure(), BaseUnitOfMeasureTxt);        BaseUnitOfMeasureCode := CopyStr(BaseUnitOfMeasureTxt, 1, 10);        GraphMgtGeneralTools.GetMandatoryStringPropertyFromJObject(          JsonObject, UOMConversionComplexTypeFromToConversionRate(), FromToConversionRateTxt);        Evaluate(TempItemUnitOfMeasure."Qty. per Unit of Measure", FromToConversionRateTxt);        TempItemUnitOfMeasure."Item No." := Item."No.";        TempItemUnitOfMeasure.Code := UnitOfMeasure.Code;        TempItemUnitOfMeasure.Insert();        exit(true);    end;    [Scope('OnPrem')]    procedure WriteItemEDMComplexTypes()    var        GraphMgtGeneralTools: Codeunit "Graph Mgt - General Tools";    begin        GraphMgtGeneralTools.InsertOrUpdateODataType('ITEM-UOM', ItemUOMDescriptionTxt, GetItemUOMEDM('ITEM-UOM-CONVERSION'));        GraphMgtGeneralTools.InsertOrUpdateODataType('ITEM-UOM-CONVERSION', ItemUOMConversionsDescriptionTxt, GetItemUOMConversionEDM());    end;    local procedure GetItemUOMEDM(UOMConversionDefinitionCode: Code[50]): Text    var        DummyUnitOfMeasure: Record "Unit of Measure";    begin        exit(          '<ComplexType Name="unitOfMeasureType">' +          StrSubstNo('<Property Name="%1" Type="Edm.String" Nullable="true" MaxLength="%2" />',            UOMComplexTypeUnitCode(), MaxStrLen(DummyUnitOfMeasure.Code)) +          StrSubstNo('<Property Name="%1" Type="Edm.String" Nullable="true" MaxLength="%2" />',            UOMComplexTypeUnitName(), MaxStrLen(DummyUnitOfMeasure.Description)) +          StrSubstNo('<Property Name="%1" Type="Edm.String" Nullable="true" MaxLength="%2" />',            UOMComplexTypeSymbol(), MaxStrLen(DummyUnitOfMeasure.Symbol)) +          StrSubstNo('<Property Name="%1" Type="%2" Nullable="true" />',            UOMConversionComplexTypeName(), UOMConversionDefinitionCode) +          '</ComplexType>');    end;    local procedure GetItemUOMConversionEDM(): Text    var        DummyItem: Record Item;    begin        exit(          '<ComplexType Name="itemUnitOfMeasureConversionType">' +          StrSubstNo('<Property Name="%1" Type="Edm.String" Nullable="true" MaxLength="%2" />',            UOMConversionComplexTypeToUnitOfMeasure(), MaxStrLen(DummyItem."Base Unit of Measure")) +          StrSubstNo('<Property Name="%1" Type="Edm.Decimal" Nullable="true" />',            UOMConversionComplexTypeFromToConversionRate()) +          '</ComplexType>');    end;    local procedure EnableItemODataWebService()    begin        WriteItemEDMComplexTypes();    end;    procedure SetLastDateTimeModified()    var        Item: Record Item;        DotNetDateTimeOffset: Codeunit DotNet_DateTimeOffset;        CombinedDateTime: DateTime;    begin        Item.SetRange("Last DateTime Modified", 0DT);        if not Item.FindSet() then            exit;        repeat            CombinedDateTime := CreateDateTime(Item."Last Date Modified", Item."Last Time Modified");            Item."Last DateTime Modified" := DotNetDateTimeOffset.ConvertToUtcDateTime(CombinedDateTime);            Item.Modify();        until Item.Next() = 0;    end;    local procedure RegisterFieldSet(var TempFieldSet: Record "Field" temporary; FieldNo: Integer)    begin        if TypeHelper.GetField(DATABASE::Item, FieldNo, TempFieldSet) then            exit;        TempFieldSet.Init();        TempFieldSet.TableNo := DATABASE::Item;        TempFieldSet.Validate("No.", FieldNo);        TempFieldSet.Insert(true);    end;    procedure UOMComplexTypeUnitCode(): Text    begin        exit('code');    end;    procedure UOMComplexTypeUnitName(): Text    begin        exit('displayName');    end;    procedure UOMComplexTypeSymbol(): Text    begin        exit('symbol');    end;    procedure UOMConversionComplexTypeName(): Text    begin        exit('unitConversion');    end;    procedure UOMConversionComplexTypeToUnitOfMeasure(): Text    begin        exit('toUnitOfMeasure');    end;    procedure UOMConversionComplexTypeFromToConversionRate(): Text    begin        exit('fromToConversionRate');    end;    local procedure VerifyBaseUOMIsSet(var Item: Record Item; BaseUnitOfMeasure: Code[20])    begin        if Item."Base Unit of Measure" = '' then            exit;        if Item."Base Unit of Measure" <> UpperCase(BaseUnitOfMeasure) then            Error(ValueMustBeEqualErr, UOMConversionComplexTypeToUnitOfMeasure(), Item."Base Unit of Measure");    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Graph Mgt - General Tools", 'ApiSetup', '', false, false)]    local procedure HandleApiSetup()    begin        EnableItemODataWebService();        UpdateIds();    end;    procedure UpdateIds()    begin        UpdateIds(false);    end;    procedure UpdateIds(WithCommit: Boolean)    var        Item: Record Item;        APIDataUpgrade: Codeunit "API Data Upgrade";        RecordCount: Integer;    begin        if not Item.FindSet(true) then            exit;        repeat            Item.UpdateReferencedIds();            Item.Modify(false);            if WithCommit then                APIDataUpgrade.CountRecordsAndCommit(RecordCount);        until Item.Next() = 0;        if WithCommit then            Commit();    end;}