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