Ggtcf

Is this toilet slogan correct usage of the English language?

What if a revenant (monster) gains fire resistance?

How can "mimic phobia" be cured or prevented?

Angel of Condemnation - Exile creature with second ability

Can I visit Japan without a visa?

Tranfer/transit via Schengen area with 2 separate tickets and no visa

Store Credit Card Information in Password Manager?

Why is it that I can sometimes guess the next note?

Calculating total slots

Do the primes contain an infinite almost arithmetic progression?

Why did the EU agree to delay the Brexit deadline?

Can I still be respawned if I die by falling off the map?

I'm the sea and the sun

Keeping a ball lost forever

Multiplicative persistence

The IT department bottlenecks progress. How should I handle this?

Are Captain Marvel's powers affected by Thanos' actions in Infinity War

How do you make your own symbol when Detexify fails?

Does the Linux kernel need a file system to run?

Open a doc from terminal, but not by its name

Creepy dinosaur pc game identification

How to hide some fields of struct in C?

How do apertures which seem too large to physically fit work?

Does an advisor owe his/her student anything? Will an advisor keep a PhD student only out of pity?

How to build a query based on user input

Populate text box based on search criteria in MVC C#How to “add existing frameworks” in Xcode 4?How can I get Id of inserted entity in Entity framework?How should a model be structured in MVC?Transform Data Objects to View Objects for different views with the same formattingHow can I access ViewModel from JavascriptC# razor input var to controller search sqlmvcHow can I create a dynamic dropdown list based on the users selection in codeigniter MVCPHP MVC for login form

0

I have a cshtml view where the user can enter a first name, last name, or a SSN number and then do a search. They can enter any data they want in any box. The more data they enter, the more narrow the search becomes. Currently each if statement I have in my code is doing an 'or' statement; it adds extra rows to my result set if I enter information into another search box. I want it to be an "and" situation. This is what I have:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

But I would like it to be something like this:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

Note: I added FilterSet + to each line.

I know it is probably a simple question so any help with this would be much appreciated.

thanks
adam

model-view-controller frameworks entity

share|improve this question

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

add a comment | 

0

I have a cshtml view where the user can enter a first name, last name, or a SSN number and then do a search. They can enter any data they want in any box. The more data they enter, the more narrow the search becomes. Currently each if statement I have in my code is doing an 'or' statement; it adds extra rows to my result set if I enter information into another search box. I want it to be an "and" situation. This is what I have:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

But I would like it to be something like this:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

Note: I added FilterSet + to each line.

I know it is probably a simple question so any help with this would be much appreciated.

thanks
adam

model-view-controller frameworks entity

share|improve this question

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

add a comment | 

I have a cshtml view where the user can enter a first name, last name, or a SSN number and then do a search. They can enter any data they want in any box. The more data they enter, the more narrow the search becomes. Currently each if statement I have in my code is doing an 'or' statement; it adds extra rows to my result set if I enter information into another search box. I want it to be an "and" situation. This is what I have:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

But I would like it to be something like this:

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

Note: I added FilterSet + to each line.

I know it is probably a simple question so any help with this would be much appreciated.

thanks
adam

model-view-controller frameworks entity

share|improve this question

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

 var FilterSet = VetDb.AllPeople.AsQueryable();
 if(!string.IsNullOrEmpty(FirstName))
 
 FilterSet = FilterSet.Where(m => m.First_Name.ToLower().Contains(FirstName.ToLower()));
 
 else if(!string.IsNullOrEmpty(LastName))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.Last_Name.ToLower().Contains(LastName.ToLower()));
 
 else if (!string.IsNullOrEmpty(SSN))
 
 FilterSet = FilterSet + FilterSet.Where(m => m.SSN.ToLower().Contains(SSN.ToLower()));
 

share|improve this question

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

share|improve this question

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12

asked Mar 8 at 2:14

Adam StallcupAdam Stallcup

12