/// <summary> /// Method is used to freeing the memory with clearing instances, events and objects. /// </summary> public sealed override void Dispose() { base.Dispose(); if (pivotGrid != null) { pivotGrid.Dispose(); } pivotGrid = null; if (olapDataManager != null) { olapDataManager.OlapDataChanged -= OlapDataManager_OlapDataChanged; olapDataManager.GetCubeSchema -= OlapDataManager_GetCubeSchema; olapDataManager.GetCubeInfoCollection -= OlapDataManager_GetCubeInfoCollection; olapDataManager.Dispose(); } olapDataManager = null; if (cmbLayout != null) { cmbLayout.SelectionChanged -= cmbLayout_SelectionChanged; } cmbLayout = null; }
public Dictionary <string, object> LoadReportFromDB(Dictionary <string, object> jsonResult) { PivotReport report = new PivotReport(); string operationalMode = jsonResult["operationalMode"].ToString(), analysisMode = jsonResult["analysisMode"].ToString(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); string currentRptName = string.Empty; foreach (DataRow row in GetDataTable().Rows) { currentRptName = (row.ItemArray[0] as string).Replace("##" + operationalMode.ToLower() + "#>>#" + analysisMode.ToLower(), ""); if (currentRptName.Equals(jsonResult["reportName"].ToString())) { if (operationalMode.ToLower() == "servermode" && analysisMode == "olap") { var reportString = ""; OlapDataManager DataManager = new OlapDataManager(connectionString); reportString = OLAPUTILS.Utils.CompressData(row.ItemArray[1] as byte[]); DataManager.Reports = olapClientHelper.DeserializedReports(reportString); DataManager.SetCurrentReport(DataManager.Reports[0]); return(olapClientHelper.GetJsonData("toolbarOperation", DataManager, "Load Report", jsonResult["reportName"].ToString())); } else { byte[] reportString = new byte[2 * 1024]; reportString = (row.ItemArray[1] as byte[]); if (analysisMode.ToLower() == "pivot" && operationalMode.ToLower() == "servermode") { dictionary = olapClientHelper.GetJsonData("LoadReport", ProductSales.GetSalesData(), Encoding.UTF8.GetString(reportString)); } else { dictionary.Add("report", Encoding.UTF8.GetString(reportString)); } break; } } } return(dictionary); }
public Dictionary <string, object> CubeChanged(Dictionary <string, object> jsonResult) { OlapDataManager DataManager = new OlapDataManager(connectionString); if (jsonResult["olapReport"].ToString() != "") { DataManager.SetCurrentReport(Syncfusion.JavaScript.Olap.Utils.DeserializeOlapReport(jsonResult["olapReport"].ToString())); } if (jsonResult["clientReports"].ToString() != "") { DataManager.Reports = olapClientHelper.DeserializedReports(jsonResult["clientReports"].ToString()); } dynamic customData = serializer.Deserialize <dynamic>(jsonResult["customObject"].ToString()); if (customData is Dictionary <string, object> && customData.ContainsKey("isPaging")) { DataManager.CurrentReport.EnablePaging = true; DataManager.CurrentReport.PagerOptions.SeriesPageSize = 5; DataManager.CurrentReport.PagerOptions.CategoricalPageSize = 3; } return(olapClientHelper.GetJsonData(jsonResult["action"].ToString(), DataManager, jsonResult["cubeName"].ToString(), jsonResult["clientParams"].ToString())); }
public Dictionary <string, object> InitializeChart(Dictionary <string, object> jsonResult) { OlapDataManager DataManager = null; dynamic customData = serializer.Deserialize <dynamic>(jsonResult["customObject"].ToString()); var cultureIDInfo = new System.Globalization.CultureInfo(("en-US")).LCID; if (customData is Dictionary <string, object> && customData.ContainsKey("Language")) { cultureIDInfo = new System.Globalization.CultureInfo((customData["Language"])).LCID; } connectionString = connectionString.Replace("" + cultureIDInfoval + "", "" + cultureIDInfo + ""); cultureIDInfoval = cultureIDInfo; DataManager = new OlapDataManager(connectionString); DataManager.Culture = new System.Globalization.CultureInfo((cultureIDInfo)); if (jsonResult.ContainsKey("currentReport") && (jsonResult["currentReport"]).ToString() != "" && jsonResult["currentReport"] != null) { DataManager.SetCurrentReport(Syncfusion.JavaScript.Olap.Utils.DeserializeOlapReport(jsonResult["currentReport"].ToString())); } DataManager.SetCurrentReport(CreateOlapReport()); return(PivotChartObj.GetJsonData(jsonResult["action"].ToString(), DataManager)); }
public Dictionary <string, object> DrillGrid(string action, string cellPosition, string currentReport, string headerInfo, string layout, object customObject) { dynamic customData = serializer.Deserialize <dynamic>(customObject.ToString()); OlapDataManager DataManager = new OlapDataManager(connectionString); DataManager = new OlapDataManager(connectionString); if (customData.ContainsKey("Language")) { var cultureIDInfo = new System.Globalization.CultureInfo((customData["Language"])).LCID; connectionString = connectionString.Replace("" + cultureIDInfoval + "", "" + cultureIDInfo + ""); cultureIDInfoval = cultureIDInfo; DataManager = new OlapDataManager(connectionString); DataManager.Culture = new System.Globalization.CultureInfo((customData["Language"])); DataManager.OverrideDefaultFormatStrings = true; } else { DataManager = new OlapDataManager(connectionString); } DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(currentReport)); return(htmlHelper.GetJsonData(action, connectionString, DataManager, cellPosition, headerInfo, layout)); }
/// <summary> /// Initializes a new instance of the <see cref="ReportSerializationViewModel"/> class. /// </summary> public ReportSerializationViewModel() { try { if (AppDomain.CurrentDomain.BaseDirectory.Contains("Binaries_")) { ConnectionString = ReportSerializationModel.Initialize(System.IO.Path.GetFullPath(@"..\..\common\Assets\Config\OLAPSample.config")); } else { ConnectionString = ReportSerializationModel.Initialize(System.IO.Path.GetFullPath(@"..\..\..\common\Assets\Config\OLAPSample.config")); } this.olapDataManager = new OlapDataManager(ReportSerializationViewModel.ConnectionString); this.con = new SqlCeConnection(); string dbConString = SampleSourceHelper.GetOfflineCubeLocation(); dbConString = dbConString.Remove(dbConString.LastIndexOf(@"\")) + @"\ReportsTable.sdf;Persist Security Info=False"; this.con.ConnectionString = "DataSource=" + dbConString; } catch (Exception e) { MessageBox.Show(e.Message, "Error in DB connection"); } }
public Dictionary <string, object> DrillTreeMap(Dictionary <string, object> jsonResult) { OlapDataManager DataManager = new OlapDataManager(connectionString); dynamic customData = serializer.Deserialize <dynamic>(jsonResult["customObject"].ToString()); if (customData is Dictionary <string, object> && customData.ContainsKey("Language")) { int cultureIDInfo = new System.Globalization.CultureInfo((customData["Language"])).LCID; connectionString = connectionString.Replace("" + cultureIDInfovalval + "", "" + cultureIDInfo + ""); cultureIDInfovalval = cultureIDInfo; DataManager = new OlapDataManager(connectionString) { Culture = new System.Globalization.CultureInfo((customData["Language"])) }; } else { DataManager = new OlapDataManager(connectionString); } DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(jsonResult["olapReport"].ToString())); return(htmlHelper.GetJsonData(jsonResult["action"].ToString(), DataManager, jsonResult["drillInfo"].ToString())); }
private void Dispose(bool isDisposing) { if (isDisposing) { ProductSalesData = null; if (this.olapDataManager != null) { this.olapDataManager.OlapDataChanged -= this.OlapDataManager_OlapDataChanged; this.olapDataManager.GetCubeSchema -= this.OlapDataManager_GetCubeSchema; this.olapDataManager.GetCubeInfoCollection -= this.OlapDataManager_GetCubeInfoCollection; this.olapDataManager.GetChildMembers -= this.OlapDataManager_GetChildMembers; this.olapDataManager.GetChildrenByMDX -= this.OlapDataManager_GetChildrenByMDX; this.olapDataManager.GetOlapDataWithTotalCount -= this.OlapDataManager_GetOlapDataWithTotalCount; this.olapDataManager.GetLevelMembersUsingMdx -= this.OlapDataManager_GetLevelMembersUsingMdx; this.olapDataManager.GetExecuteMemberCount -= OlapDataManager_GetExecuteMemberCount; this.olapDataManager.GetParentMember -= OlapDataManager_GetParentMember; this.olapDataManager.GetMeasureGroupsDimensions -= OlapDataManager_GetMeasureGroupsDimensions; this.olapDataManager.ExecuteDrillThroughQuery -= OlapDataManager_ExecuteDrillThroughQuery; this.olapDataManager.Dispose(); } this.olapDataManager = null; } }
public MainWindow() { InitializeComponent(); try { string connectionString = GetConnectionString(); if (connectionString != "") { olapDataManager = new OlapDataManager(connectionString); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Data will not be loaded properly"); } foreach (RadioButton rbutton in this.rBtnGrid.Children) { if (rbutton != null) { rbutton.Checked += new RoutedEventHandler(rbutton_Checked); } } }
public Dictionary <string, object> DrillGrid(Dictionary <string, object> jsonResult) { dynamic customData = serializer.Deserialize <dynamic>(jsonResult["customObject"].ToString()); OlapDataManager DataManager = new OlapDataManager(connectionString); if (customData is Dictionary <string, object> && customData.ContainsKey("Language")) { int cultureIDInfo = new System.Globalization.CultureInfo((customData["Language"])).LCID; connectionString = connectionString.Replace("" + cultureIDInfoval + "", "" + cultureIDInfo + ""); cultureIDInfoval = cultureIDInfo; DataManager = new OlapDataManager(connectionString) { Culture = new System.Globalization.CultureInfo((customData["Language"])), OverrideDefaultFormatStrings = true }; } else { DataManager = new OlapDataManager(connectionString); } DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(jsonResult["currentReport"].ToString())); return(htmlHelper.GetJsonData(jsonResult["action"].ToString(), connectionString, DataManager, jsonResult["cellPosition"].ToString(), jsonResult["headerInfo"].ToString(), jsonResult["layout"].ToString())); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(ProductSalesAnalysis()); }
/// <summary> /// Initializes a new instance of the <see cref="ReportInCodeViewModel"/> class. /// </summary> public ReportInCodeViewModel() { ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(SimpleReport()); }
/// <summary> /// Initializes a new instance of the <see cref="MDXQueryViewModel"/> class. /// </summary> public MDXQueryViewModel() { ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.MdxQuery = CurrentMDXQuery = SimpleDimensions(); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { this.olapDataManager = new OlapDataManager(ConnectionString); this.olapDataManager.LoadReportDefinitionFile(SampleSourceHelper.GetSamplePath() + @"Common\Data\CubeModelTemplates\ReportDefenitionFile.xml"); this.olapDataManager.LoadReport(this.olapDataManager.Reports[0].Name); }
/// <summary> /// Initializes a new instance of the <see cref="SalesOfProductsAnalysisViewModel"/> class. /// </summary> public SalesOfProductsAnalysisViewModel() { ConnectionString = OlapChartModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(OlapReport()); }
/// <summary> /// Initializes a new instance of the <see cref="CellSelectionViewModel"/> class. /// </summary> public CellSelectionViewModel() { ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(ProductSalesReport()); }
/// <summary> /// Initializes a new instance of the <see cref="KPIViewModel"/> class. /// </summary> public KPIViewModel() { ConnectionString = OlapChartModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(SimpleDimensions()); }
/// <summary> /// Initializes a new instance of the <see cref="MemberPropertiesViewModel"/> class. /// </summary> public MemberPropertiesViewModel() { ConnectionString = KPIModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(ReportWithMemberProperties()); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(LoadBasicKPI()); }
/// <summary> /// Initializes a new instance of the <see cref="DrillStateViewModel"/> class. /// </summary> public DrillStateViewModel() { ConnectionString = OlapChartModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(CreateOlapReport()); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(CreateReport()); }
/// <summary> /// Initializes a new instance of the <see cref="CalculatedMembersViewModel"/> class. /// </summary> public CalculatedMembersViewModel() { ConnectionString = CalculatedMembersModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); this.olapDataManager = new OlapDataManager(ConnectionString); this.olapDataManager.SetCurrentReport(CalculatedReport()); }
/// <summary> /// Initializes a new instance of the <see cref="ConfigurationViewModel"/> class. /// </summary> public ConfigurationViewModel() { ConnectionString = ConfigurationModel.Initialize(System.IO.Path.GetFullPath(@"Assets\Config\OLAPSample.config")); this.olapDataManager = new OlapDataManager(ConnectionString); }
public sealed override void Dispose() { if (pivotClient1 != null) { pivotClient1.Dispose(); } pivotClient1 = null; if (pivotClient != null) { pivotClient.Dispose(); } pivotClient = null; clientToolbarBinding = null; gridToolbarBinding = null; chartToolbarBinding = null; showTogglePivotButtonBinding = null; showMDXButtonBinding = null; showExpanderButtonBinding = null; showReportListBinding = null; showReportMenuBinding = null; showCubeDimensionBrowserBinding = null; showSearchBoxBinding = null; showSlicerAxisBinding = null; showColumnAxisBinding = null; showRowAxisBinding = null; showValueAxisBinding = null; displayModeBinding = null; 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; if (viewModel != null) { viewModel.Dispose(); } viewModel = 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(); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { this.olapDataManager = new OlapDataManager(ConnectionString); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { this.olapDataManager = new OlapDataManager(ConnectionString); this.olapDataManager.MdxQuery = CurrentMDXQuery = SimpleDimensions(); this.olapDataManager.AllowMdxToOlapReportParse = AllowMDXToOlapReportParse; }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(SimpleDimensions()); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { this.olapDataManager = new OlapDataManager(ConnectionString); this.olapDataManager.SetCurrentReport(VirtualKPIReport()); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(CreateOlapReport("Drill Member")); }
/// <summary> /// Initializes a new instance of the <see cref="ViewModel"/> class. /// </summary> public ViewModel() { olapDataManager = new OlapDataManager(ConnectionString); olapDataManager.SetCurrentReport(OlapReport()); olapDataManager.CurrentReport.ChartSettings.LabelsVisibility = true; }