Combine all the data in a class

patrick

Hi everyone! If I had a class, ReportInfo

class

ReportInfo
{

public String Name { get; set; }

public Double Data { get; set; }

}

How can I make a List combine so that all the names that match add their data? for instance, if i had a List that had

Name="Sales", Data=100;
Name="Sales", Data=100;
Name="Sales Tax", Data=100;
Name="Sales", Data=100;
Name="Sales Tax", Data=100;
Name="Sales", Data=100;

How can I get a single list that would contain

Name="Sales", Data=400;
Name="Sales Tax", Data=200;

2 Replies

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

Vulpes14y ago
Accepted answer
Here's one way to do it:

using System;
using System.Collections.Generic;

class ReportInfo
{
public String Name { get; set; }
public Double Data { get; set; }
}

class Program
{
static void Main()
{
var list = new List();
list.Add(new ReportInfo{Name = "Sales", Data = 100});
list.Add(new ReportInfo{Name = "Sales", Data = 100});
list.Add(new ReportInfo{Name = "Sales Tax", Data = 100});
list.Add(new ReportInfo{Name = "Sales", Data = 100});
list.Add(new ReportInfo{Name = "Sales Tax", Data = 100});
list.Add(new ReportInfo{Name = "Sales", Data = 100});
var dict = new Dictionary();

foreach(ReportInfo ri in list)
{
if(!dict.ContainsKey(ri.Name))
{
dict.Add(ri.Name, ri.Data);
}
else
{
dict[ri.Name] += ri.Data;
}
}

var list2 = new List();
foreach(string key in dict.Keys) list2.Add(new ReportInfo{ Name = key, Data = dict[key]});

// check it worked
foreach(ReportInfo ri in list2) Console.WriteLine("Name = {0}, Data = {1}", ri.Name, ri.Data);
Console.ReadKey();
}
}
patrick14y ago
This was excellent. Much more effective than my solution. Thank you.