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 == "")
return PartialView("DropdownTable", helpdesk);