using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

​

namespace Group

{

​

    public class Employee

    {

        public int ID { get; set; }

        public string Name { get; set; }

        public string Gender { get; set; }

        public string Department { get; set; }

        public int Salary { get; set; }

​

        public static List<Employee> GetAllEmployees()

        {

            return new List<Employee>()

        {

            new Employee { ID = 1, Name = "Mark", Gender = "Male",

                                         Department = "IT", Salary = 45000 },

            new Employee { ID = 2, Name = "Steve", Gender = "Male",

                                         Department = "HR", Salary = 55000 },

            new Employee { ID = 3, Name = "Ben", Gender = "Male",

                                         Department = "IT", Salary = 65000 },

            new Employee { ID = 4, Name = "Philip", Gender = "Male",

                                         Department = "IT", Salary = 55000 },

            new Employee { ID = 5, Name = "Mary", Gender = "Female",

                                         Department = "HR", Salary = 48000 },

            new Employee { ID = 6, Name = "Valarie", Gender = "Female",

                                         Department = "HR", Salary = 70000 },

            new Employee { ID = 7, Name = "John", Gender = "Male",

                                         Department = "IT", Salary = 64000 },

            new Employee { ID = 8, Name = "Pam", Gender = "Female",

                                         Department = "IT", Salary = 54000 },

            new Employee { ID = 9, Name = "Stacey", Gender = "Female",

                                         Department = "HR", Salary = 84000 },

            new Employee { ID = 10, Name = "Andy", Gender = "Male",

                                         Department = "IT", Salary = 36000 }

        };

        }

    }

   public class Program

    {

        public static void Main(string[] args)

        {

           var departments1= Employee.GetAllEmployees().GroupBy(d => d.Department);

            /*var employeeGroup = from employee in Employee.GetAllEmployees()

            group employee by employee.Department;*/

​

            foreach (var department in departments1)

            {

                Console.WriteLine(department.Key +"--"+department.Count());

                foreach (var employee in department)

                {

​

​

                    Console.WriteLine("\t" + employee.Name+"\t"+employee.Gender);

                }

​

            }

            Console.WriteLine(  "\n---------------Group by department oderBy Ascending Order-----------------");

            var department1 = Employee.GetAllEmployees().OrderBy(y => y.Department).ThenBy(z=>z.Name).GroupBy(x => x.Department);

            foreach (var department in department1)

            {

                Console.WriteLine(department.Key + "--" + department.Count());

                foreach (var employee in department)

                {

​

​

                    Console.WriteLine("\t" + employee.Name + "\t" + employee.Gender);

                }

​

            }

            Console.ReadKey();

        }

    }

}

​