public void SaveCompletedQuery(string queryType, string completedQuery)
{
newQuerySaverInputOutput.WriteStringOuput($"The completed query is: {completedQuery}");
File.WriteAllText($"C:\\temp\\{queryType}.{DateTime.Now.ToString("MMddyyyy.HHmmss")}.sql", completedQuery);
newQuerySaverInputOutput.WriteStringOuput("The query has been saved successfully. Please press any key to close this window");
Console.ReadKey();
return;
}
static void Main(string[] args)
{
var programInputOutput = new InputOutput();
programInputOutput.WriteStringOuput("What type of SQL statement would you like to create? Press D for delete, press I for insert, press S for select, or press U for update:");
while (true)
{
var userQueryTypeInput = programInputOutput.ReadKeyInput();
if (userQueryTypeInput.Key == ConsoleKey.D)
{
Console.WriteLine();
var newDeleteQuery = new QueryDeleter();
newDeleteQuery.BuildDeleteQuery();
break;
}
if (userQueryTypeInput.Key == ConsoleKey.I)
{
Console.WriteLine();
var newInsertQuery = new QueryInserter();
newInsertQuery.BuildInsertQuery();
break;
}
if (userQueryTypeInput.Key == ConsoleKey.S)
{
Console.WriteLine();
var newSelectQuery = new QuerySelector();
newSelectQuery.BuildSelectQuery();
break;
}
if (userQueryTypeInput.Key == ConsoleKey.U)
{
Console.WriteLine();
var newUpdateQuery = new QueryUpdater();
newUpdateQuery.BuildUpdateQuery();
break;
}
else
{
Console.WriteLine();
programInputOutput.WriteStringOuput("Please make a valid selection");
}
}
}
protected void SetQueryTable()
{
while (true)
{
newQueryInputOutput.WriteStringOuput("What table would you like to use:");
var userTableInput = newQueryInputOutput.ReadStringInput();
if (String.IsNullOrWhiteSpace(userTableInput))
{
newQueryInputOutput.WriteStringOuput("!!YOU MUST ENTER THE NAME OF A TABLE!!");
}
else if (userTableInput.Contains(" "))
{
newQueryInputOutput.WriteStringOuput("!!YOU MUST ENTER A SINGLE TABLE NAME (NO SPACES)!!");
}
else
{
_queryTable = userTableInput;
return;
}
}
}
