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