Table 9510 Email Parameter
src/Layers/W1/BaseApp/OtherCapabilities/Email/EmailParameter.Table.al135 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Email;using Microsoft.Foundation.Reporting;using Microsoft.Sales.Document;using System.Reflection;using System.Utilities;table 9510 "Email Parameter"{ Caption = 'Email Parameter'; DataClassification = CustomerContent; fields { field(1; "Document No"; Code[20]) { Caption = 'Document No'; } field(2; "Document Type"; Enum "Sales Document Type") { Caption = 'Document Type'; } field(3; "Parameter Type"; Enum "Email Parameter Type") { Caption = 'Parameter Type'; } field(4; "Parameter Value"; Text[250]) { Caption = 'Parameter Value'; } field(5; "Parameter BLOB"; BLOB) { Caption = 'Parameter BLOB'; } } keys { key(Key1; "Document No", "Document Type", "Parameter Type") { Clustered = true; } } fieldgroups { } var ParameterNotSupportedErr: Label 'Report usage is not supported.'; procedure GetParameterWithReportUsage(DocumentNo: Code[20]; ReportUsage: Enum "Report Selection Usage"; ParameterType: Enum "Email Parameter Type"): Boolean var ReportSelections: Record "Report Selections"; DocumentType: Enum "Sales Document Type"; begin if not ReportSelections.ConvertReportUsageToSalesDocumentType(DocumentType, ReportUsage) then exit(false); exit(Get(DocumentNo, DocumentType, ParameterType)); end; procedure GetEntryWithReportUsage(DocumentNo: Code[20]; ReportUsage: Integer; ParameterType: Option): Boolean begin exit( GetParameterWithReportUsage( DocumentNo, Enum::"Report Selection Usage".FromInteger(ReportUsage), "Email Parameter Type".FromInteger(ParameterType))); end; procedure GetParameterValue(): Text begin CalcFields("Parameter BLOB"); if "Parameter BLOB".HasValue() then exit(GetTextFromBLOB()); exit("Parameter Value"); end; procedure SaveParameterValue(DocumentNo: Code[20]; DocumentType: Integer; ParameterType: Option; ParameterValue: Text) var ParameterAlreadyExists: Boolean; begin ParameterAlreadyExists := Get(DocumentNo, DocumentType, ParameterType); if not ParameterAlreadyExists then begin Init(); "Document No" := DocumentNo; "Document Type" := "Sales Document Type".FromInteger(DocumentType); "Parameter Type" := "Email Parameter Type".FromInteger(ParameterType); end; Clear("Parameter Value"); Clear("Parameter BLOB"); if MaxStrLen("Parameter Value") > StrLen(ParameterValue) then "Parameter Value" := CopyStr(ParameterValue, 1, MaxStrLen("Parameter Value")) else WriteToBLOB(ParameterValue); if ParameterAlreadyExists then Modify() else Insert(); end; procedure SaveParameterValueWithReportUsage(DocumentNo: Code[20]; ReportUsage: Integer; ParameterType: Option; ParameterValue: Text) var ReportSelections: Record "Report Selections"; DocumentType: Enum "Sales Document Type"; begin if not ReportSelections.ConvertReportUsageToSalesDocumentType(DocumentType, Enum::"Report Selection Usage".FromInteger(ReportUsage)) then Error(ParameterNotSupportedErr); SaveParameterValue(DocumentNo, DocumentType.AsInteger(), ParameterType, ParameterValue); end; local procedure WriteToBLOB(ParameterValue: Text) var OutStream: OutStream; begin Clear("Parameter BLOB"); "Parameter BLOB".CreateOutStream(OutStream, TEXTENCODING::Windows); OutStream.Write(ParameterValue); end; local procedure GetTextFromBLOB(): Text var TempBlob: Codeunit "Temp Blob"; TypeHelper: Codeunit "Type Helper"; InStream: InStream; begin TempBlob.FromRecord(Rec, FieldNo("Parameter BLOB")); TempBlob.CreateInStream(InStream, TEXTENCODING::Windows); exit(TypeHelper.ReadAsTextWithSeparator(InStream, TypeHelper.LFSeparator())); end;}