public void NewVocab() { if (SelectedNote != null) { Vocab vocab = new Vocab() { PageId = SelectedPage.Id, Word = "New Word", Name = "New Word", Pronounciation = "Pronounciation", Explaination = "Description.", Version = 0 }; DatabaseHelper.Insert(vocab); } Vocabs.Clear(); ReadVocabs(); }
public void ReadVocabs() { List <Vocab> vocabs; if (SelectedPage != null) { using (SQLiteConnection connection = new SQLiteConnection(DatabaseHelper.dbFile)) { connection.CreateTable <Vocab>(); vocabs = connection.Table <Vocab>().ToList <Vocab>().Where(v => v.PageId == SelectedPage.Id).ToList(); } Vocabs.Clear(); foreach (var vocab in vocabs) { Vocabs.Add(vocab); } } else { Vocabs.Clear(); } }