private static void ProcessInputCommands()
{
Console.Write("> ");
string command = Console.ReadLine();
OracleDBManager oracleManager = new OracleDBManager();
SQLServerDBManager sqlManager = new SQLServerDBManager();
while (command != "End")
{
Console.Write("> ");
switch (command)
{
case "oracle import":
Console.WriteLine("Importing data to oracle...");
oracleManager.ImportMeasuresFromCSVFile("../../Output-Files/SeedFiles/Measures.txt");
oracleManager.ImportVendorsFromCSVFile("../../Output-Files/SeedFiles/Vendors.txt");
oracleManager.ImportProductsFromCSVFile("../../Output-Files/SeedFiles/Products.txt");
Console.WriteLine("Data has been imported");
break;
case "oracle export":
Console.WriteLine("Exporting data from Oracle to MS SQL Server...");
oracleManager.ExportDataToMSSQLContext(sqlManager.SqlServerContext);
Console.WriteLine("Data exported successfully");
break;
case "zip import":
Console.WriteLine("Importing data from ZIP");
ZipImporter.Import();
Console.WriteLine("Data imported successfully");
break;
case "pdf export":
Console.Write("Input the start date: ");
DateTime startDate = DateTime.Parse(Console.ReadLine());
Console.Write("Input the end date: ");
DateTime endDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Creating the PDF Sales Report.");
CreateSaleReport("../../Output-Files/sales report.pdf", startDate, endDate);
Console.WriteLine("Sales report generated successfully.");
break;
case "xml export":
Console.Write("Input the start date: ");
startDate = DateTime.Parse(Console.ReadLine());
Console.Write("Input the end date: ");
endDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Generating XML Report");
XMLExporter.ExportToXML(startDate, endDate);
Console.WriteLine("Report generated successfully");
break;
case "xml import":
Console.WriteLine("Importing Expenses Data from XML.");
XMLImporter.ImportExpensesByMonth(sqlManager.SqlServerContext, "../../Output-Files/Sample-Vendor-Expenses.xml");
Console.WriteLine("Data imported successfully.");
break;
case "json export":
Console.Write("Input the start date: ");
startDate = DateTime.Parse(Console.ReadLine());
Console.Write("Input the end date: ");
endDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Generating sales report to JSON");
JsonExporter.ExportSalesReportsToJson(sqlManager.SqlServerContext, startDate, endDate);
Console.WriteLine("Sales report generated successfully.");
break;
case "mongodb import":
Console.WriteLine("Importing data to MongoDB");
MongoImporter.ImportSalesReportsIntoDatabase();
Console.WriteLine("Data imported successfully");
break;
case "mysql import":
Console.WriteLine("Exporting data from MS SQL to MySQL");
SeedDataToMySql();
Console.WriteLine("Data exported successfully.");
break;
case "excel export":
Console.WriteLine("Exporting financial result report to excel.");
ExportToExcel();
Console.WriteLine("financial result exported successfully.");
break;
case "help":
PrintHelp();
break;
default:
Console.WriteLine("Invalid command");
break;
}
Console.Write("> ");
command = Console.ReadLine();
}
}
