Filtering with Multiple DropDown Lists in MVC

Question

I am working on 3-tier Architecture project and I have multiple DropDown Lists to make filtering of data that is fetched from database using LINQ.

Now I need a way to filter with these dropdowns where when I select an item in any dropdown it is filtering and when I select from two dropdowns to filter by these two selections and so on...

I use linq like this:

var doctors = from d in db.Doctors
              where d.CityID == id
              && d.HasSecretary == hasSec
              && d.OldSystem == oldSys
              && d.MetDoctor == metDoc
              && d.PriceProblem == priceProb
              && d.EasyToConvince == easyToCon
              && d.ComputerSavvy == comSav
              && d.Sold == sold
              && d.NotInterested == notIntr
              && d.FollowUp == followUp
              && d.NewClinic == newClin
              && d.RequestedADemo == reqDemo
              select d;

And it is filtering only when I select all dropdowns, and not individually.

Please help :)

Did you end up finding a solution?

CrnaStena
– CrnaStena

2015-07-29 14:59:59 +00:00
Commented Jul 29, 2015 at 14:59 — CrnaStena
– CrnaStena, Commented Jul 29, 2015 at 14:59

CrnaStena · Accepted Answer · 2015-07-28 20:49:11Z

1

You will have to do conditional where clauses e.g.

var doctors = from d in db.Doctors;

if (id != null)
  doctors = doctors.Where(d => d.CityID == id);
if (hasSec)
  doctors = doctors.Where(d => d.HasSecretary == hasSec);

// other if statements

// results
var results = doctors.ToList();

answered Jul 28, 2015 at 20:49

CrnaStena

3,2355 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CrnaStena Over a year ago

@IbrahimSamara no problem.

Collectives™ on Stack Overflow

Filtering with Multiple DropDown Lists in MVC

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related