private void MenuItem_OpenFolder_Click(object sender, RoutedEventArgs e) { FolderBrowserDialog dialog = new FolderBrowserDialog(); dialog.RootFolder = Environment.SpecialFolder.MyComputer; dialog.SelectedPath = @"D:\Kinect data\new"; DialogResult result = dialog.ShowDialog(); if (result == System.Windows.Forms.DialogResult.OK) { string folderName = dialog.SelectedPath; //string dbPath = @"D:\Kinect data\database_empty.db"; //m_DBmanager = DBManager.GetSingleton(dbPath); DirectoryInfo folder = new DirectoryInfo(folderName); wordList = new List <SignWordModel>(); foreach (var dir in folder.GetDirectories()) { string fileName = dir.Name; string[] s = fileName.Split(); if (s.Length > 1) { SignWordModel wordModel = new SignWordModel(s[0], s[1], dir.FullName, fileName); wordList.Add(wordModel); } } Console.WriteLine(wordList.Count() + " words to process"); } }
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; } }
public void AddWordModel(SignWordModel wordModel, int index) { try { SQLiteCommand insertCommand = new SQLiteCommand(connection); string insertWord = @"INSERT OR REPLACE INTO SignWord (SignID,SignIndex,Chinese,English,Count) VALUES" + "(@ID,@Index, @Chinese, @English,0)"; insertCommand = new SQLiteCommand(insertWord, connection); insertCommand.Parameters.AddWithValue("@ID", wordModel.SignID); insertCommand.Parameters.AddWithValue("@Index", index); insertCommand.Parameters.AddWithValue("@Chinese", wordModel.Chinese); insertCommand.Parameters.AddWithValue("@English", wordModel.English); insertCommand.ExecuteNonQuery(); } catch (Exception e) { tran.Rollback(); throw; } }
private void MenuItem_OpenFolder_Click(object sender, RoutedEventArgs e) { FolderBrowserDialog dialog = new FolderBrowserDialog(); dialog.RootFolder = Environment.SpecialFolder.MyComputer; dialog.SelectedPath = @"D:\Kinect data\new"; DialogResult result = dialog.ShowDialog(); if (result == System.Windows.Forms.DialogResult.OK) { string folderName = dialog.SelectedPath; //string dbPath = @"D:\Kinect data\database_empty.db"; //m_DBmanager = DBManager.GetSingleton(dbPath); DirectoryInfo folder = new DirectoryInfo(folderName); wordList = new List<SignWordModel>(); foreach (var dir in folder.GetDirectories()) { string fileName = dir.Name; string[] s = fileName.Split(); if (s.Length >1) { SignWordModel wordModel = new SignWordModel(s[0], s[1], dir.FullName, fileName); wordList.Add(wordModel); } } Console.WriteLine(wordList.Count() + " words to process"); } }
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; } }
public void AddWordModel(SignWordModel wordModel, int index) { try { SQLiteCommand insertCommand = new SQLiteCommand(connection); string insertWord = @"INSERT OR REPLACE INTO SignWord (SignID,SignIndex,Chinese,English,Count) VALUES" + "(@ID,@Index, @Chinese, @English,0)"; insertCommand = new SQLiteCommand(insertWord, connection); insertCommand.Parameters.AddWithValue("@ID", wordModel.SignID); insertCommand.Parameters.AddWithValue("@Index", index); insertCommand.Parameters.AddWithValue("@Chinese", wordModel.Chinese); insertCommand.Parameters.AddWithValue("@English", wordModel.English); insertCommand.ExecuteNonQuery(); } catch (Exception e) { tran.Rollback(); throw; } }