private static WorkoutRoutine GetWorkoutRoutineFromDR(NpgsqlDataReader dr) { int intWorkoutRoutineID = Convert.ToInt32(dr["intWorkoutRoutineID"]); int intTotalMinutes = Convert.ToInt32(dr["intTotalMinutes"]); int intTotalCalsBurned = Convert.ToInt32(dr["intTotalCalsBurned"]); int intUserID = Convert.ToInt32(dr["intUserID"]); List <ExerciseType> lstRoutine = ExerciseTypeDAL.GetExercisesByWorkout(intWorkoutRoutineID).ToList(); WorkoutRoutine workoutRoutine = WorkoutRoutine.of(intWorkoutRoutineID, intTotalMinutes, lstRoutine, intTotalCalsBurned); return(workoutRoutine); }
internal static bool AddWorkoutRoutine(int[] arrIntExerciseTypeIDs) { int intUserID = HomeController.USER_NUMBER; int intDayID = HomeController.DAY_NUMBER; // calculate total minutes and total calories burned List <ExerciseType> exercises = new List <ExerciseType>(); ExerciseType tmpExercise; foreach (int id in arrIntExerciseTypeIDs) { tmpExercise = ExerciseTypeDAL.GetExerciseTypeByID(id); exercises.Add(tmpExercise); } int intTotalMinutes = 0; int intTotalCalsBurned = 0; foreach (ExerciseType ex in exercises) { intTotalMinutes += ex.intTime; intTotalCalsBurned += ex.intCaloriesBurned; } WorkoutRoutine workoutRoutine = WorkoutRoutine.of(intTotalMinutes, exercises, intTotalCalsBurned); // insert to workout table // get the id of new workout int intWorkoutRoutineID = InsertToWorkoutTable(workoutRoutine, intUserID); bool success = false; // insert each id in array to workoutExerciseType table foreach (ExerciseType ex in exercises) { success = InsertToWorkoutExerciseTypeTable(intWorkoutRoutineID, ex.intExerciseTypeID); } // remove time from alloted exercise minutes bool exMinsSuccess = RemoveTime(intTotalMinutes, intUserID, intDayID); // add calories to users' calories for the day bool calsSuccess = AddCals(workoutRoutine.intTotalCalsBurned, intUserID, intDayID); // insert to day/exercise table bool daySuccess = InsertToDayExerciseTable(intWorkoutRoutineID, intDayID); return(success && exMinsSuccess && calsSuccess); }