public async Task <List <TestModel> > GetStudents()
{
List <TestModel> students = new List <TestModel>();
var studentsInDb = _repository.All <Student>();
foreach (var student in studentsInDb)
{
var result = new TestModel()
{
Id = student.Id,
FirstName = student.FirstName,
LastName = student.LastName,
Score = student.ClassId
};
students.Add(result);
}
return(students);
}
//public List<Student> GetStudentsFromGroup(int id)
//{
// var students = _repository.RubricsContext.Students.FromSqlRaw("SELECT * FROM dbo.Students WHERE GroupId = @id",
// new SqlParameter("id",id)).ToList();
// return students;
//}
public List <Student> GetStudentsFromGroup(int id)
{
var students = _repository.All <Student>().Where(x => x.ClassId == id).ToList();
return(students);
}
