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;
}
}
