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();
}