Where clause in Controller?Ask Questions

 Posted on 10/09/2019

I want to return a sql query for the column status. I can have 3 unique status values: New, In Process and Complete. I want to query for these 3 plus a Open which would include New and In Process but not Complete. How do I do that in my controller code?

Status would be the parameter that if it is  'Open' it will return everything BUT status of 'Complete. How can I do this?




public PartialViewResult ChangeDrop(string Status, string Tech)
  var helpdesk = from m in db.HelpDesks
                          where (m.Status == Status || Status == null || Status == "") && (m.Technician == Tech || Tech == null || Tech == "")
                          select m;
   return PartialView("DropdownTable", helpdesk);

Share On: facebook gplus twitter
Asked by Mohammad Asif on 10/09/2019 Score: 21 points
Add Comment:


1 Answers

0 Corrected Answers
Aproved Answers
Answered by Walter Tross on 10/9/2019 8:29:53 AM Score: 24 points


You can try this code 

public PartialViewResult ChangeDrop(string Status, string Tech)
          var helpdesk = db.HelpDesks.ToList();
          if(!string.IsNullOrEmpty(status) && status.ToLower() == "open")
                      helpdesk = helpdesk.where(o=>o.status.ToLower() != "complete").ToList();
          return PartialView("DropdownTable", helpdesk);


Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.