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