code_junkie

Extract results from List<Customers> using LINQ

Nov 13th, 2011
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. List<Customers> cust = new List<Customers>();
  2. cust.Add(new Customers(){ID=1, Name="Sam", PurchaseDate=DateTime.Parse("01/12/2008")});
  3. cust.Add(new Customers(){ID=2, Name="Lolly" PurchaseDate=DateTime.Parse("03/18/2008")});
  4.  
  5. var groupByYear = customers.GroupBy(customer => customer.PurchaseDate.Year);
  6.  
  7. foreach (var group in groupByYear)
  8. {
  9. Console.WriteLine("Year: {0}", group.Key);
  10. foreach (var customer in group)
  11. {
  12. Console.WriteLine("{0}: {1}", customer.ID, customer.Name);
  13. }
  14. }
  15.  
  16. var groupByYearMonth = customers.GroupBy(customer =>
  17. new DateTime(customer.PurchaseDate.Year, customer.PurchaseDate.Month, 1));
  18. foreach (var group in groupByYear)
  19. {
  20. Console.WriteLine("Year/month: {0}/{1}", group.Key.Year, group.Key.Month);
  21. foreach (var customer in group)
  22. {
  23. Console.WriteLine("{0}: {1}", customer.ID, customer.Name);
  24. }
  25. }
  26.  
  27. var ordered = customers.OrderBy(customer => customer.PurchaseDate.Year);
  28.  
  29. int total = customer.Count()
  30.  
  31. var counts = customers.GroupBy( c => c.Status )
  32. .Select( g => new
  33. {
  34. Status = g.Key,
  35. TheRatio = (g.Count() * 100) / total;
  36. })
Add Comment
Please, Sign In to add comment