List of Class Assign multiple values to string list

Question

class orders
{
    public string orderNumber { get; set; }
    public string id { get; set; }
    public List<string> idList { get; set; }
}

I have a list of orders that can be anywhere from 1 to 100. I need to assign each member of the list all of the "id"s of the other members of the list where the "orderNumber" is the same. I want to assign this to the "idList" list of strings. Within the list of orders, there might be multiple sets of orders that have the same "orderNumber".

I've tried to logically think this out but cannot come up with a solution that works.

I tried the following:

List<string> temp = new List<string>();
            for (int x = 0; x < orders.Count; x++)
            {

                if (string.Equals(orders[x].orderNumber, orders[x + 1].orderNumber))
                {
                    temp.Add(orders[x].id);
                    temp.Add(orders[x + 1].id);
                    i++;
                }
                else
                {
                    for(int o = 0; o < i; o++)
                    {
                        orders[o].idList= new List<string>();
                        orders[o].idList= temp;
                    }

                    i = 0;
                    temp.Clear();
                }
            }

"cannot come up with a solution that works." -- show us solutions that didnt work then. We aren't a code writing service — maccettura
– maccettura, Commented Oct 31, 2018 at 19:46
I tried using a for loop and match on orders[x].orderNumber == orders[x + 1].orderNumber and then add both "id"s to a list of strings and increment a count. Once the loop finds the next orderNumber where it doesn't match, I assign the list of strings to the "idList" of each order using another for loop that goes up to the count. This would work for 1 set of orders that have the same orderNumber but not multiples. — AWooster
– AWooster, Commented Oct 31, 2018 at 19:56

Ashkan Mobayen Khiabani · Accepted Answer · 2018-10-31 20:03:27Z

2

You may GroupBy the orderNumber, and join ids of those within the same group:

var result = orders.GroupBy(x => x.orderNumber).Select(g => new orders{
           orderNumber  = g.Key,
           idList = g.Select(x => x.Id).ToList()
          }

However as you don't really need a list of orders so its better to either select an anonymous type:

.Select(g => new {
               orderNumber  = g.Key,
               idList = g.Select(x => x.Id).ToList()
              }

Or just create a new type of class like:

class FinalOrder { public string orderNumber; public List idList ; }

and then:

.Select(g => new FinalOrder{
               orderNumber  = g.Key,
               idList = g.Select(x => x.Id).ToList()
     }

edited Oct 31, 2018 at 20:03

answered Oct 31, 2018 at 19:48

Ashkan Mobayen Khiabani

34.3k35 gold badges111 silver badges187 bronze badges

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

Collectives™ on Stack Overflow

List of Class Assign multiple values to string list

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