private static void GenerateJsonReports() { var dbContext = new ChemicalsDbContext(); var listOfProducts = dbContext.Products.ToList(); JSONReportGenerator.ExportProducts(listOfProducts, "../../../Reports/"); Console.WriteLine("The reports was successfully generated."); }
private static void GetAllProducts() { using (var dbContext = new ChemicalsDbContext()) { var products = dbContext.Products.ToList(); foreach (var product in products) { Console.WriteLine("{0}, {1}, {2}, {3}", product.Id, product.Name, product.Formula, product.PricePerUnit); } } }
private static void ImportProducesFromExcel() { var db = new ChemicalsDbContext(); IZipExtractor zipExtractor = new ZipExtractor(); ExcelImporter <Produce> k = new ExcelImporter <Produce>(zipExtractor); ICollection <Produce> produces = k.ImportModelsDataFromZipFile("../../../Files/Produces.zip", "./tests1"); foreach (var item in produces) { db.Produces.Add(item); } db.SaveChanges(); }
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."); }
private static void ImportTradersFromXml(string path) { var xmlImporter = new XmlDataImporter(); var dbContext = new ChemicalsDbContext(); var traders = xmlImporter.LoadTraders(path); foreach (var trader in traders) { dbContext.Traders.Add(trader); } dbContext.SaveChanges(); dbContext.Dispose(); ExportXmlTradersToMongo(traders); }
private static void ImportSalesFromExcel() { var db = new ChemicalsDbContext(); IZipExtractor zipExtractor = new ZipExtractor(); ExcelImporter <Sale> k = new ExcelImporter <Sale>(zipExtractor); ICollection <Sale> sales = k.ImportModelsDataFromZipFile("../../../Files/Sales.zip", "./tests2"); foreach (var item in sales) { db.Sales.Add(item); } db.SaveChanges(); Console.WriteLine("The data was successfully imported to SQL Server."); }
private static void ImportManufacturersFromXml(string path) { var xmlImporter = new XmlDataImporter(); var dbContext = new ChemicalsDbContext(); var manufacturers = xmlImporter.LoadManufecturers(path); foreach (var manufacturer in manufacturers) { dbContext.Manufacturers.Add(manufacturer); } dbContext.SaveChanges(); dbContext.Dispose(); ExportXmlManufacturersToMongo(manufacturers); Console.WriteLine("The data was successfully imported to SQL Server and to MongoDB."); }
private static void GeneratePdfReports() { var pdfReportsGenerator = new PdfReportGenerator(); var dbContext = new ChemicalsDbContext(); var deals = dbContext.Sales .Select(d => new PdfReportModel { ProductName = d.Product.Name, Quantity = (d.Quantity + " " + d.Product.Measure.MeasureName).ToString(), PricePerUnit = d.Product.PricePerUnit.ToString(), Formula = d.Product.Formula, Address = d.Trader.Address, Total = (d.Quantity * d.Product.PricePerUnit).ToString() }).ToList(); pdfReportsGenerator.GenerateReport(deals); Console.WriteLine("The report was successfully generated."); }
private static void ImportDataFromMongo() { var dbContext = new ChemicalsDbContext(); var mongoProvider = new MongoProvider( System.Configuration.ConfigurationManager.ConnectionStrings["MolybdenumDb"].ConnectionString, System.Configuration.ConfigurationManager.ConnectionStrings["MolybdenumDb"].Name); var mongoDatabase = mongoProvider.GetDatabase(); var mongoImporter = new MongoImporter(); var products = mongoImporter.GetAllProducts(mongoDatabase, "Products"); foreach (var product in products) { dbContext.Products.Add(product); } dbContext.SaveChanges(); Console.WriteLine("The data was successfully imported to the SQL Server."); }
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."); }
private static void ImportSalesFromExcel() { var db = new ChemicalsDbContext(); IZipExtractor zipExtractor = new ZipExtractor(); ExcelImporter<Sale> k = new ExcelImporter<Sale>(zipExtractor); ICollection<Sale> sales = k.ImportModelsDataFromZipFile("../../../Files/Sales.zip", "./tests2"); foreach (var item in sales) { db.Sales.Add(item); } db.SaveChanges(); Console.WriteLine("The data was successfully imported to SQL Server."); }
private static void ImportProducesFromExcel() { var db = new ChemicalsDbContext(); IZipExtractor zipExtractor = new ZipExtractor(); ExcelImporter<Produce> k = new ExcelImporter<Produce>(zipExtractor); ICollection<Produce> produces = k.ImportModelsDataFromZipFile("../../../Files/Produces.zip", "./tests1"); foreach (var item in produces) { db.Produces.Add(item); } db.SaveChanges(); }