public List <Matricula> FindByCursoId(string idCurso) { return(_repository.FindByCursoId(idCurso)); string query = @"SELECT ALU.* FROM ALUNO ALU"; query = query + $" INNER JOIN MATRICULA MAT ON MAT.IdAluno = ALU.Id "; query = query + $" WHERE MAT.IdCurso =" + idCurso; //query = query + $ AND MAT.DATA BETWEEN "('2019/05/01') AND ('2019/05/28'); "; //if (!string.IsNullOrEmpty(name)) query = query + $" and p.firstName like '%{name}%'"; //var pessoas = _repository.FindWithPagedSearch(query); //int totalResults = _repository.GetCount(countQuery); //return new PagedSearchDTO<Matricula> //{ // CurrentPage = page + 1, // List = _mapper.Map<List<Matricula>, List<Matricula>>(pessoas), // PageSize = pageSize, // SortDirections = sortDirection, // TotalResults = totalResults //}; }