Пример #1
0
        public void Can_Generate_Google_Json_String_Table()
        {
            var config = JsonConfigReader<SqlReportConfig>.GetConfig(@"C:\Projects\JsonHtmlTable\json\sqlReportConfig.json");
            config.ReportName = "jobFiles";

            var jsonTableGenerator = new JsonHtmlTableGenerator(config);

            var jsonReport = jsonTableGenerator.GetJsonTable(JsonHtmlTableType.Google);
            Assert.IsTrue(jsonReport.Length > 0);
        }
Пример #2
0
        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" };
        }
Пример #3
0
        public ContentResult Table(SqlReportRequest sqlReportRequest)
        {
            var sqlReportConfig = BaseReportConfig();

            var connectionStringConfig =
                ConnectionStrings().Where(
                    cs =>
                    cs.DB.ToLower().Equals(sqlReportRequest.DB.ToLower()) &&
                    cs.Server.ToLower().Equals(sqlReportRequest.Server.ToLower())).FirstOrDefault();

            if (connectionStringConfig == null)
                throw new Exception("No Valid Connection String Exists for: Server = " + sqlReportRequest.Server +
                                    " and DB = " + sqlReportRequest.DB);

            sqlReportConfig.ConnectionString = connectionStringConfig.ConnectionString;
            sqlReportConfig.ReportName = sqlReportRequest.DB + "." + sqlReportRequest.Report;

            var jsonHtmlTableGenerator = new JsonHtmlTableGenerator(sqlReportConfig);
            string jsonHtmlTable = jsonHtmlTableGenerator.GetJsonTable(JsonHtmlTableType.DataTables);
            return new ContentResult {Content = jsonHtmlTable, ContentType = "application/json"};
        }