Linq query with multiple conditions

Question

how to write the linq query with these conditions..first we have to check the OrderType if this is true then and condition should be checked.How to write the query..if i close the condition at .OrderType.XYZ) then it says 'zj' doesn't belong to the current context..if we remove that no error but we r not getting the req result

bool btnvisible= datacontext.GetOrders(new List<Items> { selectedItem }).
   .Where((zj => wo.OrderId== (int)BL.OrderType.PQR || zj.OrderId== (int)BL.OrderType.XYZ)
           &&( zj.OrderId== (int)BL.Statuses.Assigned
             || zj.OrderId== (int)BL.Statuses.Planned 
             || zj.OrderId== (int)BL.Statuses.InProgess
             || zj.OrderId== (int)BL.Statuses.Paused 
             || zj.OrderId== (int)BL.Statuses.Ready)).Any();
return btnEnable;

You ask "first we have to check the OrderType if this is true then and condition should be checked." but you're clearly using enums in your example. — Brian
– Brian, Commented Feb 29, 2012 at 22:07

kevev22 · Accepted Answer · 2012-02-29 22:12:08Z

2

I think this is due to some misplaced brackets. You have .Where((zj => ...) ... zj ...). The variable zj doesn't exist outside of the first set of brackets. It should be something like:

bool btnvisible= datacontext.GetOrders(new List<Items> { selectedItem })
   .Where(zj => (wo.OrderId== (int)BL.OrderType.PQR || zj.OrderId== (int)BL.OrderType.XYZ)
           && (zj.OrderId== (int)BL.Statuses.Assigned
             || zj.OrderId== (int)BL.Statuses.Planned 
             || zj.OrderId== (int)BL.Statuses.InProgess
             || zj.OrderId== (int)BL.Statuses.Paused 
             || zj.OrderId== (int)BL.Statuses.Ready)).Any();
return btnEnable;

edited Feb 29, 2012 at 22:12

answered Feb 29, 2012 at 22:06

kevev22

3,76524 silver badges32 bronze badges

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

Comments

Mike Hofer · Accepted Answer · 2012-02-29 22:10:23Z

2

You appear to have a mismatched parenthesis problem.

.Where((zj => wo.OrderId== (int)BL.OrderType.PQR || zj.OrderId== (int)BL.OrderType.XYZ) 
       ^                                                                              ^

That's mucking with the scope of your variable. Revisit it.

answered Feb 29, 2012 at 22:10

Mike Hofer

17.1k11 gold badges80 silver badges117 bronze badges

Comments

avpaderno · Accepted Answer · 2012-03-01 00:56:02Z

2

var readyStats = new [] {
   (int)BL.Statuses.Assigned,
   (int)BL.Statuses.Planned,
   (int)BL.Statuses.InProgess,
   (int)BL.Statuses.Paused,
   (int)BL.Statuses.Ready,
};

var orderTypes = new [] {
    (int)BL.OrderType.PQR,
    (int)BL.OrderType.XYZ
}

bool btnvisible= datacontext.GetOrders(new List<Items> { selectedItem }).
   .Where(wo => orderTypes.Contains(wo.OrderId) && readyStats.Contains(wo.OrderId)).Any();

or

bool btnvisible= datacontext.GetOrders(new List<Items> { selectedItem }).
       .Any(wo => orderTypes.Contains(wo.OrderId) && readyStats.Contains(wo.OrderId));

I think the problem is here:

.Where((zj => wo.

The right version should be:

   .Where(zj => zj.

edited Mar 1, 2012 at 0:56

avpaderno

30k17 gold badges80 silver badges95 bronze badges

answered Feb 29, 2012 at 22:08

Adrian Iftode

15.7k4 gold badges51 silver badges73 bronze badges

Collectives™ on Stack Overflow

Linq query with multiple conditions

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related