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