Table 5468 Picture Entity

Base Application, Microsoft.Integration.Entity

src/Layers/W1/BaseApp/Integration/Entity/PictureEntity.Table.al632 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.Entity;using Microsoft.CRM.Contact;using Microsoft.HumanResources.Employee;using Microsoft.Inventory.Item;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.Environment;using System.Reflection;table 5468 "Picture Entity"{    Caption = 'Picture Entity';    DataClassification = CustomerContent;    fields    {        field(1; Id; Guid)        {            Caption = 'Id';            DataClassification = SystemMetadata;            Editable = false;        }        field(11; Width; Integer)        {            Caption = 'Width';            DataClassification = SystemMetadata;            Editable = false;        }        field(12; Height; Integer)        {            Caption = 'Height';            DataClassification = SystemMetadata;            Editable = false;        }        field(13; "Mime Type"; Text[100])        {            Caption = 'Mime Type';            DataClassification = SystemMetadata;            Editable = false;        }        field(20; Content; BLOB)        {            Caption = 'Content';            DataClassification = SystemMetadata;        }        field(21; "Parent Type"; Enum "Picture Entity Parent Type")        {            Caption = 'Parent Type';            DataClassification = SystemMetadata;            Editable = false;        }    }    keys    {        key(Key1; Id)        {            Clustered = true;        }    }    fieldgroups    {    }    var        IdNotProvidedErr: Label 'You must specify a resource ID to get the picture.', Locked = true;        RequestedRecordDoesNotExistErr: Label 'No resource with the specified ID exists.', Locked = true;        RequestedRecordIsNotSupportedErr: Label 'Images are not supported for requested entity - %1.', Locked = true;        EntityNotSupportedErr: Label 'Given parent type is not supported.';        MultipleParentsFoundErr: Label 'Multiple parents have been found for the specified criteria.';        MediaExtensionWithNumNameTxt: Label '%1 %2.%3', Locked = true;        MediaExtensionWithNumFullNameTxt: Label '%1 %2 %3.%4', Locked = true;        MediaExtensionWithNumOnlyTxt: Label '%1.%2', Locked = true;    [Scope('OnPrem')]    procedure LoadData(IdFilter: Text)    var        ParentRecordRef: RecordRef;        MediaID: Guid;    begin        FindRecordFromFilter(ParentRecordRef, IdFilter);        Id := ParentRecordRef.Field(ParentRecordRef.SystemIdNo).Value();        MediaID := GetMediaID(ParentRecordRef);        SetValuesFromMediaID(MediaID);    end;    procedure LoadDataWithParentType(IdFilter: Text; ParentType: Enum "Picture Entity Parent Type")    var        MediaID: Guid;    begin        Id := IdFilter;        "Parent Type" := ParentType;        MediaID := GetMediaIDWithParentType(Id, ParentType);        SetValuesFromMediaID(MediaID);    end;    [Scope('OnPrem')]    procedure SavePicture()    var        Customer: Record Customer;        Item: Record Item;        ItemVariant: Record "Item Variant";        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ParentRecordRef: RecordRef;        ImageInStream: InStream;        IsHandled: Boolean;    begin        FindRecordFromFilter(ParentRecordRef, StrSubstNo('=%1', Id));        Content.CreateInStream(ImageInStream);        case ParentRecordRef.Number of            DATABASE::Item:                begin                    Item.Get(ParentRecordRef.RecordId);                    Clear(Item.Picture);                    Item.Picture.ImportStream(ImageInStream, GetDefaultMediaDescription(Item));                    Item.Modify(true);                end;            DATABASE::Customer:                begin                    Customer.Get(ParentRecordRef.RecordId);                    Clear(Customer.Image);                    Customer.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Customer));                    Customer.Modify(true);                end;            DATABASE::Vendor:                begin                    Vendor.Get(ParentRecordRef.RecordId);                    Clear(Vendor.Image);                    Vendor.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Vendor));                    Vendor.Modify(true);                end;            DATABASE::Employee:                begin                    Employee.Get(ParentRecordRef.RecordId);                    Clear(Employee.Image);                    Employee.Image.ImportStream(                      ImageInStream, GetDefaultMediaDescription(Employee));                    Employee.Modify(true);                end;            DATABASE::Contact:                begin                    Contact.Get(ParentRecordRef.RecordId);                    Clear(Contact.Image);                    Contact.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Contact));                    Contact.Modify(true);                end;            DATABASE::"Item Variant":                begin                    ItemVariant.Get(ParentRecordRef.RecordId);                    Clear(ItemVariant.Picture);                    ItemVariant.Picture.ImportStream(ImageInStream, GetDefaultMediaDescription(ItemVariant));                    ItemVariant.Modify(true);                end;            else begin                OnSavePictureElseCase(ParentRecordRef, IsHandled);                if not IsHandled then                    ThrowEntityNotSupportedError(ParentRecordRef.Number);            end;        end;        LoadData(StrSubstNo('=%1', Id));    end;    procedure SavePictureWithParentType()    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        ImageInStream: InStream;    begin        Content.CreateInStream(ImageInStream);        case "Parent Type" of            "Parent Type"::Item:                if Item.GetBySystemId(Id) then begin                    Clear(Item.Picture);                    Item.Picture.ImportStream(ImageInStream, GetDefaultMediaDescription(Item));                    Item.Modify(true);                end;            "Parent Type"::Customer:                if Customer.GetBySystemId(Id) then begin                    Clear(Customer.Image);                    Customer.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Customer));                    Customer.Modify(true);                end;            "Parent Type"::Vendor:                if Vendor.GetBySystemId(Id) then begin                    Clear(Vendor.Image);                    Vendor.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Vendor));                    Vendor.Modify(true);                end;            "Parent Type"::Employee:                if Employee.GetBySystemId(Id) then begin                    Clear(Employee.Image);                    Employee.Image.ImportStream(                      ImageInStream, GetDefaultMediaDescription(Employee));                    Employee.Modify(true);                end;            "Parent Type"::Contact:                if Contact.GetBySystemId(Id) then begin                    Clear(Contact.Image);                    Contact.Image.ImportStream(ImageInStream, GetDefaultMediaDescription(Contact));                    Contact.Modify(true);                end;            "Parent Type"::"Item Variant":                if ItemVariant.GetBySystemId(Id) then begin                    Clear(ItemVariant.Picture);                    ItemVariant.Picture.ImportStream(ImageInStream, GetDefaultMediaDescription(ItemVariant));                    ItemVariant.Modify(true);                end;            else                Error(EntityNotSupportedErr);        end;        LoadDataWithParentType(Format(Id), "Parent Type");    end;    procedure DeletePicture()    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        ParentRecordRef: RecordRef;        IsHandled: Boolean;    begin        FindRecordFromFilter(ParentRecordRef, StrSubstNo('=%1', Id));        case ParentRecordRef.Number of            DATABASE::Item:                begin                    Item.Get(ParentRecordRef.RecordId);                    Clear(Item.Picture);                    Item.Modify(true);                end;            DATABASE::Customer:                begin                    Customer.Get(ParentRecordRef.RecordId);                    Clear(Customer.Image);                    Customer.Modify(true);                end;            DATABASE::Vendor:                begin                    Vendor.Get(ParentRecordRef.RecordId);                    Clear(Vendor.Image);                    Vendor.Modify(true);                end;            DATABASE::Employee:                begin                    Employee.Get(ParentRecordRef.RecordId);                    Clear(Employee.Image);                    Employee.Modify(true);                end;            DATABASE::Contact:                begin                    Contact.Get(ParentRecordRef.RecordId);                    Clear(Contact.Image);                    Contact.Modify(true);                end;            DATABASE::"Item Variant":                begin                    ItemVariant.Get(ParentRecordRef.RecordId);                    Clear(ItemVariant.Picture);                    ItemVariant.Modify(true);                end;            else begin                IsHandled := false;                OnDeletePictureElseCase(ParentRecordRef, IsHandled);                if not IsHandled then                    ThrowEntityNotSupportedError(ParentRecordRef.Number);            end;        end;        Clear(Rec);        Id := ParentRecordRef.Field(ParentRecordRef.SystemIdNo).Value();    end;    procedure DeletePictureWithParentType()    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        TempId: Guid;        TempParentType: Enum "Picture Entity Parent Type";    begin        case "Parent Type" of            "Parent Type"::Item:                if Item.GetBySystemId(Id) then begin                    Clear(Item.Picture);                    Item.Modify(true);                end;            "Parent Type"::Customer:                if Customer.GetBySystemId(Id) then begin                    Clear(Customer.Image);                    Customer.Modify(true);                end;            "Parent Type"::Vendor:                if Vendor.GetBySystemId(Id) then begin                    Clear(Vendor.Image);                    Vendor.Modify(true);                end;            "Parent Type"::Employee:                if Employee.GetBySystemId(Id) then begin                    Clear(Employee.Image);                    Employee.Modify(true);                end;            "Parent Type"::Contact:                if Contact.GetBySystemId(Id) then begin                    Clear(Contact.Image);                    Contact.Modify(true);                end;            "Parent Type"::"Item Variant":                if ItemVariant.GetBySystemId(Id) then begin                    Clear(ItemVariant.Picture);                    ItemVariant.Modify(true);                end;            else                Error(EntityNotSupportedErr);        end;        TempId := Id;        TempParentType := "Parent Type";        Clear(Rec);        Id := TempId;        "Parent Type" := TempParentType;    end;    local procedure GetMediaIDWithParentType(ParentId: Guid; ParentType: Enum "Picture Entity Parent Type"): Guid    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        MediaID: Guid;    begin        case ParentType of            "Parent Type"::Item:                if Item.GetBySystemId(ParentId) then                    if Item.Picture.Count > 0 then                        MediaID := Item.Picture.Item(1);            "Parent Type"::Customer:                if Customer.GetBySystemId(ParentId) then                    MediaID := Customer.Image.MediaId;            "Parent Type"::Vendor:                if Vendor.GetBySystemId(ParentId) then                    MediaID := Vendor.Image.MediaId;            "Parent Type"::Employee:                if Employee.GetBySystemId(ParentId) then                    MediaID := Employee.Image.MediaId;            "Parent Type"::Contact:                if Contact.GetBySystemId(ParentId) then                    MediaID := Contact.Image.MediaId;            "Parent Type"::"Item Variant":                if ItemVariant.GetBySystemId(ParentId) then                    if ItemVariant.Picture.Count > 0 then                        MediaID := ItemVariant.Picture.Item(1);            else                Error(EntityNotSupportedErr);        end;        exit(MediaID);    end;    local procedure GetMediaID(var ParentRecordRef: RecordRef): Guid    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        MediaID: Guid;        IsHandled: Boolean;    begin        case ParentRecordRef.Number of            DATABASE::Item:                begin                    Item.Get(ParentRecordRef.RecordId);                    if Item.Picture.Count > 0 then                        MediaID := Item.Picture.Item(1);                end;            DATABASE::Customer:                begin                    Customer.Get(ParentRecordRef.RecordId);                    MediaID := Customer.Image.MediaId;                end;            DATABASE::Vendor:                begin                    Vendor.Get(ParentRecordRef.RecordId);                    MediaID := Vendor.Image.MediaId;                end;            DATABASE::Employee:                begin                    Employee.Get(ParentRecordRef.RecordId);                    MediaID := Employee.Image.MediaId;                end;            DATABASE::Contact:                begin                    Contact.Get(ParentRecordRef.RecordId);                    MediaID := Contact.Image.MediaId;                end;            DATABASE::"Item Variant":                begin                    ItemVariant.Get(ParentRecordRef.RecordId);                    if ItemVariant.Picture.Count > 0 then                        MediaID := ItemVariant.Picture.Item(1);                end;            else begin                OnGetMediaIDElseCase(ParentRecordRef, MediaID, IsHandled);                IsHandled := false;                if not IsHandled then                    ThrowEntityNotSupportedError(ParentRecordRef.Number);            end;        end;        exit(MediaID);    end;    procedure GetRecordRefFromFilter(IDFilter: Text; var ParentRecordRef: RecordRef): Boolean    var        Customer: Record Customer;        Item: Record Item;        Vendor: Record Vendor;        Employee: Record Employee;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        RecordFound: Boolean;    begin        Item.SetFilter(SystemId, IDFilter);        if Item.FindFirst() then begin            ParentRecordRef.GetTable(Item);            RecordFound := true;        end;        Customer.SetFilter(SystemId, IDFilter);        if Customer.FindFirst() then            if not RecordFound then begin                ParentRecordRef.GetTable(Customer);                RecordFound := true;            end else                Error(MultipleParentsFoundErr);        Vendor.SetFilter(SystemId, IDFilter);        if Vendor.FindFirst() then            if not RecordFound then begin                ParentRecordRef.GetTable(Vendor);                RecordFound := true;            end else                Error(MultipleParentsFoundErr);        Employee.SetFilter(SystemId, IDFilter);        if Employee.FindFirst() then            if not RecordFound then begin                ParentRecordRef.GetTable(Employee);                RecordFound := true;            end else                Error(MultipleParentsFoundErr);        Contact.SetFilter(SystemId, IDFilter);        if Contact.FindFirst() then            if not RecordFound then begin                ParentRecordRef.GetTable(Contact);                RecordFound := true;            end else                Error(MultipleParentsFoundErr);        ItemVariant.SetFilter(SystemId, IDFilter);        if ItemVariant.FindFirst() then            if not RecordFound then begin                ParentRecordRef.GetTable(ItemVariant);                RecordFound := true;            end else                Error(MultipleParentsFoundErr);        OnAfterGetRecordRefFromFilter(IDFilter, ParentRecordRef, RecordFound);        exit(RecordFound);    end;    local procedure SetValuesFromMediaID(MediaID: Guid)    var        TenantMedia: Record "Tenant Media";    begin        // TODO: This code should be replaced once we get a proper platform support        // We should not build dependencies to TenantMedia table        if IsNullGuid(MediaID) then            exit;        TenantMedia.SetAutoCalcFields(Content);        if not TenantMedia.Get(MediaID) then            exit;        "Mime Type" := TenantMedia."Mime Type";        Width := TenantMedia.Width;        Height := TenantMedia.Height;        Content := TenantMedia.Content;    end;    local procedure FindRecordFromFilter(var ParentRecordRef: RecordRef; IDFilter: Text)    begin        if IDFilter = '' then            Error(IdNotProvidedErr);        if not GetRecordRefFromFilter(IDFilter, ParentRecordRef) then            Error(RequestedRecordDoesNotExistErr);    end;    local procedure ThrowEntityNotSupportedError(TableID: Integer)    var        AllObjWithCaption: Record AllObjWithCaption;    begin        AllObjWithCaption.SetRange("Object Type", AllObjWithCaption."Object Type"::Table);        AllObjWithCaption.SetRange("Object ID", TableID);        if AllObjWithCaption.FindFirst() then;        Error(RequestedRecordIsNotSupportedErr, AllObjWithCaption."Object Caption");    end;    procedure GetDefaultMediaDescription(ParentRecord: Variant): Text    var        Item: Record Item;        Customer: Record Customer;        Employee: Record Employee;        Vendor: Record Vendor;        Contact: Record Contact;        ItemVariant: Record "Item Variant";        ParentRecordRef: RecordRef;        MediaDescription: Text;        IsHandled: Boolean;    begin        ParentRecordRef.GetTable(ParentRecord);        case ParentRecordRef.Number of            DATABASE::Item:                begin                    ParentRecordRef.SetTable(Item);                    if Item.Description <> '' then                        MediaDescription := StrSubstNo(MediaExtensionWithNumNameTxt, Item."No.", Item.Description, GetDefaultExtension())                    else                        MediaDescription := StrSubstNo(MediaExtensionWithNumOnlyTxt, Item."No.", GetDefaultExtension());                end;            DATABASE::Customer:                begin                    ParentRecordRef.SetTable(Customer);                    MediaDescription := StrSubstNo(MediaExtensionWithNumNameTxt, Customer."No.", Customer.Name, GetDefaultExtension());                end;            DATABASE::Vendor:                begin                    ParentRecordRef.SetTable(Vendor);                    MediaDescription := StrSubstNo(MediaExtensionWithNumNameTxt, Vendor."No.", Vendor.Name, GetDefaultExtension());                end;            DATABASE::Employee:                begin                    ParentRecordRef.SetTable(Employee);                    MediaDescription :=                      StrSubstNo(MediaExtensionWithNumFullNameTxt, Employee."No.", Employee."First Name", Employee."Last Name", GetDefaultExtension());                end;            DATABASE::Contact:                begin                    ParentRecordRef.SetTable(Contact);                    MediaDescription := StrSubstNo(MediaExtensionWithNumNameTxt, Contact."No.", Contact.Name, GetDefaultExtension());                end;            Database::"Item Variant":                begin                    ParentRecordRef.SetTable(ItemVariant);                    if ItemVariant.Description <> '' then                        MediaDescription := StrSubstNo(MediaExtensionWithNumFullNameTxt, ItemVariant."Item No.", ItemVariant.Code, ItemVariant.Description, GetDefaultExtension())                    else                        MediaDescription := StrSubstNo(MediaExtensionWithNumNameTxt, ItemVariant."Item No.", ItemVariant.Code, GetDefaultExtension());                end;            else begin                IsHandled := false;                OnGetDefaultMediaDescriptionElseCase(ParentRecordRef, MediaDescription, IsHandled);                if not IsHandled then                    exit('');            end;        end;        exit(MediaDescription);    end;    procedure GetDefaultExtension(): Text    begin        exit('jpg');    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordRefFromFilter(IDFilter: Text; var ParentRecordRef: RecordRef; var RecordFound: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeletePictureElseCase(ParentRecordRef: RecordRef; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetDefaultMediaDescriptionElseCase(ParentRecordRef: RecordRef; var MediaDescription: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetMediaIDElseCase(ParentRecordRef: RecordRef; var MediaID: Guid; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSavePictureElseCase(ParentRecordRef: RecordRef; var IsHandled: Boolean)    begin    end;}