public Models.Workout.WorkoutAdvice GetById(int id) { var dbAdvice = _context.WorkoutAdvices .Include(x => x.Client) .ThenInclude(x => x.AppUser) .Include(x => x.Trainer) .ThenInclude(x => x.AppUser) .Where(x => x.Id == id) .FirstOrDefault(); if (dbAdvice == null) { throw new ResourceNotFoundException($"Workour advice with id {id} not found"); } return(WorkoutAdviceMapper.fromDb(dbAdvice)); }
public List <Models.Workout.WorkoutAdvice> GetAll(WorkoutAdviceQueryParams queryParams, UserInfo userInfo) { var query = _context.WorkoutAdvices .Include(x => x.Client) .ThenInclude(x => x.AppUser) .Include(x => x.Trainer) .ThenInclude(x => x.AppUser) .AsQueryable(); if (userInfo.Role == "EMPLOYEE") { if (queryParams.ClientId != null) { query = query.Where(x => x.ClientId == queryParams.ClientId); } if (queryParams.TrainerId != null) { query = query.Where(x => x.TrainerId == queryParams.TrainerId); } } else if (userInfo.Role == "TRAINER") { query = query.Where(x => x.TrainerId == userInfo.Id); } else { query = query.Where(x => x.ClientId == userInfo.Id); if (queryParams.TrainerId != null) { query = query.Where(x => x.TrainerId == queryParams.TrainerId); } } return(query.Select(x => WorkoutAdviceMapper.fromDb(x)) .ToList()); }