void HandleCreateDbButtonClicked(object sender, EventArgs e)
{
string file = newDbButton.Filename;
if (string.IsNullOrEmpty(file))
{
dbLoadLabel.Text = "richtigen Pfad angeben";
this.ShowAll();
return;
}
try {
QuizParser qp = new QuizParser(file);
using (var connection = new HyenaSqliteConnection(QuestionProvider.dbPath)) {
var provider = new QuestionProvider(connection);
var questions = qp.Questions.ToList();
foreach (var quest in questions)
{
provider.Save(quest);
}
}
dbLoadLabel.Text = "erstellen erfolgreich";
this.ShowAll();
} catch (Exception exc) {
dbLoadLabel.Text = exc.Message;
this.ShowAll();
}
dbInfoLabel.Text = string.Format("Exestiert die Datenbank: {0}", System.IO.File.Exists(QuestionProvider.dbPath));
}
void ButtonAddClicked(object sender, EventArgs e)
{
using (var connection = new HyenaSqliteConnection(QuestionProvider.dbPath)) {
var provider = new QuestionProvider(connection);
Question question = new Question("Frage", "Antwort", "Nothing", 0, 0);
provider.Save(question);
qnv.QuestionNodeView.NodeStore.AddNode(new QuestionNode(question));
}
}
