public int WriteWorkout(WorkoutItem w) { /*return the ID of the workout after it's been added*/ /*Write the WorkoutItem (which is in our ViewModel) to the WorkoutItemDB and SetDB models*/ WorkoutItemDB wi = new WorkoutItemDB { Name = w.Name, Date = w.Date.ToString("yyyy-MM-dd"), Unit = w.Unit }; int t = _connection.Insert(wi); System.Diagnostics.Debug.WriteLine("LINES WRITTEN: " + t); string sql = @"select last_insert_rowid()"; int key = _connection.ExecuteScalar <int>(sql); foreach (double d in w.Set) { SetDB s = new SetDB { WorkoutItemID = key, Amount = d }; t = _connection.Insert(s); System.Diagnostics.Debug.WriteLine("LINES WRITTEN: " + t); } return(key); }
public void RemoveWorkout(WorkoutItem w) { // delete the workout WorkoutItemDB wi = new WorkoutItemDB { ID = w.ID }; _connection.Delete(wi); // delete the sets that belong to that ID _connection.Execute("DELETE FROM [SetDB] WHERE [WorkoutItemID] = ?", w.ID); }