public ActionResult Details(int idTraining)
{
ViewBag.Units = TrainingBL.GetUnits();
var training = new Training();
var db = new DatabaseConnection(Server.MapPath("~"));
db.connection.Open();
ViewBag.Movements = TrainingBL.GetMovementTypes(db);
training.Header = TrainingBL.GetHeader(idTraining, db);
if (training.Header.IdUser == (int)Session["IdUser"])
{
training.Exercises = TrainingBL.GetExercices(idTraining, db);
}
//Prevents users from accessing other users trainings
else
{
return(RedirectToAction("Index", "Training"));
}
db.connection.Close();
if (!training.Exercises.Any())
{
training.Exercises.Add(new Exercise());
}
return(View(training));
}
// GET: Dashboard
public ActionResult Index()
{
if (User.Identity.IsAuthenticated && Session["IdUser"] != null)
{
var dashboard = new Dashboard();
var db = new DatabaseConnection(Server.MapPath("~"));
db.connection.Open();
var user = UserBL.GetUser((int)Session["IdUser"], db);
var meetResultList = MeetBL.GetResultsForUser((int)Session["IdUser"], db);
var trainingList = TrainingBL.GetTrainings((int)Session["IdUser"], db);
var goalList = GoalBL.GetGoals((int)Session["IdUser"], db);
dashboard.Name = user.Name;
var maxMeetSquat = 0.0f;
var maxMeetBench = 0.0f;
var maxMeetDeadlift = 0.0f;
var maxTrainingSquat = 0.0f;
var maxTrainingSquatUnit = "";
var maxTrainingBench = 0.0f;
var maxTrainingBenchUnit = "";
var maxTrainingDeadlift = 0.0f;
var maxTrainingDeadliftUnit = "";
var accomplishedGoals = new List <GoalProgress>();
var pendingGoals = new List <GoalProgress>();
foreach (var meetResult in meetResultList)
{
if (meetResult.Success)
{
if (meetResult.MovementType == 1 && meetResult.Weight > maxMeetSquat)
{
maxMeetSquat = meetResult.Weight;
}
if (meetResult.MovementType == 2 && meetResult.Weight > maxMeetBench)
{
maxMeetBench = meetResult.Weight;
}
if (meetResult.MovementType == 3 && meetResult.Weight > maxMeetDeadlift)
{
maxMeetDeadlift = meetResult.Weight;
}
}
}
foreach (var training in trainingList)
{
foreach (var exercise in TrainingBL.GetExercices(training.Id, db))
{
if (exercise.MovementType == 1 && exercise.Weight > maxTrainingSquat)
{
maxTrainingSquat = exercise.Weight;
maxTrainingSquatUnit = exercise.Unit;
}
if (exercise.MovementType == 2 && exercise.Weight > maxTrainingBench)
{
maxTrainingBench = exercise.Weight;
maxTrainingBenchUnit = exercise.Unit;
}
if (exercise.MovementType == 3 && exercise.Weight > maxTrainingDeadlift)
{
maxTrainingDeadlift = exercise.Weight;
maxTrainingDeadliftUnit = exercise.Unit;
}
}
}
dashboard.MaxCompetitionSquat = maxMeetSquat;
dashboard.MaxCompetitionSquatUnit = "kg";
dashboard.MaxCompetitionBench = maxMeetBench;
dashboard.MaxCompetitionBenchUnit = "kg";
dashboard.MaxCompetitionDeadlift = maxMeetDeadlift;
dashboard.MaxCompetitionDeadliftUnit = "kg";
dashboard.MaxTrainingSquat = maxTrainingSquat;
dashboard.MaxTrainingSquatUnit = maxTrainingSquatUnit;
dashboard.MaxTrainingBench = maxTrainingBench;
dashboard.MaxTrainingBenchUnit = maxTrainingBenchUnit;
dashboard.MaxTrainingDeadlift = maxTrainingDeadlift;
dashboard.MaxTrainingDeadliftUnit = maxTrainingDeadliftUnit;
dashboard.SquatProgression = TrainingBL.GetSquatProgression((int)Session["IdUser"], db);
dashboard.BenchProgression = TrainingBL.GetBenchProgression((int)Session["IdUser"], db);
dashboard.DeadliftProgression = TrainingBL.GetDeadliftProgression((int)Session["IdUser"], db);
foreach (var currentGoal in goalList)
{
var maxForRep = TrainingBL.GetMaxForReps(currentGoal.MovementType, currentGoal.Repetition, db);
String exerciseName = "";
if (currentGoal.MovementType == 1)
{
exerciseName = "Squat";
}
else if (currentGoal.MovementType == 2)
{
exerciseName = "Bench";
}
else if (currentGoal.MovementType == 3)
{
exerciseName = "Deadlift";
}
if (maxForRep != null)
{
float normalisedMax = maxForRep.Weight;
var date = TrainingBL.GetHeader(maxForRep.IdTraining, db).Date;
if (maxForRep.Unit == "lbs" && currentGoal.Unit == "kg")
{
normalisedMax = normalisedMax / 2.2f;
}
else if (maxForRep.Unit == "kg" && currentGoal.Unit == "lbs")
{
normalisedMax = normalisedMax * 2.2f;
}
if (normalisedMax >= currentGoal.Weight)
{
accomplishedGoals.Add(new GoalProgress
{
goal = currentGoal,
PerformedExercise = maxForRep,
ExerciseName = exerciseName,
Difference = normalisedMax - currentGoal.Weight,
AccomplishedDate = date
});
}
else
{
pendingGoals.Add(new GoalProgress
{
goal = currentGoal,
PerformedExercise = maxForRep,
ExerciseName = exerciseName,
Difference = normalisedMax - currentGoal.Weight
});
}
}
else
{
pendingGoals.Add(new GoalProgress
{
goal = currentGoal,
PerformedExercise =
{
Weight = 0.0f,
Repetition = 0,
Unit = "kg"
},
ExerciseName = exerciseName,
Difference = 0.0f - currentGoal.Weight
});
}
}
dashboard.AccomplishedGoals = accomplishedGoals;
dashboard.PendingGoals = pendingGoals;
db.connection.Close();
return(View(dashboard));
}
else
{
return(RedirectToAction("Login", "User"));
}
}