internal static QuizModel SelectLatestQuiz()
{
using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
{
string SQLite = "SELECT * FROM Quizes WHERE Id=(SELECT MAX(Id) FROM Quizes)";
QuizModel output = conn.Query <QuizModel>(SQLite, new DynamicParameters()).First();
return(output);
}
}
public static int InsertQuiz(QuizModel quiz)
{
try
{
using (IDbConnection conn = new SQLiteConnection(LoadConnectionString()))
{
conn.Execute("INSERT INTO QUIZES(Name) VALUES (@Name)", quiz);
}
}
catch (Exception)
{
return(-1);
}
return(quiz.Id);
}
private void FullQuiz(object obj)
{
AddNewQuiz(null);
int exitCode;
do
{
AskOneQuestionAndItsAnswersAtTheTime();
Menu.Menu yesNoMenu = new YesNoMenu();
exitCode = yesNoMenu.Start();
} while (exitCode != 0);
QuizModel latestQuiz = SQLiteDataAccess.SelectLatestQuiz();
List <QuestionModel> questionsCount = SQLiteDataAccess.SelectQuestionsByQuizesId(latestQuiz.Id);
Console.WriteLine($"{questionsCount.Count} x Questions Have Been Added To Quiz: {latestQuiz.Name}");
Console.ReadKey();
}
private void DeleteQuizesById(object obj)
{
QuizModel deletedQuiz = SQLiteDataAccess.SelectQuizById((int)obj);
try
{
SQLiteDataAccess.DeleteQuizById((int)obj);
Console.WriteLine("Poprawnie usunieto z bazy pytan pytanie: \n");
Console.WriteLine(deletedQuiz);
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Nie udalo sie usunac pytania.");
Console.ResetColor();
}
Console.ReadKey(true);
}