private List <Patients> FilterPatient()
{
PrepareFilter();
PatientsFilterModel f = model.filter;
var query = (from q in db.Patients select q);
if (f.p_surname != null)
{
query = query.Where(q => q.p_surname.Contains(f.p_surname));
}
if (f.p_name != null)
{
query = query.Where(q => q.p_name.Contains(f.p_name));
}
if (f.p_secname != null)
{
query = query.Where(q => q.p_secname.Contains(f.p_secname));
}
if (f.UseBirthday == true)
{
query = query.Where(q => q.p_birthday == f.p_birthday);
}
if (f.UseGender == true)
{
query = query.Where(q => q.p_genderId == f.p_genderId);
}
if (f.UseDiagnosis == true)
{
query = query.Where(q => q.p_diagnosisId == f.p_diagnosisId);
}
if (f.UseType == true)
{
query = query.Where(q => q.p_typeId == f.p_typeId);
}
if (f.UseBK == true)
{
query = query.Where(q => q.p_bkID == f.p_bkID);
}
if (f.UseDestruction == true)
{
query = query.Where(q => q.p_destructionId == f.p_destructionId);
}
return(query.ToList());
}
public ActionResult SetFilter(PatientsFilterModel f)
{
model.filter = f;
return(RedirectToAction("PatientsTable"));
}
