Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- List<Customers> cust = new List<Customers>();
- cust.Add(new Customers(){ID=1, Name="Sam", PurchaseDate=DateTime.Parse("01/12/2008")});
- cust.Add(new Customers(){ID=2, Name="Lolly" PurchaseDate=DateTime.Parse("03/18/2008")});
- var groupByYear = customers.GroupBy(customer => customer.PurchaseDate.Year);
- foreach (var group in groupByYear)
- {
- Console.WriteLine("Year: {0}", group.Key);
- foreach (var customer in group)
- {
- Console.WriteLine("{0}: {1}", customer.ID, customer.Name);
- }
- }
- var groupByYearMonth = customers.GroupBy(customer =>
- new DateTime(customer.PurchaseDate.Year, customer.PurchaseDate.Month, 1));
- foreach (var group in groupByYear)
- {
- Console.WriteLine("Year/month: {0}/{1}", group.Key.Year, group.Key.Month);
- foreach (var customer in group)
- {
- Console.WriteLine("{0}: {1}", customer.ID, customer.Name);
- }
- }
- var ordered = customers.OrderBy(customer => customer.PurchaseDate.Year);
- int total = customer.Count()
- var counts = customers.GroupBy( c => c.Status )
- .Select( g => new
- {
- Status = g.Key,
- TheRatio = (g.Count() * 100) / total;
- })
Add Comment
Please, Sign In to add comment