public async Task AddExerciseToInternalDb(string pickerListString) { var exerciseId = await ExerciseName.GetAllExerciseNameRecordsByExerciseNameString(_connection, pickerListString); if (exerciseId.Count > 1) { return; } int exerciseIdForInsert = exerciseId[0].Id; DateTime now = DateTime.Now; var exercise = new Models.Persistence.Exercise { DateOfExercise = now, WorkoutId = WorkoutId, ExerciseNameId = exerciseIdForInsert }; await _connection.InsertAsync(exercise); var exerciseCheck = await Exercise.GetAllExerciseRecordsByDate(_connection, now); WorkoutList workout = new WorkoutList() { Id = WorkoutId }; await Navigation.PushAsync(new Views.Workout.ViewExercisesPage(workout)); Navigation.RemovePage(this); }
public async Task UpdateExercise(string pickerListString, DateTime date) { var exerciseId = await ExerciseName.GetAllExerciseNameRecordsByExerciseNameString(_connection, pickerListString); if (exerciseId.Count > 1) { return; } int exerciseIdForInsert = exerciseId[0].Id; var exercise = new Models.Persistence.Exercise { Id = ExerciseId, DateOfExercise = date, WorkoutId = WorkoutId, ExerciseNameId = exerciseIdForInsert }; await _connection.UpdateAsync(exercise); WorkoutList workout = new WorkoutList() { Id = WorkoutId }; await Navigation.PushAsync(new Views.Workout.ViewExercisesPage(workout)); Navigation.RemovePage(this); }
private static async Task <DateTime> CreateExerciseRecordForWorkout(SQLiteAsyncConnection _connection, string exercise, Persistence.Workout workout) { string exerciseString = GetExerciseNameString(exercise); var exerciseId = await Models.Persistence.ExerciseName.GetAllExerciseNameRecordsByExerciseNameString(_connection, exerciseString); int exerciseIdForInsert = exerciseId[0].Id; DateTime now = DateTime.Now; var newExercise = new Models.Persistence.Exercise { DateOfExercise = now, WorkoutId = workout.Id, ExerciseNameId = exerciseIdForInsert }; await _connection.InsertAsync(newExercise); return(now); }