IQueryable Multiple filters on same item

Question

I am working on a hotel website
the website has 5 Check buttons ranging from 1 Hotel Star to 5

if none of the checkbuttons are enabled/clicked it should show all hotels

if one of the the 5 checkbuttons are enabled/clicked it should only show the hotel with that hotel star

if multiple checkbuttons are enabled/clicked it should only show those hotels with those stars;

I tried doing something like this

code:

                if (dto.Star1)  
                    rooms = rooms.Where(x => x.Stars == 1);  
  
                if (dto.Star2)  
                    rooms = rooms.Where(x => x.Stars == 2);  
  
                if (dto.Star3)  
                    rooms = rooms.Where(x => x.Stars == 3);  
  
                if (dto.Star4)  
                    rooms = rooms.Where(x => x.Stars == 4);  
  
                if (dto.Star5)  
                    rooms = rooms.Where(x => x.Stars == 5);  
  

If one of the Checkbuttons is clicked/enabled it works perfect but if I click enable mutliple checkbottons it returns nothing

Help me out with this please.

Answer 1

you want to generate an in clause:

var starList = new List<int>();  
      
if (dto.Star1) starList.Add(1);   
if (dto.Star2) starList.Add(2);   
if (dto.Star3) starList.Add(3);   
if (dto.Star4) starList.Add(4);   
if (dto.Star5) starList.Add(5);   
  
var  query = rooms.Where(x => starList.Contains(x.Stars));  
  
  
  

Answer 2

I cannot see your code but something like the following pattern.

var results = DbContext.Rooms.Where(x => (x.Stars == 1 & dto.Star1) |  
    (x.Stars == 2 & dto.Star2) |   
    (x.Stars == 3 & dto.Star3) |   
    (x.Stars == 4 & dto.Star4) |  
    (x.Stars == 5 & dto.Star5)).ToList();  

Answer 3

Thank you very much Joe,

I have tried to look up this problem for a couple of hours now,
Could you explain how it works im curious.

I know that "||" means OR, but what is "|"?
and what is a single & sign?

Is this a conditional operator inside a LINQ ?
I have never seen that but that would be pretty genius