public sealed override void Dispose() { if (PivotClient1 != null) { PivotClient1.Loaded -= PivotClient1_Loaded; PivotClient1.Dispose(); } PivotClient1 = null; if (olapDataManager != null) { olapDataManager.OlapDataChanged -= OlapDataManager_OlapDataChanged; olapDataManager.GetCubeSchema -= OlapDataManager_GetCubeSchema; olapDataManager.GetCubeInfoCollection -= OlapDataManager_GetCubeInfoCollection; olapDataManager.GetChildMembers -= OlapDataManager_GetChildMembers; olapDataManager.GetChildrenByMDX -= OlapDataManager_GetChildrenByMDX; olapDataManager.GetOlapDataWithTotalCount -= OlapDataManager_GetOlapDataWithTotalCount; olapDataManager.GetLevelMembersUsingMdx -= OlapDataManager_GetLevelMembersUsingMdx; olapDataManager.Dispose(); } olapDataManager = null; clientChannel = null; base.Dispose(); }
public PivotClientCustomization() { ApplicationLanguages.PrimaryLanguageOverride = "en-US"; InitializeComponent(); allowMultiFunctionalSortFilterBinding = new Binding { Path = new PropertyPath("IsChecked"), ElementName = "chk_AllowMultiFunctionalSortFilter", Mode = BindingMode.TwoWay }; showValueCellToolTipBinding = new Binding { Path = new PropertyPath("IsChecked"), ElementName = "ShowValueCellToolTip", Mode = BindingMode.TwoWay }; showHyperlinkBinding = new Binding { Path = new PropertyPath("IsChecked"), ElementName = "ShowHyperlink", Mode = BindingMode.TwoWay }; freezeHeadersBinding = new Binding { Path = new PropertyPath("IsChecked"), ElementName = "FreezeHeaders", Mode = BindingMode.TwoWay }; showLegendBinding = new Binding { Path = new PropertyPath("IsChecked"), ElementName = "ShowLegend", Mode = BindingMode.TwoWay, Converter = new PivotClientSamples.Converters.BooleanVisibilityConverter() }; PivotClient1.ItemsSource = viewModel.ProductSalesData; // Adding rows to SfPivotGrid PivotClient1.PivotRows.Add(new Syncfusion.PivotAnalysis.UWP.PivotItem() { FieldMappingName = "Product", TotalHeader = "Total" }); PivotClient1.PivotRows.Add(new Syncfusion.PivotAnalysis.UWP.PivotItem() { FieldMappingName = "Date", TotalHeader = "Total" }); // Adding columns to SfPivotGrid PivotClient1.PivotColumns.Add(new Syncfusion.PivotAnalysis.UWP.PivotItem() { FieldMappingName = "Country", TotalHeader = "Total" }); // Adding calculations to SfPivotGrid PivotClient1.PivotCalculations.Add(new PivotComputationInfo() { FieldHeader = "Amount", FieldName = "Amount", Format = "C", SummaryType = Syncfusion.PivotAnalysis.UWP.SummaryType.DoubleTotalSum }); PivotClient1.PivotCalculations.Add(new PivotComputationInfo() { FieldHeader = "Quantity", FieldName = "Quantity", Format = "#.##", SummaryType = Syncfusion.PivotAnalysis.UWP.SummaryType.Count }); PivotClient1.SetBinding(SfPivotClient.AllowMultiFunctionalSortFilterProperty, allowMultiFunctionalSortFilterBinding); }
public sealed override void Dispose() { ShowGrandTotal.Click -= ShowGrandTotal_Click; ShowLevelTypeAll.Click -= ShowLevelTypeAll_Click; if (rdBtn_Olap != null) { this.rdBtn_Olap.Click -= OlapDataSource_Click; } rdBtn_Olap = null; if (rdBtn_Relational != null) { this.rdBtn_Relational.Click -= RelationalDataSource_Click; } rdBtn_Relational = null; allowMultiFunctionalSortFilterBinding = null; showValueCellToolTipBinding = null; showHyperlinkBinding = null; freezeHeadersBinding = null; showLegendBinding = null; if (PivotClient1 != null) { PivotClient1.Dispose(); } PivotClient1 = null; if (pivotClient != null) { pivotClient.Loaded -= PivotClient_Loaded; pivotClient.Dispose(); } pivotClient = null; if (viewModel != null) { viewModel.Dispose(); } base.Dispose(); }