public List <StudentDTO> getStudentBySchoolId(long schoolId) { using (MyDbContext ctx = new MyDbContext()) { BaseDAL <Student> bs = new BaseDAL <Student>(ctx); var persons = bs.getAll().Include(s => s.Teachers).Where(s => s.schoolId == schoolId); List <StudentDTO> students = new List <StudentDTO>(); foreach (var person in persons) { StudentDTO studentdto = getDTO(person); students.Add(studentdto); //studentdto.teacherId = person.Teachers.; //studentdto.schoolId = person.schoolId; } return(students); } }
public StudentDTO[] getStudentByID(long teacherId) { using (MyDbContext ctx = new MyDbContext()) { BaseDAL <Teacher> bs = new BaseDAL <Teacher>(ctx); var entities = bs.getAll().Include(e => e.students) .Include(e => e.school).Where(e => e.Id == teacherId) .SingleOrDefault().students; List <StudentDTO> list = new List <StudentDTO>(); foreach (Student s in entities) { StudentDTO sto = new StudentDTO(); sto.Adress = s.Adress; sto.Age = s.Age; sto.BirthDateTime = s.BirthDateTime; sto.departments = s.departments; sto.EmailAdress = s.EmailAdress; sto.EnrollmentYear = s.EnrollmentYear; sto.firstLoginTime = s.firstLoginTime; sto.Gender = s.Gender; sto.Id = s.Id; sto.IDnumber = s.IDnumber; sto.is_delete = s.is_delete; sto.lastLoginIp = s.lastLoginIp; sto.lastloginTime = s.lastloginTime; sto.major = s.major; sto.Name = s.Name; sto.Password = s.Password; sto.passwordSalty = s.passwordSalty; sto.PhoneNum = s.PhoneNum; sto.schoolId = s.schoolId; sto.schoolName = s.School.Name; sto.stuId = s.stuId; sto.teacherIds = s.Teachers.Select(t => t.Id).ToArray(); list.Add(sto); } return(list.ToArray()); } }