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());
}
