public void SaveStaticGestureClass(SGClassWrapper gestureWrapper)
{
string sql;
string gestureJson = JsonConvert.SerializeObject(gestureWrapper.Gesture);
string sampleInstanceJson = JsonConvert.SerializeObject(gestureWrapper.SampleInstance);
sql = String.Format("UPDATE StaticGestureClasses SET name='{0}', gesture_json='{1}', sample_instance_json='{2}' WHERE id='{3}'", gestureWrapper.Name, gestureJson, sampleInstanceJson, gestureWrapper.Id);
executeNonQuery(sql);
}
public ObservableCollection <SGClassWrapper> GetAllStaticGestureClasses()
{
var gestures = new ObservableCollection <SGClassWrapper>();
string sql = "SELECT id, name, gesture_json, sample_instance_json FROM StaticGestureClasses";
using (var connection = new SQLiteConnection(_connString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
//gestures.Add(new StaticGestureClassWrapper()
//{
// Id = reader.GetInt32(0),
// Name = reader.GetString(1),
// Gesture = JsonConvert.DeserializeObject<StaticGestureClass>(reader.GetString(2)),
// SampleInstance = JsonConvert.DeserializeObject<StaticGestureInstance>(reader.GetString(3))
//});
var currGest = new SGClassWrapper()
{
Id = reader.GetInt32(0),
Name = reader.GetString(1),
Gesture = JsonConvert.DeserializeObject <SGClass>(reader.GetString(2)),
SampleInstance = JsonConvert.DeserializeObject <SGInstance>(reader.GetString(3))
};
gestures.Add(currGest);
}
}
}
}
return(gestures);
}
