LINQ Query not working properly ASP.NET CORE MVC

Question

I am writing a LINQ query to get the queues of an agent and then removing rows that match a specific criteria but the web page displays the entire list.

var agentQueues = _context.AgentQueues.Where(e => e.AgentId == Request.AgentId)
                                .OrderByDescending(e => e.ScheduleTime)
                                .ThenBy(e => e.AgentQueueId)
                                .ToList();

agentQueues.RemoveAll(e => !e.Status.Equals("Waiting") && !e.Status.Equals("Running") && !e.Deleted==false);

Even though I am writing RemoveAll, the query still displays rows that contain Statuses other than 'Running' and 'Waiting'. It would be great if anyone could point me to the right direction here.

Hien Nguyen · Accepted Answer · 2020-06-08 13:15:55Z

2

Change your query to this, use || instead of && for status

    agentQueues.RemoveAll((e => !e.Status.Equals("Waiting") || 
!e.Status.Equals("Running")) && !e.Deleted==false);

answered Jun 8, 2020 at 13:15

Hien Nguyen

19k7 gold badges57 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LINQ Query not working properly ASP.NET CORE MVC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related