public static Workout LoadById(Guid id) { try { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { tblWorkout row = dc.tblWorkouts.FirstOrDefault(g => g.Id == id); if (row != null) { Workout workout = new Workout { Id = row.Id, WorkoutType = WorkoutTypeManager.LoadById(row.WorkoutTypeId), StartTime = row.StartTime, EndTime = row.EndTime, UserId = row.UserId }; return(workout); } else { throw new Exception("Row was not found!"); } } } catch (Exception ex) { throw ex; } }
public static List <Workout> Load(Guid userId) { //Retrieve all the rows in a list try { List <Workout> rows = new List <Workout>(); using (AmbrosiaEntities dc = new AmbrosiaEntities()) { dc.tblWorkouts .Where(w => w.UserId == userId) .ToList() .ForEach(g => rows.Add(new Workout { Id = g.Id, WorkoutType = WorkoutTypeManager.LoadById(g.WorkoutTypeId), StartTime = g.StartTime, EndTime = g.EndTime, UserId = g.UserId })); return(rows); } } catch (Exception ex) { throw ex; } }