static void Main(string[] args)
{
char scelta = ' ';
bool constraints = false;
do
{
Console.WriteLine("*** FORMULA ONE - BATCH OPERATIONS ***");
Console.WriteLine("1 - Create Countries");
Console.WriteLine("2 - Create Teams");
Console.WriteLine("3 - Create Drivers");
Console.WriteLine("4 - Create Circuits");
Console.WriteLine("5 - Create Races");
Console.WriteLine("6 - Create Results");
Console.WriteLine("7 - Create Constraints");
Console.WriteLine("8 - Delete Constraints");
Console.WriteLine("9 - Create Stats");
Console.WriteLine("------------------");
Console.WriteLine("R - RESET DB");
Console.WriteLine("B - Backup all DB");
Console.WriteLine("T - Restore DB");
Console.WriteLine("C - CLEAR DB");
Console.WriteLine("------------------");
Console.WriteLine("X - EXIT\n");
scelta = Console.ReadKey(true).KeyChar;
switch (scelta)
{
case '1':
callExecuteSqlScript("Countries");
break;
case '2':
callExecuteSqlScript("Teams");
break;
case '3':
callExecuteSqlScript("Drivers");
break;
case '4':
callExecuteSqlScript("Circuits");
break;
case '5':
callExecuteSqlScript("Races");
break;
case '6':
callExecuteSqlScript("Results");
break;
case '7':
if (!constraints)
{
constraints = true;
callExecuteSqlScript("setConstraints");
}
else
{
Console.WriteLine("\nConstraints are already set\n");
}
break;
case '8':
if (constraints)
{
constraints = false;
callExecuteSqlScript("deleteConstraints");
}
else
{
Console.WriteLine("\nThere aren't constraints set\n");
}
break;
case '9':
Console.Write("\nInserisci driver id: ");
int id = Convert.ToInt32(Console.ReadLine());
dbt.callStoredProcedure(id);
break;
case 'B':
case 'b':
dbt.Backup();
break;
case 'T':
case 't':
dbt.Restore();
break;
case 'R':
case 'r':
bool OK;
OK = callExecuteSqlScript("deleteConstraints");
constraints = false;
if (OK)
{
OK = callDropTable("Countries");
}
if (OK)
{
OK = callDropTable("Team");
}
if (OK)
{
OK = callDropTable("Driver");
}
if (OK)
{
OK = callDropTable("Circuit");
}
if (OK)
{
OK = callDropTable("Race");
}
if (OK)
{
OK = callDropTable("Result");
}
if (OK)
{
OK = callExecuteSqlScript("Countries");
}
if (OK)
{
OK = callExecuteSqlScript("Teams");
}
if (OK)
{
OK = callExecuteSqlScript("Drivers");
}
if (OK)
{
OK = callExecuteSqlScript("Circuits");
}
if (OK)
{
OK = callExecuteSqlScript("Races");
}
if (OK)
{
OK = callExecuteSqlScript("Results");
}
if (OK)
{
OK = callExecuteSqlScript("setConstraints");
constraints = true;
}
if (OK)
{
Console.WriteLine("RESET DB OK");
}
break;
case 'C':
case 'c':
dbt.Backup();
bool cl;
cl = callExecuteSqlScript("deleteConstraints");
constraints = false;
if (cl)
{
cl = callDropTable("Countries");
}
if (cl)
{
cl = callDropTable("Team");
}
if (cl)
{
cl = callDropTable("Driver");
}
if (cl)
{
cl = callDropTable("Circuit");
}
if (cl)
{
cl = callDropTable("Race");
}
if (cl)
{
cl = callDropTable("Result");
}
if (cl)
{
Console.WriteLine("CLEAR DB OK\n");
}
break;
case 'X': break;
default:
if (scelta != 'X' && scelta != 'x')
{
Console.WriteLine("\nUncorrect Choice - Try Again\n");
}
break;
}
} while (scelta != 'X' && scelta != 'x');
}