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);
}
public async Task Handle_SelectedIndexChanged(object sender, System.EventArgs e)
{
var pickerListString = ExercisePicker.Items[ExercisePicker.SelectedIndex];
var exerciseId = await ExerciseName.GetAllExerciseNameRecordsByExerciseNameString(_connection, pickerListString);
if (exerciseId.Count != 1)
{
ExerciseHistoryLabel.Text = "No workout history available.";
}
else
{
DateTime thirtyDaysAgo = DateTime.Now.AddDays(-30);
int exerciseIdForCount = exerciseId[0].Id;
var exerciseListForId = await Exercise.GetAllExerciseRecordsByExerciseNameIdBeforeDate(_connection, exerciseIdForCount, thirtyDaysAgo);
if (exerciseListForId.Count < 1)
{
ExerciseHistoryLabel.Text = "No workout history available for this exercise.";
return;
}
var listOfSets = new List <Set>();
foreach (var item in exerciseListForId)
{
var sets = await Set.GetAllSetsByExerciseId(_connection, item.Id);
foreach (var s in sets)
{
listOfSets.Add(s);
}
}
//Number of sets in the last 30 days
int totalSets = listOfSets.Count; //works
int averageWeight = 0;
int reps = 0;
foreach (var weight in listOfSets)
{
averageWeight = averageWeight + (Decimal.ToInt32(weight.Weight) * weight.Reps);
reps = reps + weight.Reps;
}
//Average weight of each rep
decimal averageWeightOfEachRep = averageWeight / reps;
List <Set> orderedListOfSets = listOfSets.OrderByDescending(o => o.Weight).ToList();
//Highest weight lifted
decimal topLift = orderedListOfSets[0].Weight;
//For How many reps
int topReps = orderedListOfSets[0].Reps;
ExerciseHistoryLabel.Text = "Total sets in the last 30 days: " + totalSets + "\nLifetime average weight per rep: " + averageWeightOfEachRep + "kg \nHeaviest weight ever lifted: " + topLift + "kg for " + topReps + " reps";
}
}