public List <MarkResultDTO> GetMarkResultsFiltered(FilterDTO filterDTO) { IQueryable <Mark> data = _markRepository.GetAll(); if (filterDTO.Score > 0) { data = data.Where(p => p.Score > filterDTO.Score); } if (!string.IsNullOrEmpty(filterDTO.StudentName)) { data = data.Where(p => p.Student.FullName.ToLower().Contains(filterDTO.StudentName.ToLower())); } if (!string.IsNullOrEmpty(filterDTO.SubjectName)) { data = data.Where(p => p.Subject.Name.ToLower().Contains(filterDTO.SubjectName.ToLower())); } return(_mapper.Map <List <MarkDTO> >(data).GroupBy(p => p.StudentId) .Select(marks => new MarkResultDTO() { StudentName = marks.FirstOrDefault(p => p.StudentId == marks.Key).StudentName, Marks = marks.ToList() }).ToList()); }
public IEnumerable <Marks> GetMarks() { var Marks = MarkRepository.GetAll(); return(Marks); }
public List <Mark> GetAll() { return(_repository.GetAll()); }