public static void Main() { IDatabase db = new Database(); //read from zip file & populate the database with more data + create updates pdf, xml & json files var reader = new ReadExcelFromZip(); var movies = reader.SelectExcelFilesFromZip("../../../../Movies.zip"); foreach (var movie in movies) { Console.WriteLine(movie.Name); } var import = new MoviesImportToSql(); import.Import(movies); Console.WriteLine("Importing data from xml..."); //Importing data from xml XmlImporter.ImportXml(db); //Console.WriteLine("Importing data to Mongo..."); //Importing data to MongoDB //ImportToMongo.ImportToMongo.ImportData(); Console.WriteLine("Generating xml files..."); //Generating Xml file report var generateXMLFile = new XMLGenerator(); generateXMLFile.Generate(db); Console.WriteLine("Generating json files..."); //Generating Json file reports var generateJsonReports = new JSONGenerator(); generateJsonReports.Generate(db); Console.WriteLine("Generating pdf reports..."); //Generating Pdf fle reports var generatePdfReports = new PDFGenerator(); generatePdfReports.Generate(db); Console.WriteLine("Sending data to MySql..."); //Sending data to MySql var sendDataToMySQL = new MySqlManager(); sendDataToMySQL.SendDataToMySql(); Console.WriteLine("Exporting data from MySql to excel file..."); //Exporting data from MySql to excel file var mySqlExcelExport = new MySqlManager(); mySqlExcelExport.ExportDataFromMySql(); }
public void Generate() { StringWriter outStream = new StringWriter(); string tempDirectory = $"temp/{rnd.Next()}-{rnd.Next()}"; Directory.CreateDirectory(tempDirectory); XMLGenerator generator = new XMLGenerator(outStream, tempDirectory); bool loaded = true; loaded = loaded && generator.LoadOutagesFromCSV(OutagesCSV); loaded = loaded && generator.LoadCriticalBranchesFromCSV(CriticalBranchesCSV); if (loaded) { generator.DontAsk(); generator.SetSettings(Settings); if (generator.Generate()) { if (!IncludeXSD) { //Remove XSD files string[] xsdFiles = Directory.GetFiles(tempDirectory, "*.xsd"); foreach (var file in xsdFiles) { File.Delete(file); } } OutputFile = $"{tempDirectory}.zip"; ZipFile.CreateFromDirectory(tempDirectory, _OutputFile); } } Directory.Delete(tempDirectory, true); ResultSummary = generator.Summary; if (File.Exists(OutagesCSV)) { File.Delete(OutagesCSV); } if (File.Exists(CriticalBranchesCSV)) { File.Delete(CriticalBranchesCSV); } Output = outStream.ToString(); // Clear old outputs ClearTempFolder(); }
public static void Main() { //var db = new MoviesDatabaseOfTeamSingaporeSlingEntities(); //var employees = db.Employees // .Where(e => e.FirstName == "Tom") // .Select(n => // new // { // FirstName = n.FirstName, // LastName = n.LastName, // Salary = n.Salary, // Movies = n.Movies.Select(m => m.Name).ToList(), // IsDirector = n.IsDirector // } // ) // .ToList(); //foreach (var employee in employees) //{ // Console.WriteLine("The actor {0} {1} has participated in this movies:", employee.FirstName, employee.LastName); // foreach (var movie in employee.Movies) // { // Console.WriteLine(movie); // } //} var db = new Database(); //Generating Xml file report var generateXMLFile = new XMLGenerator(); generateXMLFile.Generate(db); //Generating Json file reports var generateJsonReports = new JSONGenerator(); generateJsonReports.Generate(db); //Generating Pdf fle reports var generatePdfReports = new PDFGenerator(); generatePdfReports.Generate(db); //XMLImporter.ImportXML(); }