//Insert new definition into the Definition table public static void Insert(HindiTranslation newTranslation) { using (SQLiteConnection conn = new SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), DB_PATH)) { conn.RunInTransaction(() => { conn.Insert(newTranslation); }); } }
//Update existing definition in the database public static void UpdateTranslation(HindiTranslation translation) { using (SQLiteConnection conn = new SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), DB_PATH)) { var existingEntry = conn.Query<HindiTranslation>("SELECT * FROM HindiTranslation WHERE ID =" + translation.ID).FirstOrDefault(); if (existingEntry != null) { conn.RunInTransaction(() => { conn.Update(translation); }); } } }
public void AddNewTranslation(string newTerm, string newUserTranslation) { if (!String.IsNullOrWhiteSpace(newTerm)) { if (String.IsNullOrWhiteSpace(newUserTranslation)) { newUserTranslation = ""; } HindiTranslation newTranslation = new HindiTranslation(newTerm, newUserTranslation); Dictionary.Add(newTranslation); DBHelper.Insert(newTranslation); CurrentTranslation = newTranslation; IsCurrentTranslationSelected = true; } }