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