c-sharp-and-csvs

c-sharp-and-csvs-1.cs

foreach (var salesRep in salesReps)
{
    var summary = new SalesSummary { SalesRep = salesRep };


    var repTransactions = transactions.Where(x => x.SalesRep == salesRep);


    summary.Y2DSold = repTransactions.Where(x => x.Date >= new DateTime(dateTimeNow.Year, 1, 1))
                            .Select(x => CalculateTransaction(x))
                            .Sum();


    summary.M2DSold = repTransactions.Where(x => x.Date >= new DateTime(dateTimeNow.Year, dateTimeNow.Month, 1))
                            .Select(x => CalculateTransaction(x))
                            .Sum();


    summary.Q2DSold = repTransactions.Where(x => GetQuarter(x.Date) == GetQuarter(dateTimeNow))
                            .Select(x => CalculateTransaction(x))
                            .Sum();


    summary.I2DSold = repTransactions
                            .Select(x => CalculateTransaction(x))
                            .Sum();


    salesSummaries.Add(summary);
}