public Dictionary <string, object> LoadReportFromDB(string reportName, string operationalMode, string analysisMode, string olapReport, string clientReports)
{
PivotReport report = new PivotReport();
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(reportName))
{
if (operationalMode.ToLower() == "servermode" && analysisMode == "olap")
{
string reportString = "";
OlapDataManager DataManager = new OlapDataManager();
reportString = OLAPUTILS.Utils.CompressData(row.ItemArray[1] as byte[]);
DataManager.Reports = pivotClient.DeserializedReports(reportString);
DataManager.SetCurrentReport(DataManager.Reports[0]);
return(pivotClient.GetJsonData("toolbarOperation", DataManager, "Load Report", reportName));
}
else
{
byte[] reportString = new byte[2 * 1024];
reportString = (row.ItemArray[1] as byte[]);
if (analysisMode.ToLower() == "pivot" && operationalMode.ToLower() == "servermode")
{
dictionary = pivotClient.GetJsonData("LoadReport", ProductSales.GetSalesData(), Encoding.UTF8.GetString(reportString));
}
else
{
dictionary.Add("report", Encoding.UTF8.GetString(reportString));
}
break;
}
}
}
return(dictionary);
}
public Dictionary <string, object> DrillChart(Dictionary <string, object> jsonResult)
{
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(jsonResult["olapReport"].ToString()));
DataManager.Reports = olapClientHelper.DeserializedReports(jsonResult["clientReports"].ToString());
return(chartHelper.GetJsonData(jsonResult["action"].ToString(), DataManager, jsonResult["drilledSeries"].ToString()));
}
public Dictionary <string, object> DrillTreeMap(string action, string drillInfo, string olapReport, string clientReports)
{
OlapDataManager DataManager = new OlapDataManager(connectionString);
DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(olapReport));
DataManager.Reports = olapClientHelper.DeserializedReports(clientReports);
return(treeMapHelper.GetJsonData(action, DataManager, drillInfo));
}
public Dictionary <string, object> CubeChange(string action, string cubeName, string olapReport, string clientReports, string clientParams)
{
OlapDataManager DataManager = new OlapDataManager(connectionString);
if (olapReport != "")
{
DataManager.SetCurrentReport(OLAPUTILS.Utils.DeserializeOlapReport(olapReport));
}
if (clientReports != "")
{
DataManager.Reports = olapClientHelper.DeserializedReports(clientReports);
}
return(olapClientHelper.GetJsonData(action, DataManager, cubeName, clientParams));
}