public StudentOutDTO GetStudentById(int id)
{
var student = _context.Students.AsNoTracking().Include("Gender").Where(x => x.StudentId == id).FirstOrDefault();
StudentOutDTO outDTO = new StudentOutDTO
{
StudentId = student.StudentId,
StudentName = student.StudentName,
DateOfBirth = student.DateOfBirth,
Gender = student.Gender.GenderName,
GenderId = student.GenderId,
PicturePath = student.PicturePath
};
return(outDTO);
}
public IEnumerable <StudentOutDTO> GetStudents()
{
var studentList = _context.StudentView.FromSql("spGetStudents").ToList();
List <StudentOutDTO> studentOutList = new List <StudentOutDTO>();
foreach (var item in studentList)
{
StudentOutDTO dto = new StudentOutDTO
{
StudentId = item.StudentId,
StudentName = item.StudentName,
Gender = item.Gender,
DateOfBirth = item.DateOfBirth,
PicturePath = item.PicturePath
};
studentOutList.Add(dto);
}
return(studentOutList);
}
public IEnumerable <StudentOutDTO> GetStudents()
{
var students = _context.Students.Include("Gender").ToList();
List <StudentOutDTO> studentOuts = new List <StudentOutDTO>();
foreach (var student in students)
{
StudentOutDTO outDTO = new StudentOutDTO
{
StudentId = student.StudentId,
StudentName = student.StudentName,
DateOfBirth = student.DateOfBirth,
Gender = student.Gender.GenderName,
GenderId = student.GenderId,
PicturePath = student.PicturePath
};
studentOuts.Add(outDTO);
}
return(studentOuts);
}
public StudentOutDTO GetStudentById(int id)
{
StudentOutDTO student = _context.StudentView.FromSql("spGetStudentById {0}", id).FirstOrDefault();
return(student);
}
