Ufdjrw

Can a vampire attack twice with their claws using Multiattack?

Is it possible to do 50 km distance without any previous training?

Why does Kotter return in Welcome Back Kotter?

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

Does detail obscure or enhance action?

Paid for article while in US on F-1 visa?

Watching something be written to a file live with tail

Is it possible to record a short contained sound no longer than 60 milliseconds?

How does quantile regression compare to logistic regression with the variable split at the quantile?

strTok function (thread safe, supports empty tokens, doesn't change string)

Did Shadowfax go to Valinor?

How to format long polynomial?

Is it unprofessional to ask if a job posting on GlassDoor is real?

Arrow those variables!

How much RAM could one put in a typical 80386 setup?

Why is Minecraft giving an OpenGL error?

Character reincarnated...as a snail

Languages that we cannot (dis)prove to be Context-Free

Can I ask the recruiters in my resume to put the reason why I am rejected?

A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

What does the "remote control" for a QF-4 look like?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

How to efficiently unroll a matrix by value with numpy?

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

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-1

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 | 

-1

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