Where clause in Controller?Ask Questions

 Posted on 12 days ago

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?

 

Thanks!

 

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
profile
Asked by Mohammad Asif on 12 days ago Score: 19 points
Add Comment:

Comments

1 Answers

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

Hello,

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

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
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.