Table 5104 Segment Interaction Language

Base Application, Microsoft.CRM.Segment

src/Layers/W1/BaseApp/CRM/Segment/SegmentInteractionLanguage.Table.al497 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.Segment;using Microsoft.CRM.Contact;using Microsoft.CRM.Interaction;using System.Globalization;using System.Integration.Word;using System.Utilities;table 5104 "Segment Interaction Language"{    Caption = 'Segment Interaction Language';    DataClassification = CustomerContent;    LookupPageID = "Segment Interaction Languages";    fields    {        field(1; "Segment No."; Code[20])        {            Caption = 'Segment No.';            TableRelation = "Segment Header";        }        field(2; "Segment Line No."; Integer)        {            Caption = 'Segment Line No.';            TableRelation = "Segment Line"."Line No." where("Segment No." = field("Segment No."));        }        field(3; "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(4; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the Segment Interaction Language. This field will not be displayed in the Word attachment.';        }        field(5; "Attachment No."; Integer)        {            Caption = 'Attachment No.';        }        field(6; Subject; Text[100])        {            Caption = 'Subject';            ToolTip = 'Specifies the subject text. The text in the field is used as the subject in e-mails and Word documents.';            trigger OnValidate()            var                SegmentHeader: Record "Segment Header";                SegLine: Record "Segment Line";                UpdateLines: Boolean;            begin                SegmentHeader.Get("Segment No.");                if "Segment Line No." = 0 then                    if SegmentHeader.SegLinesExist('') then                        UpdateLines := Confirm(StrSubstNo(UpdateSegmentLinesQst, FieldCaption(Subject)), true);                if SegmentHeader."Language Code (Default)" = "Language Code" then                    if SegmentHeader."Subject (Default)" = xRec.Subject then begin                        SegmentHeader."Subject (Default)" := Subject;                        SegmentHeader.Modify();                        Modify();                    end;                if not UpdateLines then                    exit;                SegLine.SetRange("Segment No.", "Segment No.");                if "Segment Line No." = 0 then                    SegLine.SetRange("Interaction Template Code", SegmentHeader."Interaction Template Code")                else begin                    SegLine.Get("Segment No.", "Segment Line No.");                    SegLine.SetRange("Interaction Template Code", SegLine."Interaction Template Code");                end;                SegLine.SetRange("Language Code", "Language Code");                SegLine.SetRange(Subject, xRec.Subject);                SegLine.ModifyAll(Subject, Subject);            end;        }        field(7; "Word Template Code"; Code[30])        {            DataClassification = CustomerContent;            TableRelation = "Word Template".Code where("Table ID" = const(5106)); // Only Interaction Merge Data word templates are allowed        }    }    keys    {        key(Key1; "Segment No.", "Segment Line No.", "Language Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        SegmentHeader: Record "Segment Header";        SegmentLine: Record "Segment Line";        Contact: Record Contact;        SegmentInteractionLanguage: Record "Segment Interaction Language";    begin        SegmentHeader.Get(Rec."Segment No.");        if (Rec."Segment Line No." = 0) and           (Rec."Language Code" = SegmentHeader."Language Code (Default)")        then begin            SegmentInteractionLanguage.SetRange("Segment No.", Rec."Segment No.");            SegmentInteractionLanguage.SetRange("Segment Line No.", 0);            SegmentInteractionLanguage.SetFilter("Language Code", '<>%1', Rec."Language Code");            if SegmentInteractionLanguage.FindFirst() then begin                SegmentHeader."Language Code (Default)" := SegmentInteractionLanguage."Language Code";                SegmentHeader."Subject (Default)" := SegmentInteractionLanguage.Subject;            end else begin                SegmentHeader."Language Code (Default)" := '';                SegmentHeader."Subject (Default)" := '';            end;            SegmentHeader.Modify();        end;        SegmentHeader.CalcFields("Attachment No.");        if Rec."Segment Line No." = 0 then begin            SegmentLine.SetRange("Segment No.", Rec."Segment No.");            SegmentLine.SetRange("Attachment No.", Rec."Attachment No.");            if SegmentLine.Find('-') then                repeat                    if Contact.Get(SegmentLine."Contact No.") then begin                        if (Contact."Language Code" <> "Language Code") and                           SegmentInteractionLanguage.Get("Segment No.", 0, Contact."Language Code")                        then begin                            SegmentLine."Language Code" := Contact."Language Code";                            SegmentLine.Subject := SegmentInteractionLanguage.Subject;                            SegmentLine."Attachment No." := SegmentInteractionLanguage."Attachment No.";                            SegmentLine."Word Template Code" := SegmentInteractionLanguage."Word Template Code";                        end else begin                            SegmentLine."Language Code" := SegmentHeader."Language Code (Default)";                            SegmentLine.Subject := SegmentHeader."Subject (Default)";                            SegmentLine."Attachment No." := SegmentHeader."Attachment No.";                            SegmentLine."Word Template Code" := SegmentHeader."Word Template Code";                        end;                        SegmentLine.Modify();                    end;                until SegmentLine.Next() = 0;        end else begin // UNIQUE Attachment            SegmentLine.Get("Segment No.", Rec."Segment Line No.");            if SegmentLine."Attachment No." = Rec."Attachment No." then begin                SegmentInteractionLanguage.SetRange("Segment No.", Rec."Segment No.");                SegmentInteractionLanguage.SetRange("Segment Line No.", Rec."Segment Line No.");                SegmentInteractionLanguage.SetFilter("Language Code", '<>%1', Rec."Language Code");                if SegmentInteractionLanguage.FindFirst() then begin                    SegmentLine."Language Code" := SegmentInteractionLanguage."Language Code";                    SegmentLine.Subject := SegmentInteractionLanguage.Subject;                    SegmentLine."Attachment No." := SegmentInteractionLanguage."Attachment No.";                    SegmentLine."Word Template Code" := SegmentInteractionLanguage."Word Template Code";                end else                    if SegmentLine."Interaction Template Code" = SegmentHeader."Interaction Template Code" then begin                        Contact.Get(SegmentLine."Contact No.");                        if SegmentInteractionLanguage.Get("Segment No.", 0, Contact."Language Code") then begin                            SegmentLine."Language Code" := Contact."Language Code";                            SegmentLine.Subject := SegmentInteractionLanguage.Subject;                            SegmentLine."Attachment No." := SegmentInteractionLanguage."Attachment No.";                            SegmentLine."Word Template Code" := SegmentInteractionLanguage."Word Template Code";                        end else begin                            SegmentLine."Language Code" := SegmentHeader."Language Code (Default)";                            SegmentLine.Subject := SegmentHeader."Subject (Default)";                            SegmentLine."Attachment No." := SegmentHeader."Attachment No.";                            SegmentLine."Word Template Code" := SegmentHeader."Word Template Code";                        end;                    end else begin                        SegmentLine."Language Code" := '';                        SegmentLine.Subject := '';                        SegmentLine."Attachment No." := 0;                        SegmentLine."Word Template Code" := '';                    end;                SegmentLine.Modify();            end;        end;        RemoveAttachment(false);    end;    trigger OnInsert()    var        Contact: Record Contact;        SegmentHeader: Record "Segment Header";        SegmentLine: Record "Segment Line";        SegmentInteractionLanguage: Record "Segment Interaction Language";        FirstSegIntLanguage: Boolean;    begin        if Rec."Segment Line No." = 0 then begin            SegmentInteractionLanguage.SetRange("Segment No.", Rec."Segment No.");            SegmentInteractionLanguage.SetRange("Segment Line No.", 0);            FirstSegIntLanguage := SegmentInteractionLanguage.IsEmpty();            SegmentLine.SetRange("Segment No.", Rec."Segment No.");            SegmentHeader.Get(Rec."Segment No.");            SegmentLine.SetRange("Interaction Template Code", SegmentHeader."Interaction Template Code");            if SegmentLine.Find('-') then                repeat                    if FirstSegIntLanguage then begin                        if SegmentLine.AttachmentInherited() or                           (SegmentLine."Attachment No." = 0)                        then begin                            SegmentLine."Language Code" := Rec."Language Code";                            SegmentLine.Subject := Rec.Subject;                            SegmentLine."Attachment No." := Rec."Attachment No.";                            SegmentLine."Word Template Code" := Rec."Word Template Code";                            SegmentLine.Modify();                        end                    end else                        if SegmentLine.AttachmentInherited() or (SegmentLine."Attachment No." = 0) then                            if Contact.Get(SegmentLine."Contact No.") then                                if Contact."Language Code" = "Language Code" then begin                                    SegmentLine."Language Code" := Rec."Language Code";                                    SegmentLine.Subject := Rec.Subject;                                    SegmentLine."Attachment No." := Rec."Attachment No.";                                    SegmentLine."Word Template Code" := Rec."Word Template Code";                                    SegmentLine.Modify();                                end;                until SegmentLine.Next() = 0;        end else begin            SegmentLine.Get("Segment No.", Rec."Segment Line No.");            SegmentLine."Language Code" := Rec."Language Code";            SegmentLine.Subject := Rec.Subject;            SegmentLine."Attachment No." := Rec."Attachment No.";            SegmentLine."Word Template Code" := Rec."Word Template Code";            SegmentLine.Modify();        end;    end;    trigger OnRename()    var        SegmentHeader: Record "Segment Header";        SegmentLine: Record "Segment Line";        Contact: Record Contact;    begin        SegmentHeader.Get("Segment No.");        SegmentHeader.CalcFields("Attachment No.");        if (Rec."Segment Line No." = 0) and           (SegmentHeader."Language Code (Default)" = xRec."Language Code")        then begin            SegmentHeader."Language Code (Default)" := Rec."Language Code";            SegmentHeader.Modify();        end;        if Rec."Segment Line No." = 0 then begin            SegmentLine.SetRange("Segment No.", Rec."Segment No.");            SegmentLine.SetRange("Attachment No.", Rec."Attachment No.");            if SegmentLine.Find('-') then                repeat                    SegmentLine."Language Code" := SegmentHeader."Language Code (Default)";                    SegmentLine."Attachment No." := SegmentHeader."Attachment No.";                    SegmentLine."Word Template Code" := SegmentHeader."Word Template Code";                    SegmentLine.Modify();                until SegmentLine.Next() = 0;            SegmentLine.Reset();            SegmentLine.SetRange("Segment No.", Rec."Segment No.");            SegmentLine.SetRange("Interaction Template Code", SegmentHeader."Interaction Template Code");            if SegmentLine.Find('-') then                repeat                    if SegmentLine.AttachmentInherited() or (SegmentLine."Attachment No." = 0) then                        if Contact.Get(SegmentLine."Contact No.") then                            if Contact."Language Code" = Rec."Language Code" then begin                                SegmentLine."Language Code" := Rec."Language Code";                                SegmentLine.Subject := Rec.Subject;                                SegmentLine."Attachment No." := Rec."Attachment No.";                                SegmentLine."Word Template Code" := Rec."Word Template Code";                                SegmentLine.Modify();                            end;                until SegmentLine.Next() = 0;        end else begin            SegmentLine.Get(Rec."Segment No.", Rec."Segment Line No.");            if SegmentLine."Language Code" = xRec."Language Code" then begin                SegmentLine."Language Code" := Rec."Language Code";                SegmentLine."Attachment No." := Rec."Attachment No.";                SegmentLine."Word Template Code" := Rec."Word Template Code";                SegmentLine.Modify();            end;        end;    end;    var        CreateProcessCanceledLbl: Label 'You have canceled the create process.';        ReplaceExistingAttachmentQst: Label 'Replace existing attachment?';        ImportFailedMsg: Label 'The import was canceled or the specified file could not be accessed. The import failed.';        InheritedLbl: Label 'Inherited';        UniqueLbl: Label 'Unique';        UpdateSegmentLinesQst: Label 'You have modified %1.\\Do you want to update the segment lines with the same Interaction Template Code and Language Code?', Comment = '%1 = Subject caption';    [Scope('OnPrem')]    procedure CreateAttachment()    var        SegmentInteractionLanguage: Record "Segment Interaction Language";        Attachment: Record Attachment;        NewAttachmentNo: Integer;    begin        if "Attachment No." <> 0 then begin            if not Confirm(ReplaceExistingAttachmentQst, false) then                exit;            RemoveAttachment(false);        end;        if GuiAllowed() then            if Attachment.ImportAttachmentFromClientFile('', false, true) then                NewAttachmentNo := Attachment."No.";        if NewAttachmentNo <> 0 then begin            "Attachment No." := NewAttachmentNo;            if SegmentInteractionLanguage.Get("Segment No.", "Segment Line No.", "Language Code") then                Modify()            else                Insert(true);            UpdateSegLineAttachment(0);        end else            Error(CreateProcessCanceledLbl);    end;    internal procedure CreateWordTemplateAttachment(var TempBlob: Codeunit "Temp Blob"; FileName: Text)    var        SegmentInteractionLanguage: Record "Segment Interaction Language";        Attachment: Record Attachment;        NewAttachmentNo: Integer;        InStream: InStream;    begin        if "Attachment No." <> 0 then begin            if not Confirm(ReplaceExistingAttachmentQst, false) then                exit;            RemoveAttachment(false);        end;        if GuiAllowed() then begin            TempBlob.CreateInStream(InStream);            NewAttachmentNo := Attachment.ImportAttachmentFromStream(InStream, FileName);        end;        if NewAttachmentNo <> 0 then begin            "Attachment No." := NewAttachmentNo;            if SegmentInteractionLanguage.Get("Segment No.", "Segment Line No.", "Language Code") then                Modify()            else                Insert(true);            UpdateSegLineWordTemplateAttachment(NewAttachmentNo);        end else            Error(CreateProcessCanceledLbl);    end;    [Scope('OnPrem')]    procedure OpenAttachment()    var        Attachment: Record Attachment;    begin        if "Attachment No." = 0 then            exit;        Attachment.Get("Attachment No.");        Attachment.OpenAttachment("Segment No." + ' ' + Description, false, "Language Code");    end;    [Scope('OnPrem')]    procedure CopyFromAttachment()    var        SegmentInteractionLanguage: Record "Segment Interaction Language";        AttachmentManagement: Codeunit AttachmentManagement;        NewAttachNo: Integer;    begin        if "Attachment No." <> 0 then begin            if not Confirm(ReplaceExistingAttachmentQst, false) then                exit;            RemoveAttachment(false);            Commit();        end;        SegmentInteractionLanguage.SetRange("Segment No.", "Segment No.");        SegmentInteractionLanguage.SetFilter("Attachment No.", '<>%1&<>%2', 0, "Attachment No.");        if PAGE.RunModal(0, SegmentInteractionLanguage) = ACTION::LookupOK then begin            NewAttachNo := AttachmentManagement.InsertAttachment(SegmentInteractionLanguage."Attachment No.");            if NewAttachNo <> 0 then begin                "Attachment No." := NewAttachNo;                Modify();                UpdateSegLineAttachment(0);            end;        end;    end;    [Scope('OnPrem')]    procedure ImportAttachment()    var        Attachment: Record Attachment;    begin        if "Attachment No." <> 0 then begin            if not Confirm(ReplaceExistingAttachmentQst, false) then                exit;            RemoveAttachment(false);        end;        if Attachment.ImportAttachmentFromClientFile('', false, false) then begin            "Attachment No." := Attachment."No.";            Modify();            UpdateSegLineAttachment(0);        end else            Error(ImportFailedMsg);    end;    [Scope('OnPrem')]    procedure ExportAttachment()    var        Attachment: Record Attachment;        FileName: Text[1024];    begin        if Attachment.Get("Attachment No.") then begin            if Attachment."Storage Type" = Attachment."Storage Type"::Embedded then                Attachment.CalcFields("Attachment File");            Attachment.ExportAttachmentToClientFile(FileName);        end;    end;    [Scope('OnPrem')]    procedure RemoveAttachment(Prompt: Boolean)    var        Attachment: Record Attachment;        OldAttachmentNo: Integer;    begin        OldAttachmentNo := "Attachment No.";        if Attachment.Get("Attachment No.") and (not Attachment."Read Only") then            if Attachment.RemoveAttachment(Prompt) then begin                "Attachment No." := 0;                Modify();            end;        UpdateSegLineAttachment(OldAttachmentNo);    end;    local procedure UpdateSegLineAttachment(OldAttachmentNo: Integer)    var        SegmentLine: Record "Segment Line";        SegmentHeader: Record "Segment Header";    begin        if "Segment Line No." = 0 then begin            SegmentHeader.Get("Segment No.");            SegmentLine.SetRange("Segment No.", "Segment No.");            SegmentLine.SetRange("Interaction Template Code", SegmentHeader."Interaction Template Code");            SegmentLine.SetRange("Language Code", "Language Code");            SegmentLine.SetRange("Attachment No.", OldAttachmentNo);            SegmentLine.ModifyAll("Attachment No.", "Attachment No.");        end else begin            SegmentLine.SetRange("Segment No.", "Segment No.");            SegmentLine.SetRange("Line No.", "Segment Line No.");            SegmentLine.SetRange("Attachment No.", OldAttachmentNo);            if SegmentLine.FindFirst() then begin                SegmentLine."Attachment No." := "Attachment No.";                SegmentLine.Modify();            end;        end;    end;    local procedure UpdateSegLineWordTemplateAttachment(AttachmentNo: Integer)    var        SegmentHeader: Record "Segment Header";    begin        SegmentHeader.Get("Segment No.");        SegmentHeader."Modified Word Template" := AttachmentNo;        SegmentHeader.Modify();    end;    procedure AttachmentText(): Text[30]    begin        if "Attachment No." = 0 then            exit('');        if "Segment Line No." = 0 then            exit(InheritedLbl);        exit(UniqueLbl);    end;    procedure Caption() CaptionText: Text    var        SegmentHeader: Record "Segment Header";        SegmentLine: Record "Segment Line";        Contact: Record Contact;    begin        SegmentHeader.Get("Segment No.");        CaptionText := Format("Segment No.") + ' ' + SegmentHeader.Description;        if "Segment Line No." <> 0 then begin            SegmentLine.Get("Segment No.", "Segment Line No.");            if Contact.Get(SegmentLine."Contact No.") then;            CaptionText := CaptionText + ' ' + Format(SegmentLine."Contact No.") + ' ' + Contact.Name;        end;    end;}