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