public static void ManageApp()
{
// DB Connection string
SQLiteConnection sc = Database_SQLite.CreateConnection();
// Select all Movie data from table Movie for display
Console.WriteLine(Database_SQLite.Select_MovieData(sc) + "\r\n");
while (true)
{
// Determine what user wants to do; insert, update, delete
GetUserCommand(sc);
}
}
private static char GetUserCommand(SQLiteConnection sc)
{
getInfo:
Console.Write("Enter: 'i' for insert, 'u' for update, 'd' for delete, 's' for select, or 9 for exit 'Required' " + "\r\n");
bool t = false;
t = char.TryParse(Console.ReadLine(), out char c);
if (t == true && c == '9')
{
Environment.Exit(0);
}
if (t == true && (c == 'i' || c == 'u' || c == 'd' || c == 's'))
{
}
else
{
goto getInfo;
}
switch (c)
{
case 'i':
Insert(sc);
break;
case 'u':
Update(sc);
break;
case 'd':
Delete(sc);
break;
case 's':
Console.WriteLine(Database_SQLite.Select_MovieData(sc));
break;
default:
Environment.Exit(0);
break;
}
return('0');
}
