How to Convert normal foreach loop into Lambda expression using c#.Net ?

Question

0.00/5 (No votes)

See more:

Hi,
In below are my code-

XML

public static Collection<SalesPlan> GetCurrentPlan(PurchasePlanRequest purchasePlanRequest)
        {
            SalesCustomerManager salesCustomerManager = new SalesCustomerManager();
            SalesCustomer salesCustomer = new SalesCustomer();

            salesCustomer.ReportingCustomerNumber = purchasePlanRequest.ReportingCustomerId;
            Collection<SalesPlan> salesPlanCollection = new Collection<SalesPlan>();
            salesCustomer = salesCustomerManager.GetCustomerLinesPlansCoverages(salesCustomer);
            Collection<SalesPlan> renewalPlan = new Collection<SalesPlan>();
            Collection<SalesPlan> currentPlan = new Collection<SalesPlan>();
            foreach (SalesLineOfBusiness lob in salesCustomer.SalesLineOfBusinessCollection)
            {
                if(lob.LineOfBusinessCode == purchasePlanRequest.LOBCode)
                {
                    foreach (SalesPlan salepln in lob.SalesPlanCollection)
                    {
                        if (salepln.IsCurrentPlan == true)
                        {
                            currentPlan.Add(salepln);
                        }
                    }
                }
            }
            return currentPlan;
        }

Instead of foreach loop, I want to use Lambda expression.Please suggest some approaches!!!!

Posted 19-Feb-13 1:02am

Member 8090436

Updated 19-Feb-13 1:06am

CHill60

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andreas Gieriet · Accepted Answer · 2013-02-19T01:44:00

1) the approach is to define a query that results in a sequence of items
2) you will then process the sequence of items (e.g. create the collection of these items instead of adding them individually)
3) each foreach...if translates into from... where... select (or myCollection.Where(...))
4) nested foreach is either chained or you use SelectMany()

Search google for an example on SelectMany.

[EDIT]
E.g.

C#

...
var query = salesCustomer.SalesLineOfBusinessCollection
            .Where(lob=>lob.LineOfBusinessCode == purchasePlanRequest.LOBCode)
            .SelectMany(lob=>lob.SalesPlanCollection)
            .Where(salepln=>salepln.IsCurrentPlan);
var currentPlan = new Collection<SalesPlan>(query);
...

[/EDIT]

Cheers
Andi

*Karthik Harve* · Accepted Answer · 2013-02-19T01:27:00

Solution 1

Hi,

try below code.

C#

Collection<salesplan> currentPlan = 
salesCustomer.SalesLineOfBusinessCollection.Where(c => c.LineOfBusinessCode == purchasePlanRequest.LOBCode).Select(s => s.SalesPlanCollection).Where(c => c.IsCurrentPlan == true).ToList<salesplan>();

hope it helps.

Posted 19-Feb-13 1:27am

Karthik Harve

Updated 19-Feb-13 1:28am

v2

Comments

Andreas Gieriet 19-Feb-13 7:48am

I think your first Select(...) should be a SelectMany(...) call since that selection results in a collection again from which you filter.
Andi