protected override async void OnAppearing()
{
List <ExerciseList> ListOfExercises = new List <ExerciseList>();
var exercises = await Exercise.GetAllExercise(_connection);
var exercisesForWorkout = new List <Exercise>();
foreach (var e in exercises)
{
if (e.WorkoutId == WorkoutId)
{
exercisesForWorkout.Add(e);
}
}
//var exerciseGroup3 = await _connection.Table<ExerciseGroup>().ToListAsync();
//var exerciseGroupCount = exerciseGroup3.Count;
var exerciseName2 = await ExerciseName.GetAllExerciseNameRecords(_connection);
var exerciseNameCount = exerciseName2.Count;
int exerciseNumber = 1;
foreach (var e in exercisesForWorkout)
{
var exerciseName = await ExerciseName.GetAllExerciseNameRecordsById(_connection, e.ExerciseNameId);
var sets = await _connection.Table <Models.Persistence.Set>()
.Where(w => w.ExerciseId == e.Id).ToListAsync();
ExerciseList exerciseFromSqLite = new ExerciseList();
exerciseFromSqLite.Id = e.Id;
exerciseFromSqLite.WorkoutId = e.WorkoutId;
exerciseFromSqLite.Exercise = exerciseName[0].ExerciseNameString;
exerciseFromSqLite.MuscleGroup = exerciseName[0].ExerciseMuscleGroup;
exerciseFromSqLite.Sets = sets.Count.ToString();
exerciseFromSqLite.FrontEndExerciseString = exerciseNumber.ToString() + "- " + exerciseName[0].ExerciseNameString;
ListOfExercises.Add(exerciseFromSqLite);
exerciseNumber++;
}
ListViewExercises.ItemsSource = ListOfExercises;
}
protected override async void OnAppearing()
{
List <SetList> ListOfSets = new List <SetList>();
var sets = await _connection.Table <Models.Persistence.Set>().ToListAsync();
var setsForExercise = new List <Set>();
//Exercise Name for Navigation Bar
var exercises = await Exercise.GetAllExerciseRecordsById(_connection, ExerciseId);
int exerciseIdForName = exercises[0].ExerciseNameId;
var exerciseName = await ExerciseName.GetAllExerciseNameRecordsById(_connection, exerciseIdForName);
Title = exerciseName[0].ExerciseNameString;
//End
foreach (var s in sets)
{
if (s.ExerciseId == ExerciseId)
{
setsForExercise.Add(s);
}
}
foreach (var s in setsForExercise)
{
SetList newSetList = new SetList();
newSetList.ExerciseId = s.ExerciseId;
newSetList.Id = s.Id;
newSetList.TimeOfSet = s.TimeOfSet;
newSetList.Reps = s.Reps.ToString();
newSetList.Weight = s.Weight.ToString();
ListOfSets.Add(newSetList);
}
var sortedListOfSets = ListOfSets.OrderBy(sl => sl.TimeOfSet).ToList();
var setNumber = 1;
foreach (var s in sortedListOfSets)
{
s.SetNumber = setNumber.ToString();
setNumber++;
}
setList.ItemsSource = sortedListOfSets;
}
protected override async void OnAppearing()
{
var exercise = await Exercise.GetAllExerciseRecordsById(_connection, ExerciseId);
int currentExerciseId = exercise[0].ExerciseNameId;
var currentExerciseName = await ExerciseName.GetAllExerciseNameRecordsById(_connection, currentExerciseId);
ExercisePicker.SelectedItem = currentExerciseName[0].ExerciseNameString;
var exerciseNames = await ExerciseName.GetAllExerciseNameRecords(_connection);
var pickerList = new List <string>();
foreach (var exerciseName in exerciseNames)
{
pickerList.Add(exerciseName.ExerciseNameString);
}
DatePicker.Date = exercise[0].DateOfExercise;
ExercisePicker.ItemsSource = pickerList;
}
protected override async void OnAppearing()
{
//Exercise Label Text
var exercise = await Models.Persistence.Exercise.GetAllExerciseRecordsById(_connection, ExerciseId);
int currentExerciseId = exercise[0].ExerciseNameId;
var currentExerciseName = await ExerciseName.GetAllExerciseNameRecordsById(_connection, currentExerciseId);
Exercise.Text = currentExerciseName[0].ExerciseNameString.ToString();
//Current selections
var sets = await _connection.Table <Models.Persistence.Set>()
.Where(s => s.Id == SetId).ToListAsync();
//Populate pickers
List <int> reps = new List <int>();
List <decimal> weight = new List <decimal>();
int repStart = 0;
decimal weightStart = 0;
while (repStart < 100)
{
reps.Add(repStart);
repStart++;
}
while (weightStart < 500.00m)
{
weight.Add(weightStart);
weightStart = weightStart + 0.25m;
}
Reps.ItemsSource = reps;
Weight.ItemsSource = weight;
Reps.SelectedItem = sets[0].Reps;
Weight.SelectedItem = sets[0].Weight;
}