public ContentResult Report() { var s = new JsonSerializer<List<ConnectionStringConfig>>(); var x = s.DeserializeFromReader(new StreamReader(HttpContext.Server.MapPath("../json") + "\\" + "ConnectionStrings.json")); var reportConfig = new SqlReportConfig { ReportTemplateRoot = HttpContext.Server.MapPath("../sql") + "\\", ReportName = "employeeList", ConnectionString = "Data Source=CORPSPLRPTDB1;Initial Catalog=ApplicationLog;Persist Security Info=True;Trusted_Connection=True;" }; var jsonHtmlTableGenerator = new JsonHtmlTableGenerator(reportConfig); var jsonHtmlTable = jsonHtmlTableGenerator.GetJsonTable(JsonHtmlTableType.DataTables); return new ContentResult { Content = jsonHtmlTable, ContentType = "application/json" }; }
private SqlReportConfig BaseReportConfig() { const string cachedConfigKey = "BaseReportConfig"; var reportConfig = System.Web.HttpContext.Current.Cache.Get(cachedConfigKey) as SqlReportConfig; if (reportConfig == null) { reportConfig = new SqlReportConfig {ReportTemplateRoot = HttpContext.Server.MapPath("../sql") + "\\"}; System.Web.HttpContext.Current.Cache.Insert(cachedConfigKey, reportConfig); } return reportConfig; }