public ActionResult GetExercisesByID([FromBody] ModelDummy data) { int workoutID = data.workoutID; TrainingProgram program = _context.Workouts.FirstOrDefault(W => W.id == workoutID && W.uid == _userManager.GetUserId(User)); var exer = _context.PExercises.FromSql("SELECT * FROM PExercises").ToList(); // Need to do this to access the data ??? var sets = _context.ESets.FromSql("SELECT * FROM ESets").ToList(); // Need to do this to access the data ??? List <Exercise> exercisesFromAPI = getExercisesFromAPIWithCustom(); List <ProgramExercises> filtered = new List <ProgramExercises>(); if (!(program is null)) { foreach (var ex in program.Exercices) { if (!filtered.Any(x => x.ExerciseID == ex.ExerciseID)) { filtered.Add(ex); foreach (var real_ex in exercisesFromAPI) { if (ex.ExerciseID == real_ex.id) { ex.Name = real_ex.name; } } } } } SelectList list = new SelectList(filtered, "ExerciseID", "Name", 0); return(Json(JsonConvert.SerializeObject(list))); }
/// <summary> /// Initialisierungsmethode für das Model. /// </summary> protected override void ModelInitialize() { //Es gibt im Moment kein Model im CreditsState - TB Model = new ModelDummy(); }
public IActionResult GraphData([FromBody] ModelDummy data) { TrainingProgram program = _context.Workouts.FirstOrDefault(W => W.id == data.workoutID && W.uid == _userManager.GetUserId(User)); var exer = _context.PExercises.FromSql("SELECT * FROM PExercises").ToList(); // Need to do this to access the data ??? var sets = _context.ESets.FromSql("SELECT * FROM ESets").ToList(); // Need to do this to access the data ??? List <Exercise> exercisesFromAPI = getExercisesFromAPI(); int exerciseID = data.ExerciseID; program.Exercices.Sort((x, y) => x.day.CompareTo(y.day)); int max = 0; int graphMax = 0; int choice = 1; GraphDataJson result = new GraphDataJson(); foreach (ProgramExercises ex in program.Exercices) { if (ex.ExerciseID == exerciseID) { switch (choice) { case 0: foreach (ExerciseSets set in ex.SetInfo) { if (set.amount > max) { max = set.amount; } if (max > graphMax) { graphMax = max; } } result.Label.Add("Day " + ex.day); result.Values.Add(max.ToString()); max = 0; break; case 1: foreach (ExerciseSets set in ex.SetInfo) { if (set.weight > max) { max = set.weight; } if (max > graphMax) { graphMax = max; } } result.Label.Add("Day " + ex.day); result.Values.Add(max.ToString()); max = 0; break; } } } //foreach (var ex in workouts[0].Exercices) //{ // foreach (var real_ex in exercisesFromAPI) // { // if (ex.ExerciseID == real_ex.id && (exerciseNames.GetValueOrDefault(ex.ExerciseID) == null)) // { // exerciseNames.Add(ex.ExerciseID, real_ex.name); // pro.ActualExercisesCount++; // } // } //} result.GraphMax = graphMax * 2; result.WorkoutName = program.name; result.ExerciseName = getExerciseName(exerciseID); return(Json(JsonConvert.SerializeObject(result))); }