/// <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;
}
