Codeunit 478 Business Chart Impl.

System Application, System.Visualization

src/System Application/App/Business Chart/src/BusinessChartImpl.Codeunit.al215 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 System.Visualization;using System;using System.Integration;using System.Utilities;codeunit 478 "Business Chart Impl."{    Access = Internal;    InherentEntitlements = X;    InherentPermissions = X;    var        DotNetBusinessChartData: DotNet BusinessChartData;        DotNetDataTable: DotNet DataTable;        MeasureNameToValueMap: Dictionary of [Text, Text];        IsInitialized: Boolean;        InvalidDataTypeForMeasureErr: Label 'Data Type must be Integer or Decimal for Measure %1.', Comment = '%1 - name of the measure';    procedure Initialize()    var        DotNetCultureInfo: DotNet CultureInfo;    begin        if not IsInitialized then begin            DotNetDataTable := DotNetDataTable.DataTable('DataTable');            DotNetCultureInfo := DotNetCultureInfo.CultureInfo(WindowsLanguage);            DotNetDataTable.Locale := DotNetCultureInfo.InvariantCulture;            DotNetBusinessChartData := DotNetBusinessChartData.BusinessChartData();            IsInitialized := true;        end;        DotNetDataTable.Clear();        DotNetDataTable.Columns.Clear();        DotNetBusinessChartData.ClearMeasures();        Clear(MeasureNameToValueMap);    end;    procedure SetShowChartCondensed(ShowChartCondensed: Boolean)    begin        DotNetBusinessChartData.ShowChartCondensed := ShowChartCondensed;    end;    procedure SetXDimension(Caption: Text; DataColumnType: Enum "Business Chart Data Type")    begin        AddDataColumn(Caption, DataColumnType);        DotNetBusinessChartData.XDimension := Caption;    end;    procedure GetXDimension(): Text    begin        exit(DotNetBusinessChartData.XDimension);    end;    procedure GetXDimensionDataType(): Enum "Business Chart Data Type"    var        DotNetTypeName: Text;    begin        DotNetTypeName := Format(DotNetDataTable.Columns.Item(0).DataType);        exit(GetBusinessChartDataType(DotNetTypeName));    end;    procedure AddMeasure(Caption: Text; MeasureVariant: Variant; DataColumnType: Enum "Business Chart Data Type"; ChartType: Enum "Business Chart Type")    var        DotNetDataMeasureType: DotNet DataMeasureType;    begin        if not (DataColumnType in [DataColumnType::Integer, DataColumnType::Decimal]) then            Error(InvalidDataTypeForMeasureErr, Caption);        AddDataColumn(Caption, DataColumnType);        DotNetDataMeasureType := ChartType.AsInteger();        DotNetBusinessChartData.AddMeasure(Caption, DotNetDataMeasureType);        AddEntryToMapSafely(MeasureNameToValueMap, Caption, Format(MeasureVariant, 0, 9));    end;    procedure AddDataRowWithXDimension(XDimensionColumnValue: Text)    var        DotNetDataRow: DotNet DataRow;    begin        DotNetDataRow := DotNetDataTable.NewRow();        DotNetDataRow.Item(GetXDimension(), XDimensionColumnValue);        DotNetDataTable.Rows.Add(DotNetDataRow);    end;    procedure AddDataColumn(Caption: Text; ValueType: Enum "Business Chart Data Type")    var        DotNetDataColumn: DotNet DataColumn;        DotNetSystemType: DotNet Type;    begin        DotNetDataColumn := DotNetDataColumn.DataColumn(Caption);        DotNetDataColumn.Caption := Caption;        DotNetDataColumn.ColumnName(Caption);        DotNetDataColumn.DataType(DotNetSystemType.GetType(GetDotNetTypeName(ValueType)));        DotNetDataTable.Columns.Add(DotNetDataColumn);    end;    procedure SetValue(MeasureName: Text; XAxisIndex: Integer; MeasureValueVariant: Variant)    var        DotNetDataRow: DotNet DataRow;    begin        DotNetDataRow := DotNetDataTable.Rows.Item(XAxisIndex);        DotNetDataRow.Item(MeasureName, MeasureValueVariant);    end;    procedure SetValue(MeasureIndex: Integer; XAxisIndex: Integer; ValueVariant: Variant)    var        DotNetDataRow: DotNet DataRow;        ColumnName: Text;    begin        DotNetDataRow := DotNetDataTable.Rows.Item(XAxisIndex);        ColumnName := MeasureNameToValueMap.Keys().Get(MeasureIndex + 1);        DotNetDataRow.Item(ColumnName, ValueVariant);    end;    procedure GetValue(MeasureName: Text; XAxisIndex: Integer; var MeasureValueVariant: Variant)    var        DotNetDataRow: DotNet DataRow;    begin        DotNetDataRow := DotNetDataTable.Rows.Item(XAxisIndex);        MeasureValueVariant := DotNetDataRow.Item(MeasureName);    end;    procedure GetMaxNumberOfMeasures(): Integer    var        MaximumNumberOfColoursInChart: Integer;    begin        MaximumNumberOfColoursInChart := 6;        exit(MaximumNumberOfColoursInChart);    end;    procedure Update(BusinessChartAddIn: ControlAddIn BusinessChart)    var        JsonConvert: DotNet JsonConvert;        BusinessChartAsJson: JsonObject;        BusinessChartText: Text;    begin        DotNetBusinessChartData.DataTable := DotNetDataTable;        BusinessChartText := JsonConvert.SerializeObject(DotNetBusinessChartData);        BusinessChartAsJson.ReadFrom(BusinessChartText);        BusinessChartAddIn.Update(BusinessChartAsJson);    end;    procedure GetMeasureNameToValueMap(): Dictionary of [Text, Text];    begin        exit(MeasureNameToValueMap)    end;    procedure WriteToXMLDocument(DotNetXMLDocument: DotNet XmlDocument)    var        TempBlob: Codeunit "Temp Blob";        XMLElement: DotNet XmlElement;        OutStream: OutStream;        InStream: InStream;        XMLLine: Text;        XMLText: Text;    begin        TempBlob.CreateOutStream(OutStream);        DotNetDataTable.WriteXml(OutStream);        TempBlob.CreateInStream(InStream);        while not InStream.EOS do begin            InStream.ReadText(XMLLine);            XMLText := XMLText + XMLLine;        end;        XMLElement := DotNetXMLDocument.CreateElement('DataTable', 'test', '');        XMLElement.InnerXml(XMLText);        DotNetXMLDocument.AppendChild(XMLElement);    end;    local procedure GetDotNetTypeName(BusinessChartDataType: Enum "Business Chart Data Type"): Text    begin        case BusinessChartDataType of            BusinessChartDataType::String:                exit('System.String');            BusinessChartDataType::Integer:                exit('System.Int32');            BusinessChartDataType::Decimal:                exit('System.Decimal');            BusinessChartDataType::DateTime:                exit('System.DateTime');        end;    end;    local procedure GetBusinessChartDataType(DotNetTypeName: Text): Enum "Business Chart Data Type"    begin        case DotNetTypeName of            'System.String':                exit(Enum::"Business Chart Data Type"::String);            'System.Int32':                exit(Enum::"Business Chart Data Type"::Integer);            'System.Decimal':                exit(Enum::"Business Chart Data Type"::Decimal);            'System.DateTime':                exit(Enum::"Business Chart Data Type"::DateTime);        end;    end;    local procedure AddEntryToMapSafely(Map: Dictionary of [Text, Text]; KeyText: Text; ValueText: Text)    var        KeyTextToAdd: Text;        Index: Integer;    begin        KeyTextToAdd := KeyText;        Index := 2;        while (Map.ContainsKey(KeyTextToAdd)) do begin            KeyTextToAdd := KeyText + '_' + Format(Index);            Index += 1;        end;        Map.Add(KeyTextToAdd, ValueText);    end;}