CURELab.SignLanguage.HandDetector.DBManager.AddWordSample C# (CSharp) Méthode

        public void AddWordSample(SignWordModel wordModel)
        {
            try
            {
                SQLiteCommand insertCommand = new SQLiteCommand(connection);

                string insertSample =
                   @"INSERT INTO SignSample (SignID, Signer,FileName,Intersected) VALUES
                                    (@SignID, @Signer ,@File,0)";
                insertCommand = new SQLiteCommand(insertSample, connection);
                insertCommand.Parameters.AddWithValue("@SignID", wordModel.SignID);
                insertCommand.Parameters.AddWithValue("@Signer", wordModel.Signer);
                insertCommand.Parameters.AddWithValue("@File", wordModel.File);
                insertCommand.ExecuteNonQuery();
                string sql = @"select last_insert_rowid()";
                insertCommand.CommandText = sql;
                long lastId = (long)insertCommand.ExecuteScalar();
                CurrentSign = lastId;
                currentFrame = 0;

                // update count
                string update = @"UPDATE SignWord
                set count = count +1
                where signID = @ID ";
                SQLiteCommand updateCommand = new SQLiteCommand(update, connection);
                updateCommand.Parameters.AddWithValue("@ID", wordModel.SignID);
                //Console.WriteLine(updateCommand.CommandText);
                updateCommand.ExecuteNonQuery();

            }
            catch (Exception e)
            {
                tran.Rollback();
                throw;
            }
        }