public Kanji GetKanjiFromDatabase(int kanjiId) { using (KanjiDataContext context = new KanjiDataContext(connectionString)) { var data = from k in context.Kanji where k.Id == kanjiId select k; if (data.Count() == 0) return null; return data.First(); } }
public void LoadFromDatabase(List<string> kanjiList) { kanjiDictionary = new Dictionary<string, Kanji>(); using (KanjiDataContext context = new KanjiDataContext(connectionString)) { var data = from k in context.Kanji where kanjiList.Contains(k.Literal) select k; kanjiList.ForEach(k => kanjiDictionary.Add(k, data.First(d => d.Literal == k))); if (App.AppSettings.IsRandomReviewList) GenerateRandomSequence(); else GenerateSequence(); } }
public void LoadFromDatabase(JLPT jlptLevels) { kanjiDictionary = new Dictionary<string, Kanji>(); using (KanjiDataContext context = new KanjiDataContext(connectionString)) { var data = from k in context.Kanji where k.JLPTLevel == (jlptLevels & k.JLPTLevel) select k; data.ToList().ForEach(k => kanjiDictionary.Add(k.Literal, k)); if (App.AppSettings.IsRandomFlashcards) GenerateRandomSequence(); else GenerateSequence(); } }
public void CopyData() { using (KanjiDataContext context = new KanjiDataContext(connectionString)) { if (context.DatabaseExists()) context.DeleteDatabase(); context.CreateDatabase(); using (var odb = ODBFactory.Open(baseFilePath)) { var data = odb.GetObjects<KanjiData>(); foreach (var kanji in data) { context.Kanji.InsertOnSubmit(new Kanji() { Id = kanji.Id, JLPTLevel = kanji.JLPTLevel, KunYomi = kanji.KunYomi, Literal = kanji.Literal, Meaning = kanji.Meaning, OnYomi = kanji.OnYomi, StrokeCount = kanji.StrokeCount }); } context.SubmitChanges(); } } }
public Kanji GetKanjiFromDatabase(string literal) { using (KanjiDataContext context = new KanjiDataContext(connectionString)) { var data = from k in context.Kanji where k.Literal == literal select k; if (data.Count() == 0) return null; return data.First(); } }