Exemplo n.º 1
0
        public bool UpdateWordInDb(GrammarWord grammarWord)
        {
            bool result = true;

            using (SQLiteCommand sQLiteCommand = connection.CreateCommand())
            {
                try
                {
                    sQLiteCommand.CommandText = "UPDATE GrammarWords SET Name=@name, PRONUNCIATION_COUNTER=@pronunciationCounter WHERE Id=@id";
                    sQLiteCommand.Parameters.AddWithValue("@id", grammarWord.Id);
                    sQLiteCommand.Parameters.AddWithValue("@name", grammarWord.Name);
                    sQLiteCommand.Parameters.AddWithValue("@pronunciationCounter", grammarWord.Counter);
                    sQLiteCommand.ExecuteNonQuery();
                }
                catch (SQLiteException ex)
                {
                    result = false;
                    MessageBox.Show(ex.Message);
                }
            }
            return(result);
        }
Exemplo n.º 2
0
        public bool InsertWordToDb(GrammarWord grammarWord)
        {
            bool result = true;

            using (SQLiteCommand sQLiteCommand = connection.CreateCommand())
            {
                try
                {
                    sQLiteCommand.CommandText = "INSERT INTO GrammarWords (Name, PRONUNCIATION_COUNTER) VALUES (@name,@pronunciationCounter)";
                    sQLiteCommand.Parameters.AddWithValue("@name", grammarWord.Name);
                    sQLiteCommand.Parameters.AddWithValue("@pronunciationCounter", grammarWord.Counter);
                    sQLiteCommand.ExecuteNonQuery();
                }
                catch (SQLiteException ex)
                {
                    result = false;
                    MessageBox.Show(ex.Message);
                }
            }

            return(result);
        }