public PopulatePlanViewModel GetPlanViewModel(int traineeID)
{
PopulatePlanViewModel plan = new PopulatePlanViewModel();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string SQL_Plans = "SELECT plan_id, plan_name from workout_plan WHERE trainee_id = @trainee_ID";
conn.Open();
using (SqlCommand cmd = new SqlCommand(SQL_Plans, conn))
{
cmd.Parameters.AddWithValue("@trainee_ID", traineeID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
PopulatePlanViewModel planToAdd = MapRowToPlanViewModel(reader);
plan = planToAdd;
}
}
}
return(plan);
}
public ActionResult AddExercisesToWorkout(int planId, int workoutId)
{
int trainerId = (int)Session[SessionKeys.Trainer_ID];
PopulatePlanViewModel vm = new PopulatePlanViewModel();
vm.Workout = _workoutDal.GetWorkout(workoutId);
vm.Exercises = _workoutDal.GetExercisesForTrainer(trainerId);
return(View(vm));
}
public ActionResult AddExercisesToWorkout(int planId, int workoutId)
{
if (Session[SessionKeys.Trainer_ID] == null)
{
return(Redirect("/User/Login"));
}
int trainerId = (int)Session[SessionKeys.Trainer_ID];
PopulatePlanViewModel vm = new PopulatePlanViewModel();
vm.PlanID = planId;
vm.Workout = _workoutDal.GetWorkout(workoutId);
vm.Exercises = _workoutDal.GetExercisesForTrainer(trainerId);
return(View(vm));
}
