public Dictionary <string, object> LoadReportFromDB(Dictionary <string, object> jsonResult) { byte[] reportString = new byte[2 * 1024]; PivotReport report = new PivotReport(); var reports = ""; string mode = jsonResult["operationalMode"].ToString(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); if (mode == "serverMode" && jsonResult.ContainsKey("clientReports")) { reports = jsonResult["clientReports"].ToString(); } else { foreach (DataRow row in GetDataTable().Rows) { if ((row.ItemArray[0] as string).Equals(jsonResult["reportName"].ToString())) { if (mode == "clientMode") { reportString = (row.ItemArray[1] as byte[]); dictionary.Add("report", Encoding.UTF8.GetString(reportString)); break; } else if (mode == "serverMode") { reports = OLAPUTILS.Utils.CompressData(row.ItemArray[1] as byte[]); break; } } } } if (reports != "") { report = htmlHelper.DeserializedReports(reports); htmlHelper.PivotReport = report; dictionary = htmlHelper.GetJsonData("loadOperation", ProductSales.GetSalesData(), "Load Report", jsonResult["reportName"].ToString()); } return(dictionary); }
public Dictionary <string, object> LoadReportFromDB(string reportName, string operationalMode, string olapReport, string clientReports) { byte[] reportString = new byte[2 * 1024]; PivotReport report = new PivotReport(); var reports = ""; string mode = operationalMode; Dictionary <string, object> dictionary = new Dictionary <string, object>(); if (mode == "serverMode" && !string.IsNullOrEmpty(clientReports)) { reports = clientReports; } else { foreach (DataRow row in GetDataTable().Rows) { if ((row.ItemArray[0] as string).Equals(reportName)) { if (mode == "clientMode") { reportString = (row.ItemArray[1] as byte[]); dictionary.Add("report", Encoding.UTF8.GetString(reportString)); break; } else if (mode == "serverMode") { reports = OLAPUTILS.Utils.CompressData(row.ItemArray[1] as byte[]); break; } } } } if (reports != "") { report = htmlHelper.DeserializedReports(reports); htmlHelper.PivotReport = report; dictionary = htmlHelper.GetJsonData("loadOperation", ProductSales.GetSalesData(), "Load Report", reportName); } return(dictionary); }