private static void Transform() { DataTable shippers = _invoiceTable.Tables[0].DefaultView.ToTable(true, new[] { "ShipperName" }); _freightByShipperList = new List <FreightByShipper>(); foreach (DataRow row in shippers.Rows) { Console.WriteLine("{0}", row[0]); var myShipper = new FreightByShipper { ShipperName = row[0].ToString() }; myShipper.Freight = CalculateFreightForShipper(myShipper.ShipperName); _freightByShipperList.Add(myShipper); } var totalFreight = (decimal)_invoiceTable.Tables[0].Compute("sum(freight)", ""); Console.WriteLine("Total Freight: " + totalFreight); _employees = new List <IEmployee>(); foreach (DataRow row in _employeeTable.Tables[0].Rows) { var employee = CheckManager.GetEmployee((int)row[1]); employee.Name = row[0].ToString(); _employees.Add(employee); } foreach (Employee employee in _employees) { employee.SetBonus(totalFreight); } }