How to get products from list based on quantity and max

Ramesh p

6y1.1kLINQ

Hi,

I have list like List.This list contains the objects.

PromoptionProducts

Case1:

List promotionproduct=new List(new promotionproduct({Id=1,productId=101,qty=4,price=25,max=3 });

I want to get the qty of products from list based on max that means I want 3qtyproducts from the list based on 3.

List promotionproduct=new List(new promotionproduct({Id=1,productId=101,qty=2,price=25,max=3 },new promotionproduct({Id=2,productId=102,qty=2,price=35,max=3 });

I want to get the qty of products from list based on max that means I want 3 qty products from the list based on 3.

While using linq queries.

Please help me.

Thank you.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhruv Tanna6y ago
Hello Ramesh,

As I am understanding your requirement here, that you want to retrive the number of products from the 'promotionproduct' list which are equvivalent to the max property from your list. So to achive this we can do the following.

1. First we need to use an aggregate function named Max() on promotionproduct collection and store its value on a variable.
2. And then you can use Take() function on your collection with argument of the recently saved variable value of max.

Please have a look on the solution.
int maxCount = promotionproduct.Max(m => m.max);

List filteredPromotionProducts = promotionproduct.Take(maxCount).ToList();
Ramesh Palanivel6y ago
Hi Ramesh,

Please try the below code,
var filteredList=promotionproduct.where(x=>x.max==3).take(3).toList();