public static List <Program> GetPrograms() { List <Program> allPrograms = new List <Program>(); using (Models.TrackerContext trackerDatabase = new Models.TrackerContext()) { var programs = trackerDatabase.Programs.ToList(); programs.ForEach(p => { allPrograms.Add(ProgramFactory.Create_Client_From_Database(p)); }); } return(allPrograms); }
private static Dictionary <int, string> _BuildExerciseMap() { _ExerciseMap = new Dictionary <int, string>(); using (Models.TrackerContext trackerDatabase = new Models.TrackerContext()) { var allExercises = trackerDatabase.Exercises.ToList(); allExercises.ForEach(exercise => { if (_ExerciseMap.Keys.Contains(exercise.ExerciseID) == false) { _ExerciseMap.Add(exercise.ExerciseID, exercise.ExerciseName); } }); } return(_ExerciseMap); }
internal static Utilites.Objects.Program Create_Client_From_Database(Models.Program databaseProgram) { if (databaseProgram == null) { return(new Utilites.Objects.Program()); } Utilites.Objects.Program clientProgram = new Utilites.Objects.Program(); clientProgram.ID = databaseProgram.ProgramID; clientProgram.Name = string.Copy(databaseProgram.ProgramName); using (Models.TrackerContext trackerDatabase = new Models.TrackerContext()) { var workoutsForProgram = trackerDatabase.ProgramTemplates.Where(p => p.ProgramID == databaseProgram.ProgramID); foreach (Models.ProgramTemplate template in workoutsForProgram) { clientProgram.Workouts.Add(WorkoutFactory.Create_Client_From_Database(template)); } } return(clientProgram); }