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