using System;

using System.Collections.Generic;

using System.Linq;

​

namespace DemoCG

{

    class Emp

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public int Salary { get; set; }

        public override string ToString()

        {

            return $"Id = {Id} Name - {Name} Salary - {Salary}";

        }

    }

    class Program

    {

        static void Main(string[] args)

        {

            int[] arr = { 22, 33, 11, 88, 55, 44, 66, 99, 77 };

​

            Console.WriteLine(arr.Count());

​

            var result = arr.Where(i => i % 2 == 1);

            Console.WriteLine(string.Join(",", result));

​

            var result2 = arr.Where(i => i % 2 == 1).OrderByDescending(i => i);

            // i => i   -  don't change any value before sorting

            Console.WriteLine(string.Join(",", result2));

​

            List<Emp> emps = new List<Emp>()

            {

                new Emp{ Id=101, Name="Amit", Salary=24000 },

                new Emp{ Id=102, Name="Sumit", Salary=21000 },

                new Emp{ Id=103, Name="Aman", Salary=22000 },

            };

​

            emps.Add(new Emp { Id = 104, Name = "Rajesh", Salary = 24000 });

​

            foreach (var emp in emps)

            {

                Console.WriteLine(emp);

            }

​

            int salary = 24000;

            int id = 105;

            Emp target1 = emps.Where(e => e.Salary == salary).FirstOrDefault();

            // Where is used when multiple objects can satisfy the condition

            //Console.WriteLine(target1);

            Emp target = emps.Find(e => e.Id == id);

            // Find is used to search based on Key column

​

            List<Emp> empsWithSalaryGT24000 = emps.Where(e => e.Salary >= 24000).ToList();

            //var empsWithSalaryGT24000 = emps.Where(e => e.Salary >= 24000);

            Console.WriteLine("Emps With Salary >= 24000 - ");

            foreach (Emp e in empsWithSalaryGT24000)

            {

                Console.WriteLine(e);

            }

​

            var emps2 = emps.Where(e => e.Name.StartsWith("A")).Select(e => new { e.Id, e.Name });

            Console.WriteLine("Emps With Name Beginning with A - ");

            foreach (var emp in emps2)

            {

                Console.WriteLine($"ID - {emp.Id} Name - {emp.Name}");

            }

​

            if (target == null)

            {

                Console.WriteLine($"Emp with Id {id} is not available");

            }

            else

            {

                Console.WriteLine($"Name of Emp with Id {id} is {target.Name}");

            }

​

​

            if (target1 == null)

            {

                Console.WriteLine($"Emp with Salary {salary} is not available");

            }

            else

            {

                Console.WriteLine($"Name of first Emp with Salary {salary} is {target1.Name}");

            }

​

            Console.WriteLine("Done");

​

        }

    }

}

​