public override void OnRunEnd() { base.OnRunEnd(); var reportGenerator = new XmlReportGenerator(_xmlPath, ContextsByAssembly, SpecificationsByContext, ResultsBySpecification, _showTimeInfo); reportGenerator.WriteReports(); }
public void GenerateReport_NullArgument_ThrowsNullArgumentException() { var txtReportGenerator = new TxtReportGenerator(); var xmlReportGenerator = new XmlReportGenerator(); Assert.Multiple(() => { Assert.That(() => txtReportGenerator.GenerateReport(null), Throws.ArgumentNullException); Assert.That(() => xmlReportGenerator.GenerateReport(null), Throws.ArgumentNullException); }); }
public void OnGenerateXMLReportClick(object sender, RoutedEventArgs e) { try { var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now); xmlReporter.GenerateReport(); Print("XML Report from SQL is successfully genrated."); } catch (Exception ex) { Print(ex.Message); } }
private static void GenerateXmlReports(string pathToSave) { using (var db = new ChemicalsDbContext()) { var manufacturers = (from man in db.Manufacturers.Include("Name") join p in db.Produces on man.Id equals p.ManufacturerId join pr in db.Products.Include("Name").Include("Formula") on p.ProductId equals pr.Id select new { ManufacturerName = man.Name, ProductName = pr.Name, Amount = p.Amount, Formula = pr.Formula }).ToList(); var manufacturersList = new List <XmlManufacturer>(); var productsList = new List <XmlProduct>(); foreach (var manufacturer in manufacturers) { productsList.Add(new XmlProduct { Name = manufacturer.ProductName, Amout = manufacturer.Amount, Formula = manufacturer.Formula }); var currentManufacturer = new XmlManufacturer { Name = manufacturer.ManufacturerName, Products = productsList }; manufacturersList.Add(currentManufacturer); } var report = new XmlReportModel { Manufacturers = manufacturersList }; var reportGenerator = new XmlReportGenerator(); reportGenerator.ExportXmlReport(report, pathToSave); } Console.WriteLine("The report was successfully generated."); }
public void GeneratesXml() { // Arrange var generator = new XmlReportGenerator(utility.SaveFolder); generator.AddFile("file1.xml"); generator.AddLockItem("1", "locked content", "structure match"); generator.AddTagItem("3", "<SomeTag>"); generator.AddConversionItem("4", "before", "after", "searchText", "replaceText"); // Act var xml = generator.ToString(); // Assert Assert.NotNull(xml); output.WriteLine(xml); }
public static void Main() { var repo = new VehicleVendorRepository(new IVehicleVendorDbContext[] { new VehicleVendorDbContext() }); var repoMySql = new VehicleVendorMySqlRepository(); var repoSqLite = new VehicleVendorSqLiteRepository(new SqLiteContext()); var repoMongo = new VehicleVendorMongoRepository(new VehicleVendorMongoDb()); var mongoLoader = new MongoLoader(repo, repoMongo); mongoLoader.LoadRepository(); repo.SaveChanges(); var xmlParser = new XmlParser(repo); var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd"); var xmlLoader = new XmlLoader(repo, parseResult); xmlLoader.LoadRepository(); repo.SaveChanges(); var zipExLoader = new ZipExcelLoaderNonCom(repo); zipExLoader.LoadRepository(); repo.SaveChanges(); var pdfReporter = new PdfReportSQLServerGenerator(repo); pdfReporter.GenerateReport(); var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now); xmlReporter.GenerateReport(); var jsonReporter = new JsonReportSQLServerGenerator(repo); jsonReporter.GenerateReport(); var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql); jsonToMySql.WriteJsonsReportsToMySql(); var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, repoSqLite, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1)); excelReporter.GenerateReport(); }
protected void btnGenerateXMLSalesReportbyVendors_Click(object sender, EventArgs e) { string folderReport = Server.MapPath("/Reports/Xml/"); string fileName = Guid.NewGuid() + ".xml"; string filePath = folderReport + fileName; if (Helpers.DirectoryExist(folderReport)) { XmlReportGenerator.GenerateXmlReport(filePath); if (File.Exists(filePath)) { HttpResponse response = HttpContext.Current.Response; response.ClearContent(); response.Clear(); response.ContentType = "Application/xml"; response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ";"); response.TransmitFile(filePath); response.Flush(); response.End(); } } }
private static void GenerateXmlReports(string pathToSave) { using (var db = new ChemicalsDbContext()) { var manufacturers = (from man in db.Manufacturers.Include("Name") join p in db.Produces on man.Id equals p.ManufacturerId join pr in db.Products.Include("Name").Include("Formula") on p.ProductId equals pr.Id select new { ManufacturerName = man.Name, ProductName = pr.Name, Amount = p.Amount, Formula = pr.Formula }).ToList(); var manufacturersList = new List<XmlManufacturer>(); var productsList = new List<XmlProduct>(); foreach (var manufacturer in manufacturers) { productsList.Add(new XmlProduct { Name = manufacturer.ProductName, Amout = manufacturer.Amount, Formula = manufacturer.Formula }); var currentManufacturer = new XmlManufacturer { Name = manufacturer.ManufacturerName, Products = productsList }; manufacturersList.Add(currentManufacturer); } var report = new XmlReportModel { Manufacturers = manufacturersList }; var reportGenerator = new XmlReportGenerator(); reportGenerator.ExportXmlReport(report, pathToSave); } Console.WriteLine("The report was successfully generated."); }
public static void Main() { using (var repo = new VehicleVendorRepository( new IVehicleVendorDbContext[] { new VehicleVendorDbContext() })) { var nissanMongoDb = new VehicleVendorMongoDb(); var mongoLoader = new MongoLoader(repo, nissanMongoDb); Console.Write("Loading MongoDb data to SQL DB... "); mongoLoader.LoadRepository(); repo.SaveChanges(); Console.WriteLine("Done."); var xmlParser = new XmlParser(repo); Console.Write("Parsing XML data... "); var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd"); var xmlLoader = new XmlLoader(repo, parseResult); Console.WriteLine("Done."); Console.Write("Loading XML data to SQL DB... "); xmlLoader.LoadRepository(); repo.SaveChanges(); Console.WriteLine("Done."); var zipExLoader = new ZipExcelLoaderNonCom(repo); Console.Write("Loading Excel zipped data... "); zipExLoader.LoadRepository(); repo.SaveChanges(); Console.WriteLine("Done."); var pdfReporter = new PdfReportSQLServerGenerator(repo); Console.Write("Generating pdf report... "); pdfReporter.GenerateReport(); Console.WriteLine("Done."); var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now); Console.Write("Generating xml report... "); xmlReporter.GenerateReport(); Console.WriteLine("Done."); var jsonReporter = new JsonReportSQLServerGenerator(repo); Console.Write("Generating JSON report... "); jsonReporter.GenerateReport(); Console.WriteLine("Done."); using (var repoMySql = new VehicleVendorMySqlRepository()) { var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql); Console.Write("Loading JSON to MySQL... "); jsonToMySql.WriteJsonsReportsToMySql(); Console.WriteLine("Done."); using (var sqliteDb = new SqLiteContext()) { var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, sqliteDb, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1)); Console.Write("Generating Excel report... "); excelReporter.GenerateReport(); Console.WriteLine("Done."); } } } }