public List <AssistanceDTO> findByCoachId(int coachId, DateTime day) { List <AssistanceDTO> assistanceDTOs = new List <AssistanceDTO>(); List <session> sessions = context.session .Where(a => a.coachId == coachId && a.sessionDay == day && a.available) .ToList(); sessions.ForEach(x => { if (!assistanceDTOs.Exists(a => a.athleteId == x.athleteId && a.dateTime == x.sessionDay && a.weekId == x.weekId)) { assistanceDTOs.Add(AssistanceDTO.from(x, sessions .Where(s => s.athleteId == x.athleteId && s.weekId == x.weekId) .OrderBy(s => s.shiftId) .ToList())); } }); return(assistanceDTOs); }
public void insertAssistanceDTO(AssistanceDTO assistanceDTO) { throw new NotImplementedException(); }