private IQueryable <Student> Apply(IQueryable <Student> Students, StudentSearchEntity StudentSearchEntity)
{
if (StudentSearchEntity.Name != null)
{
Students = Students.Where(l =>
l.Name.ToLower().Contains(StudentSearchEntity.Name.ToLower()) || StudentSearchEntity.Name.ToLower().Contains(l.Name.ToLower()));
}
if (StudentSearchEntity.Code != null)
{
Students = Students.Where(l =>
l.Code == StudentSearchEntity.Code);
}
if (StudentSearchEntity.Username != null)
{
Students = Students.Where(l =>
l.Username.ToLower().Contains(StudentSearchEntity.Username.ToLower()) ||
StudentSearchEntity.Username.ToLower().Contains(l.Username.ToLower()));
}
if (StudentSearchEntity.Class != null)
{
Students = Students.Where(l =>
l.Class.ToLower().Equals(StudentSearchEntity.Class.ToLower()));
}
return(Students);
}
public int Count(UserEntity userEntity, StudentSearchEntity StudentSearchEntity)
{
if (StudentSearchEntity == null)
{
StudentSearchEntity = new StudentSearchEntity();
}
IQueryable <Student> Students = context.Students;
Students = Apply(Students, StudentSearchEntity);
return(Students.Count());
}
public List <StudentEntity> List(UserEntity userEntity, StudentSearchEntity StudentSearchEntity)
{
if (StudentSearchEntity == null)
{
StudentSearchEntity = new StudentSearchEntity();
}
IQueryable <Student> Students = context.Students.Include(s => s.StudentClasses);
Students = Apply(Students, StudentSearchEntity);
//Students = StudentSearchEntity.SkipAndTake(Students);
return(Students.Select(s => new StudentEntity(s, s.StudentClasses)).ToList());
}
public List <StudentEntity> List(UserEntity userEntity, StudentSearchEntity StudentSearchEntity)
{
if (StudentSearchEntity == null)
{
StudentSearchEntity = new StudentSearchEntity();
}
IQueryable <Student> Students = context.Students.Include(s => s.StudentClasses);
Students = Apply(Students, StudentSearchEntity);
//// List<User> Users = new List<User>();
//// foreach (var Student in Students)
//// {
//// var User = context.Users.FirstOrDefault(u => u.Id == Student.Id);
//// Users.Add(User);
//// }
////
//// return Students.Join(Users, u => u.Id, s => s.Id, (student, user) => new StudentEntity(student, student.StudentClasses, user)).ToList();
// //Students = StudentSearchEntity.SkipAndTake(Students);
return(Students.Select(s => new StudentEntity(s, s.StudentClasses)).ToList());
}
public List <StudentEntity> List(StudentSearchEntity StudentSearchEntity)
{
return(StudentService.List(UserEntity, StudentSearchEntity));
}
public int Count(StudentSearchEntity StudentSearchEntity)
{
return(StudentService.Count(UserEntity, StudentSearchEntity));
}
