// GET: Students
public async Task <IActionResult> Index(string firstname, string lastname, string studentid)
{
IQueryable <Student> students = _context.Student.AsQueryable();
if (!string.IsNullOrEmpty(firstname))
{
students = students.Where(x => x.FirstName == firstname);
}
if (!string.IsNullOrEmpty(lastname))
{
students = students.Where(x => x.LastName == lastname);
}
if (!string.IsNullOrEmpty(studentid))
{
students = students.Where(x => x.StudentId == studentid);
}
var studentsSearchVM = new StudentsSearchViewModel
{
Students = await students.ToListAsync(),
firstName = firstname,
lastName = lastname,
studentId = studentid,
};
return(View(studentsSearchVM));
}
// GET: Students
public async Task <IActionResult> Index(string sFullName, string sStudentId)
{
IQueryable <Student> students = _context.Students.AsQueryable();
if (!string.IsNullOrEmpty(sFullName))
{
students = students.Where(s => (s.FirstName + " " + s.LastName).ToLower().Contains(sFullName.ToLower()));
//students = students.Where(s => s.FullName.ToLower().Contains(sFullName.ToLower()));
}
if (!string.IsNullOrEmpty(sStudentId))
{
students = students.Where(x => x.StudentId.Contains(sStudentId));
}
var studentSearchViewModel = new StudentsSearchViewModel
{
Students = await students.ToListAsync()
};
System.Console.WriteLine(students.ToString());
return(View(studentSearchViewModel));
}
