/*
* to Merege single relations with Particular relations
* return type string Array List
* */
private static ArrayList MappingRelations(List <string> list)
{
MssqlReader newReader = new MssqlReader();
foreach (string table in list)
{
newList.Add(newReader.ReadRelations(table));
}
RelationsMapper newMapper = new RelationsMapper();
newList = newMapper.MergeJoins(newList);
return(newList);
}
/*
* Main Method and starting Point
* no return type
* */
static void Main(string[] args)
{
string ans = "";
//backward to Main menu
mainmenu:
Console.Clear();
start();
ans = MainMenu();
//main menu Control switch
switch (ans)
{
case "1":
Console.Clear();
start();
CheckConnections();
ContinueMessage();
goto mainmenu;
case "2":
//backward to Select database sub menu
selectdbtype:
Console.Clear();
start();
menuItems.Clear();
menuItems.AddRange(new string[] { "No Sql Database", "Sql Databse", "Main Menu" });
ans = DynamicMenu("Select Datbase Type", menuItems);
//select database type sub menu control switch
switch (ans)
{
case "1":
//backward to NO sql database sub menu
nosqldb:
Console.Clear();
menuItems.Clear();
start();
menuItems.AddRange(new string[] { "MongoDB", "Go Back", "Main Menu" });
ans = DynamicMenu("No Sql Databases", menuItems);
//select database type sub menu Control switch
switch (ans)
{
case "1":
//need to create things here
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("\n\tSorry!!! This is Free Version.Buy Pro Version To Get All features\n");
Console.ForegroundColor = ConsoleColor.DarkGreen;
ContinueMessage();
goto nosqldb;
case "2":
goto selectdbtype;
case "3":
goto mainmenu;
default:
WrongInputMessage();
goto nosqldb;
//End of select database type sub menu Control switch
}
case "2":
sqldatabase:
Console.Clear();
menuItems.Clear();
start();
menuItems.AddRange(new string[] { "PostgerDB", "MysqlDB", "MssqlDB", "Go Back", "Main Menu" });
ans = DynamicMenu("Sql Databases", menuItems);
//sql database sub menu Control switch
switch (ans)
{
case "1":
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("\n\tSorry!!! This is Free Version.Buy Pro Version To Get All features\n");
Console.ForegroundColor = ConsoleColor.DarkGreen; ContinueMessage();
goto sqldatabase;
case "2":
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("\n\tSorry!!! This is Free Version.Buy Pro Version To Get All features\n");
Console.ForegroundColor = ConsoleColor.DarkGreen; ContinueMessage();
goto sqldatabase;
case "3":
options:
Console.Clear();
menuItems.Clear();
start();
menuItems.AddRange(new string[] { "Read Table Data", "Read Relation Ships", "Go Back", "Main Menu" });
ans = DynamicMenu("Options", menuItems);
//sql database sub menu Control switch
switch (ans)
{
case "1":
MssqlReader msDBRead = new MssqlReader();
List <string> tables = msDBRead.GetTables();
PrintTables(tables);
Console.Write("\nEnter Your Request Here :");
string request = Console.ReadLine();
string tName = RequirementGather(request, tables);
if (tName != "")
{
Console.WriteLine("\nData of " + tName + " Table -->\n");
msDBRead.Read(tName);
Console.WriteLine("\n");
ContinueMessage();
}
else
{
WrongInputMessage();
}
goto options;
case "2":
MssqlReader msDBRead1 = new MssqlReader();
List <string> tables1 = msDBRead1.GetTables();
PrintTables(tables1);
//Enter
Console.Write("\nEnter Your Request Here :");
string request1 = Console.ReadLine();
string tName1 = RequirementGather(request1, tables1);
if (tName1 != "")
{
List <string> contentList = GetRelations(tables1, tName1);
Console.WriteLine("\nRalation Tables of " + tName1 + " -->\n");
if (contentList.Count == 1)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("\t" + tName1 + " Not related to any other Table !!!!\n");
Console.ForegroundColor = ConsoleColor.Green;
}
else
{
foreach (string table in contentList)
{
Console.Write("\t" + table + "\n");
}
}
}
else
{
WrongInputMessage();
goto options;
}
ContinueMessage();
goto options;
case "3":
goto sqldatabase;
case "4":
goto mainmenu;
default:
WrongInputMessage();
goto options;
}
case "4":
goto selectdbtype;
case "5":
goto mainmenu;
default:
WrongInputMessage();
goto sqldatabase;
}
case "3":
goto mainmenu;
default:
WrongInputMessage();
goto selectdbtype;
}
case "3":
Console.Clear();
start();
GetDBInformations();
ContinueMessage();
goto mainmenu;
case "4":
Environment.Exit(0);
break;
default:
WrongInputMessage();
goto mainmenu;
}
}
