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)); } }