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.");
}
}
}
}
