public static void Menu()
{
const string Menu = "\nMenu:\n" +
"1. Replicate data from Oracle Database into MsSql Database\n" +
"2. Load Zip Excel Reports to MsSql Database\n" +
"3. Generate Pdf Sales report\n" +
"4. Generate XML Sales by Vendor from given date range\n" +
"5. Generate JSON reports in given date range and load them into MongoDB\n" +
"6. Load Xml Vendors Expenses Report into MsSql Database\n" +
"7. Load data from MsSql to MySql\n" +
"8. Generate financial report\n" +
"9. Exit\n";
try
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
var isFinished = false;
while (!isFinished)
{
Console.WriteLine(Menu);
var menuChoise = int.Parse(Console.ReadLine());
var context = new SupermarketContext();
switch (menuChoise)
{
case 1: OracleReplicationEngine.ReplicateOracleToMssql();
break;
case 2:
var importExelFiles = new ImportExel();
importExelFiles.LoadExelReports(context);
break;
case 3:
PDFReportGenerator.GeneratePDFReport();
break;
case 4:
XMLGenerator.GenerateXMLReport();
break;
case 5:
ImportJSONtoMongoDB.GenerateJSONReports();
break;
case 6:
Console.WriteLine(@" Importing XML To MsSqlDB
------------------------------------------------");
Console.WriteLine("Extracting data...");
var xmlManager = new ImportFromXML(@"..\..\..\..\Import\Sample-Vendor-Expenses.xml", context);
Console.WriteLine("Sending data...");
xmlManager.TransferData();
Console.WriteLine("Sales report imported.");
break;
case 7: MsSqlReplicationEngine.ReplicateMssqlToMySql();
break;
//case 8: Engine.GenerateFinancialReport();
break;
case 9: isFinished = true;
break;
default: throw new InvalidOperationException("Invalid operation.");
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void Menu()
{
const string Menu = "\n Main Menu:\n" +
" ----------------\n\n" +
" Select one: \n\n" +
" 1. Replicate data from Oracle Database into MsSql Database\n" +
" 2. Load Zip Excel Reports to MsSql Database\n" +
" 3. Generate Pdf Sales report\n" +
" 4. Generate XML Sales by Vendor report\n" +
" 5. Generate JSON reports in given date range and load them into MongoDB\n" +
" 6. Load Xml Vendors Expenses Report into MsSql Database\n" +
" 7. Load data from MsSql to MySql\n" +
" 8. Generate financial report\n" +
" 9. Exit\n";
const string Logo = @"
___________ _____ .__ ___________
\__ ___/___ _____ _____ / \ |__| ____ ____ \_ _____/__________ ____
| |_/ __ \\__ \ / \ / \ / \| |/ \ / ___\ | __)/ __ \_ __ \/ \
| |\ ___/ / __ \| Y Y \ / Y \ | | \/ /_/ > | \\ ___/| | \/ | \
|____| \___ >____ /__|_| / \____|__ /__|___| /\___ / \___ / \___ >__| |___| /
\/ \/ \/ \/ \//_____/ \/ \/ \/
";
try
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
var isFinished = false;
Console.WriteLine(Logo);
while (!isFinished)
{
Console.WriteLine(Menu);
var menuChoise = int.Parse(Console.ReadLine());
var context = new SupermarketContext();
switch (menuChoise)
{
case 1:
OracleReplicationEngine.ReplicateOracleToMssql();
break;
case 2:
var importExelFiles = new ImportExel();
importExelFiles.LoadExelReports(context);
break;
case 3:
PDFReportGenerator.GeneratePDFReport();
break;
case 4:
XMLGenerator.GenerateXMLReport();
break;
case 5:
ImportJSONtoMongoDB.GenerateJsonReports();
break;
case 6:
var xmlManager = new ImportFromXML(@"..\..\..\..\Import\Sample-Vendor-Expenses.xml", context);
xmlManager.TransferData();
break;
case 7:
MsSqlReplicationEngine.ReplicateMssqlToMySql();
break;
case 8:
var data = SqLiteFactory.GetFinancialReportData();
FinancialReportGenerator.GenerateFinancialReport(data, @"..\..\..\..\Reports\");
break;
case 9:
isFinished = true;
Console.WriteLine("\n\nSo Long!!!\n\n");
break;
default:
throw new InvalidOperationException("Invalid operation.");
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}