Table 5103 Interaction Tmpl. Language

Base Application, Microsoft.CRM.Interaction

src/Layers/W1/BaseApp/CRM/Interaction/InteractionTmplLanguage.Table.al356 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.CRM.Interaction;using Microsoft.CRM.Setup;using Microsoft.Foundation.Reporting;using System.Environment;using System.Globalization;using System.Integration.Word;using System.IO;using System.Reflection;using System.Utilities;table 5103 "Interaction Tmpl. Language"{    Caption = 'Interaction Tmpl. Language';    DataClassification = CustomerContent;    LookupPageID = "Interact. Tmpl. Languages";    fields    {        field(1; "Interaction Template Code"; Code[10])        {            Caption = 'Interaction Template Code';            ToolTip = 'Specifies the code for the interaction template that you have selected.';            Editable = false;            TableRelation = "Interaction Template";        }        field(2; "Language Code"; Code[10])        {            Caption = 'Language Code';            ToolTip = 'Specifies the language that is used when translating specified text on documents to foreign business partner, such as an item description on an order confirmation.';            TableRelation = Language;        }        field(3; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the interaction template language. This field will not be displayed in the Word attachment.';        }        field(4; "Attachment No."; Integer)        {            Caption = 'Attachment No.';        }        field(5; "Custom Layout Code"; Code[20])        {            Caption = 'Custom Layout Code';            ToolTip = 'Specifies the number of the report layout.';            TableRelation = "Custom Report Layout" where("Report ID" = const(Report::"Email Merge"));            trigger OnValidate()            begin                if Rec."Custom Layout Code" <> '' then                    Rec.Validate("Report Layout Name", '');                CalcFields("Custom Layout Description");            end;        }        field(6; "Custom Layout Description"; Text[250])        {            CalcFormula = lookup("Custom Report Layout".Description where(Code = field("Custom Layout Code")));            Caption = 'Custom Layout Description';            Editable = false;            FieldClass = FlowField;        }        field(7; "Word Template Code"; Code[30])        {            ToolTip = 'Specifies the Word template to use when you create communications for an interaction. The Word template will create either a document or be used as the body text in an email.';            DataClassification = CustomerContent;            TableRelation = "Word Template".Code where("Language Code" = field("Language Code"), "Table ID" = const(Database::"Interaction Merge Data")); // Only Interaction Merge Data word templates with same language code are allowed        }        field(8; "Report Layout Name"; Text[250])        {            Caption = 'Report Layout Name';            ToolTip = 'Specifies the report layout that will be used.';            TableRelation = "Report Layout List".Name where("Report ID" = const(Report::"Email Merge"));            trigger OnLookup()            var                ReportLayoutList: Record "Report Layout List";                ReportManagement: Codeunit ReportManagement;                Handled: Boolean;            begin                ReportLayoutList.SetRange("Report ID", Report::"Email Merge");                ReportManagement.OnSelectReportLayout(ReportLayoutList, Handled);                if not Handled then                    exit;                "Report Layout Name" := ReportLayoutList.Name;                "Report Layout AppID" := ReportLayoutList."Application ID";            end;            trigger OnValidate()            var                ReportLayoutList: Record "Report Layout List";            begin                if "Report Layout Name" <> '' then begin                    ReportLayoutList.SetRange(Name, "Report Layout Name");                    ReportLayoutList.SetRange("Report ID", Report::"Email Merge");                    if not IsNullGuid("Report Layout AppID") then                        ReportLayoutList.SetRange("Application ID", "Report Layout AppID");                    if not ReportLayoutList.FindFirst() then begin                        ReportLayoutList.SetRange("Application ID");                        ReportLayoutList.FindFirst();                    end;                    Rec."Report Layout AppID" := ReportLayoutList."Application ID";                end else                    Clear(Rec."Report Layout AppID");            end;        }        field(9; "Report Layout AppID"; Guid)        {            Caption = 'Email Body Layout AppID';            ToolTip = 'Specifies which app the report layout belongs to.';            TableRelation = "Report Layout List"."Application ID" where("Report ID" = const(Report::"Email Merge"));        }    }    keys    {        key(Key1; "Interaction Template Code", "Language Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    begin        RemoveAttachment(false);    end;    trigger OnRename()    var        InteractionTemplate: Record "Interaction Template";    begin        InteractionTemplate.Get("Interaction Template Code");        if xRec."Language Code" <> "Language Code" then            if InteractionTemplate."Language Code (Default)" = xRec."Language Code" then begin                InteractionTemplate."Language Code (Default)" := "Language Code";                InteractionTemplate.Modify();            end;    end;    var        AttachmentRecord: Record Attachment;        ClientTypeManagement: Codeunit "Client Type Management";#pragma warning disable AA0074        Text000: Label 'You have canceled the create process.';        Text001: Label 'Replace existing attachment?';        Text002: Label 'You have canceled the import process.';        Text005: Label 'Export Attachment';#pragma warning restore AA0074    procedure CreateAttachment()    var        Attachment: Record Attachment;        InteractTmplLanguage: Record "Interaction Tmpl. Language";        NewAttachNo: Integer;        IsHandled: Boolean;    begin        if "Attachment No." <> 0 then begin            if Attachment.Get("Attachment No.") then                Attachment.TestField("Read Only", false);            if not Confirm(Text001, false) then                exit;        end;        IsHandled := false;        OnCreateAttachmentOnAfterInitialChecks(Rec, NewAttachNo, IsHandled);        if IsHandled then            exit;        if ("Custom Layout Code" = '') and ("Report Layout Name" = '') then begin            if ClientTypeManagement.GetCurrentClientType() in [CLIENTTYPE::Web, CLIENTTYPE::Tablet, CLIENTTYPE::Phone, CLIENTTYPE::Desktop] then                if Attachment.ImportAttachmentFromClientFile('', false, false) then                    NewAttachNo := Attachment."No.";        end else            NewAttachNo := CreateHTMLCustomLayoutAttachment();        if NewAttachNo <> 0 then begin            if "Attachment No." <> 0 then                RemoveAttachment(false);            "Attachment No." := NewAttachNo;            if InteractTmplLanguage.Get("Interaction Template Code", "Language Code") then                Modify()            else                Insert();        end else            Error(Text000);    end;    procedure CreateHTMLCustomLayoutAttachment(): Integer    var        Attachment: Record Attachment;    begin        OnBeforeCreateHTMLCustomLayoutAttachment();        Attachment.Init();        Attachment."Storage Type" := Attachment."Storage Type"::Embedded;        Attachment."File Extension" := 'HTML';        Attachment.Insert(true);        if "Custom Layout Code" <> '' then            Attachment.WriteHTMLCustomLayoutAttachment('', "Custom Layout Code")        else            Attachment.WriteHTMLCustomLayoutAttachment('', "Report Layout Name");        exit(Attachment."No.");    end;    procedure OpenAttachment()    var        Attachment: Record Attachment;    begin        if "Attachment No." = 0 then            exit;        OnOpenAttachmentOnBeforeGetAttachment(Rec, Attachment);        Attachment.Get("Attachment No.");        OnBeforeOpenAttachment(Rec, Attachment);        Attachment.OpenAttachment("Interaction Template Code" + ' ' + Description, false, "Language Code");    end;    procedure CopyFromAttachment()    var        InteractTmplLanguage: Record "Interaction Tmpl. Language";        Attachment: Record Attachment;        AttachmentManagement: Codeunit AttachmentManagement;        NewAttachNo: Integer;    begin        if Attachment.Get("Attachment No.") then            Attachment.TestField("Read Only", false);        if "Attachment No." <> 0 then begin            if not Confirm(Text001, false) then                exit;            RemoveAttachment(false);            "Attachment No." := 0;            Modify();            Commit();        end;        InteractTmplLanguage.SetFilter("Attachment No.", '<>%1', 0);        if PAGE.RunModal(0, InteractTmplLanguage) = ACTION::LookupOK then begin            NewAttachNo := AttachmentManagement.InsertAttachment(InteractTmplLanguage."Attachment No.");            if NewAttachNo <> 0 then begin                "Attachment No." := NewAttachNo;                Modify();            end;        end;    end;    procedure ImportAttachment()    var        Attachment: Record Attachment;    begin        if "Attachment No." <> 0 then begin            if Attachment.Get("Attachment No.") then                Attachment.TestField("Read Only", false);            if not Confirm(Text001, false) then                exit;        end;        if Attachment.ImportAttachmentFromClientFile('', false, false) then begin            "Attachment No." := Attachment."No.";            OnImportAttachmentOnBeforeModify(Attachment);            Modify();        end else            Error(Text002);    end;    procedure ExportAttachment()    var        MarketingSetup: Record "Marketing Setup";        TempBlob: Codeunit "Temp Blob";        FileMgt: Codeunit "File Management";        FileName: Text;        FileFilter: Text;        ExportToFile: Text;    begin        MarketingSetup.Get();        ExportToFile := '';        if not AttachmentRecord.Get("Attachment No.") then            exit;        case AttachmentRecord."Storage Type" of            AttachmentRecord."Storage Type"::Embedded:                begin                    AttachmentRecord.CalcFields("Attachment File");                    if AttachmentRecord."Attachment File".HasValue() then begin                        FileName := "Interaction Template Code" + '.' + AttachmentRecord."File Extension";                        TempBlob.FromRecord(AttachmentRecord, AttachmentRecord.FieldNo("Attachment File"));                        FileMgt.BLOBExport(TempBlob, FileName, true);                    end;                end;            AttachmentRecord."Storage Type"::"Disk File":                begin                    if MarketingSetup."Attachment Storage Type" = MarketingSetup."Attachment Storage Type"::"Disk File" then                        MarketingSetup.TestField("Attachment Storage Location");                    FileFilter :=                      UpperCase(AttachmentRecord."File Extension") +                      ' (*.' + AttachmentRecord."File Extension" + ')|*.' + AttachmentRecord."File Extension";                    ExportToFile := "Interaction Template Code" + '.' + AttachmentRecord."File Extension";                    FileMgt.DownloadHandler(                      AttachmentRecord."Storage Pointer" + '\' + Format(AttachmentRecord."No.") + '.' + AttachmentRecord."File Extension",                      Text005, '', FileFilter, ExportToFile);                end;            else                OnExportAttachmentOnStorageTypeCaseElse(Rec, xRec, AttachmentRecord, MarketingSetup, ExportToFile, FileFilter, FileName);        end;    end;    procedure RemoveAttachment(Prompt: Boolean)    var        Attachment: Record Attachment;    begin        if Attachment.Get("Attachment No.") then            if Attachment.RemoveAttachment(Prompt) then begin                "Attachment No." := 0;                Modify();            end;    end;    [IntegrationEvent(false, false)]    local procedure OnImportAttachmentOnBeforeModify(var Attachment: Record Attachment)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreateHTMLCustomLayoutAttachment()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateAttachmentOnAfterInitialChecks(var InteractionTmplLanguage: Record "Interaction Tmpl. Language"; var NewAttachNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnOpenAttachmentOnBeforeGetAttachment(var InteractionTmplLanguage: Record "Interaction Tmpl. Language"; var Attachment: Record Attachment)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeOpenAttachment(var InteractionTmplLanguage: Record "Interaction Tmpl. Language"; var Attachment: Record Attachment)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnExportAttachmentOnStorageTypeCaseElse(var InteractionTmplLanguage: Record "Interaction Tmpl. Language"; xInteractionTmplLanguage: Record "Interaction Tmpl. Language"; var AttachmentRecord: Record Attachment; var MarketingSetup: Record "Marketing Setup"; var ExportToFile: Text; var FileFilter: Text; var FileName: Text)    begin    end;}