Table 503 Reminder Email Text

Base Application, Microsoft.Sales.Reminder

src/Layers/W1/BaseApp/Sales/Reminder/TermsAndLevels/ReminderEmailText.Table.al327 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.Sales.Reminder;using System.Globalization;using System.Reflection;/// <summary>/// Stores language-specific email text configurations including subject and body for reminder communications./// </summary>table 503 "Reminder Email Text"{    Caption = 'Reminder Email Text';    DataCaptionFields = "Language Code", "Source Type", Subject;    LookupPageID = "Reminder Email Text";    fields    {        /// <summary>        /// Specifies the unique identifier for this email text configuration.        /// </summary>        field(1; Id; Guid)        {            Caption = 'ID';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies the language code for this email text configuration.        /// </summary>        field(2; "Language Code"; Code[10])        {            Caption = 'Language Code';            ToolTip = 'Specifies the language code for the text communications.';            NotBlank = true;            TableRelation = Language;            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies whether this text is linked to reminder terms or a specific reminder level.        /// </summary>        field(3; "Source Type"; Enum "Reminder Text Source Type")        {            Caption = 'Source Type';            DataClassification = SystemMetadata;        }        /// <summary>        /// Specifies the email subject line for reminder communications.        /// </summary>        field(4; Subject; Text[128])        {            Caption = 'Subject';            ToolTip = 'Specifies the subject of the generated email.';            DataClassification = CustomerContent;        }        /// <summary>        /// Specifies the greeting text that appears at the start of the email body.        /// </summary>        field(5; Greeting; Text[128])        {            Caption = 'Greeting';            ToolTip = 'Specifies the first lines at the beginning of the email';            DataClassification = CustomerContent;        }        /// <summary>        /// Contains the main body text content of the reminder email.        /// </summary>        field(6; "Body Text"; Blob)        {            Caption = 'Body Text';            DataClassification = CustomerContent;        }        /// <summary>        /// Specifies the closing text that appears at the end of the email body.        /// </summary>        field(7; Closing; Text[128])        {            Caption = 'Closing';            ToolTip = 'Specifies the last lines at the end of the email.';            DataClassification = CustomerContent;        }    }    keys    {        key(Key1; Id, "Language Code")        {            Clustered = true;        }    }    trigger OnInsert()    begin        if IsNullGuid(Rec.Id) then            Error(MissingIDErr);        if Rec."Language Code" = '' then            Error(MissingLanguageCodeErr);    end;    trigger OnDelete()    var        ReminderEmailText: Record "Reminder Email Text";        ReminderTerms: Record "Reminder Terms";        ReminderLevel: Record "Reminder Level";        OnlyOneLanguage: Boolean;        EmptyGuid: Guid;    begin        ReminderEmailText.SetRange(Id, Rec.Id);        OnlyOneLanguage := ReminderEmailText.Count() <= 1;        if not OnlyOneLanguage then            exit;        case Rec."Source Type" of            "Reminder Text Source Type"::"Reminder Term":                begin                    ReminderTerms.SetRange("Reminder Email Text", Rec.Id);                    ReminderTerms.FindFirst();                    ReminderTerms."Reminder Email Text" := EmptyGuid;                    ReminderTerms.Modify(true);                end;            "Reminder Text Source Type"::"Reminder Level":                begin                    ReminderLevel.SetRange("Reminder Email Text", Rec.Id);                    ReminderLevel.FindFirst();                    ReminderLevel."Reminder Email Text" := EmptyGuid;                    ReminderLevel.Modify(true);                end;        end;    end;    var        DefaultSubjectLbl: Label 'Issued Reminder';        DefaultGreetingLbl: Label 'Hello';        DefaultBodyTextLbl: Label 'You are receiving this email to formally notify you that payment owed by you is past due. The payment was due on %1. Enclosed is a copy of invoice with the details of remaining amount. If you have already made the payment, please disregard this email. Thank you for your business.', Comment = '%1 = The due date';        DefaultClosingLbl: Label 'Sincerely';        NoRecordSelectedErr: Label 'No reminder email text selected.';        MissingIDErr: Label 'A reminder email text cannot be created without an ID.';        MissingLanguageCodeErr: Label 'A reminder email text cannot be created without a language code.';        AlreadyExistsSelectedLanguageErr: Label 'There is already a reminder email text for the selected language %1. Remove the existing personalization before setting the default communication for that language.', Comment = '%1 = Language Code';        AmtDueLbl: Label 'You are receiving this email to formally notify you that payment owed by you is past due. The payment was due on %1. Enclosed is a copy of invoice with the details of remaining amount.', Comment = '%1 = A due date';        DescriptionLbl: Label 'Description';        BodyLbl: Label 'If you have already made the payment, please disregard this email. Thank you for your business.';    internal procedure GetDescriptionLbl(): Text    begin        exit(DescriptionLbl);    end;    internal procedure GetAmtDueLbl(): Text    begin        exit(AmtDueLbl);    end;    internal procedure GetBodyLbl(): Text    begin        exit(BodyLbl);    end;    internal procedure GetDefaultSubjectLbl(): Text    begin        exit(DefaultSubjectLbl);    end;    internal procedure GetDefaultGreetingLbl(): Text    begin        exit(DefaultGreetingLbl);    end;    internal procedure GetDefaultBodyTextLbl(): Text    begin        exit(DefaultBodyTextLbl);    end;    internal procedure GetDefaultClosingLbl(): Text    begin        exit(DefaultClosingLbl);    end;    /// <summary>    /// Sets the body text for the current email text record.    /// </summary>    /// <param name="value">The body text content to store.</param>    procedure SetBodyText(value: Text)    var        WriteStream: OutStream;    begin        if Rec.IsEmpty() then            Error(NoRecordSelectedErr);        if value = '' then begin            Clear(Rec."Body Text");            Rec.Modify();            exit;        end;        Clear(Rec."Body Text");        Rec."Body Text".CreateOutStream(WriteStream, TextEncoding::UTF8);        WriteStream.WriteText(value);        Rec.Modify();    end;    /// <summary>    /// Sets the body text for the specified email text record.    /// </summary>    /// <param name="value">The body text content to store.</param>    /// <param name="ReminderEmailText">The email text record to update.</param>    procedure SetBodyText(value: Text; var ReminderEmailText: Record "Reminder Email Text")    begin        ReminderEmailText.SetBodyText(value);    end;    /// <summary>    /// Gets the body text from the current email text record.    /// </summary>    /// <returns>The body text content.</returns>    procedure GetBodyText(): Text    begin        exit(GetBodyText(Rec));    end;    /// <summary>    /// Gets the body text from the specified email text record.    /// </summary>    /// <param name="ReminderEmailText">The email text record to read from.</param>    /// <returns>The body text content.</returns>    procedure GetBodyText(var ReminderEmailText: Record "Reminder Email Text"): Text    var        TypeHelper: Codeunit "Type Helper";        ReadStream: InStream;        BodyText: Text;    begin        if ReminderEmailText.IsEmpty() then            Error(NoRecordSelectedErr);        ReminderEmailText.CalcFields("Body Text");        if ReminderEmailText."Body Text".HasValue() then begin            ReminderEmailText."Body Text".CreateInStream(ReadStream, TextEncoding::UTF8);            BodyText := TypeHelper.TryReadAsTextWithSepAndFieldErrMsg(ReadStream, TypeHelper.LFSeparator(), FieldName("Body Text"));        end        else            BodyText := '';        exit(BodyText);    end;    /// <summary>    /// Creates a new reminder email text record for the user's language with default content.    /// </summary>    /// <param name="SelectedId">The ID of the email text group.</param>    /// <param name="SourceType">The source type (Reminder Term or Reminder Level).</param>    procedure SetDefaultContentForNewLanguage(SelectedId: Guid; SourceType: Enum "Reminder Text Source Type")    var        Language: Codeunit Language;    begin        SetDefaultContentForNewLanguage(SelectedId, Language.GetUserLanguageCode(), SourceType);    end;    /// <summary>    /// Creates a new reminder email text record for the specified language with default content.    /// </summary>    /// <param name="SelectedId">The ID of the email text group.</param>    /// <param name="LanguageCode">The language code for the new record.</param>    /// <param name="SourceType">The source type (Reminder Term or Reminder Level).</param>    procedure SetDefaultContentForNewLanguage(SelectedId: Guid; LanguageCode: Code[10]; SourceType: Enum "Reminder Text Source Type")    var        EmptyGuid: Guid;    begin        SetDefaultContentForNewLanguage(SelectedId, LanguageCode, SourceType, EmptyGuid);    end;    /// <summary>    /// Creates a new reminder email text record for the specified language and links it to the source record.    /// </summary>    /// <param name="SelectedId">The ID of the email text group.</param>    /// <param name="LanguageCode">The language code for the new record.</param>    /// <param name="SourceType">The source type (Reminder Term or Reminder Level).</param>    /// <param name="SelectedSystemId">The system ID of the source record to link to.</param>    procedure SetDefaultContentForNewLanguage(SelectedId: Guid; LanguageCode: Code[10]; SourceType: Enum "Reminder Text Source Type"; SelectedSystemId: Guid)    var        ExistingReminderEmailText: Record "Reminder Email Text";        ReminderEmailText: Record "Reminder Email Text";        ReminderTerms: Record "Reminder Terms";        ReminderLevel: Record "Reminder Level";        Language: Codeunit Language;        CurrentGlobalLanguage: Integer;    begin        if ExistingReminderEmailText.Get(SelectedId, LanguageCode) then            Error(AlreadyExistsSelectedLanguageErr, LanguageCode);        CurrentGlobalLanguage := GlobalLanguage();        GlobalLanguage(Language.GetLanguageId(LanguageCode));        ReminderEmailText.Id := SelectedId;        ReminderEmailText."Language Code" := LanguageCode;        ReminderEmailText.Subject := DefaultSubjectLbl;        ReminderEmailText.Greeting := DefaultGreetingLbl;        ReminderEmailText.Closing := DefaultClosingLbl;        ReminderEmailText."Source Type" := SourceType;        ReminderEmailText.Insert(true);        ReminderEmailText.SetBodyText(DefaultBodyTextLbl);        GlobalLanguage(CurrentGlobalLanguage);        if IsNullGuid(SelectedSystemId) then            exit;        case SourceType of            "Reminder Text Source Type"::"Reminder Term":                begin                    ReminderTerms.SetRange(SystemId, SelectedSystemId);                    if ReminderTerms.FindFirst() then begin                        ReminderTerms."Reminder Email Text" := SelectedId;                        ReminderTerms.Modify(true);                    end;                end;            "Reminder Text Source Type"::"Reminder Level":                begin                    ReminderLevel.SetRange(SystemId, SelectedSystemId);                    if ReminderLevel.FindFirst() then begin                        ReminderLevel."Reminder Email Text" := SelectedId;                        ReminderLevel.Modify(true);                    end;                end;        end;    end;}