private IQueryable <Lecturer> Apply(IQueryable <Lecturer> lecturers, LecturerSearchEntity LecturerSearchEntity)
{
if (LecturerSearchEntity.Name != null)
{
lecturers = lecturers.Where(l => l.Name.ToLower().Contains(LecturerSearchEntity.Name.ToLower()) ||
LecturerSearchEntity.Name.ToLower().Contains(l.Name.ToLower()));
}
if (LecturerSearchEntity.Username != null)
{
lecturers = lecturers.Where(l => l.Username.ToLower().Contains(LecturerSearchEntity.Username.ToLower()) ||
LecturerSearchEntity.Username.ToLower().Contains(l.Username.ToLower()));
}
if (LecturerSearchEntity.Phone != null)
{
lecturers = lecturers.Where(l => l.Phone.Contains(LecturerSearchEntity.Phone) || LecturerSearchEntity.Phone.Contains(l.Phone));
}
if (LecturerSearchEntity.Vnumail != null)
{
lecturers = lecturers.Where(l => l.Vnumail.Equals(LecturerSearchEntity.Vnumail));
}
if (LecturerSearchEntity.LecturerCode != null)
{
lecturers = lecturers.Where(l => l.LecturerCode.Equals(LecturerSearchEntity.LecturerCode));
}
return(lecturers);
}
public int Count(UserEntity userEntity, LecturerSearchEntity LecturerSearchEntity)
{
if (LecturerSearchEntity == null)
{
LecturerSearchEntity = new LecturerSearchEntity();
}
IQueryable <Lecturer> lecturers = context.Lecturers;
lecturers = Apply(lecturers, LecturerSearchEntity);
return(lecturers.Count());
}
public List <LecturerEntity> List(UserEntity userEntity, LecturerSearchEntity LecturerSearchEntity)
{
if (LecturerSearchEntity == null)
{
LecturerSearchEntity = new LecturerSearchEntity();
}
IQueryable <Lecturer> lecturers = context.Lecturers.Include(l => l.Classes);
lecturers = Apply(lecturers, LecturerSearchEntity);
//lecturers = LecturerSearchEntity.SkipAndTake(lecturers);
return(lecturers.Select(l => new LecturerEntity(l, l.Classes)).ToList());
}
public List <LecturerEntity> List(UserEntity userEntity, LecturerSearchEntity LecturerSearchEntity)
{
if (LecturerSearchEntity == null)
{
LecturerSearchEntity = new LecturerSearchEntity();
}
IQueryable <Lecturer> lecturers = context.Lecturers.Include(l => l.Classes);
//List<User> Users = new List<User>();
lecturers = Apply(lecturers, LecturerSearchEntity);
// foreach (var lecturer in lecturers)
// {
// var lecturer_user = context.Users.FirstOrDefault(u => u.Id == lecturer.Id);
// Users.Add(lecturer_user);
// }
//
// return lecturers.Join(Users, l => l.Id, u => u.Id, (l, u) => new LecturerEntity(l, l.Classes, u))
// .ToList();
//lecturers = LecturerSearchEntity.SkipAndTake(lecturers);
return(lecturers.Select(l => new LecturerEntity(l, l.Classes)).ToList());
}
public List <LecturerEntity> List(LecturerSearchEntity LecturerSearchEntity)
{
return(LecturerService.List(UserEntity, LecturerSearchEntity));
}
public int Count(LecturerSearchEntity LecturerSearchEntity)
{
return(LecturerService.Count(UserEntity, LecturerSearchEntity));
}
