using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
//csc LINQ_Where_OrderBy1.cs
namespace ConsoleApplication1
{
    class ObjectFacotry
    {
        public int empno { get; set; }// Properties
        public String ename { get; set; }
        public String job { get; set; }
        public int manager { get; set; }
        public String hiredate { get; set; }
        public double sal { get; set; }
        public double Comm { get; set; }
        public int deptno { get; set; }
    }

    class Program
    {
        static void Main(string[] args)
        {
            //var  elist = new List<ObjectFacotry>();
            Console.WriteLine(" empno " + "ename " + "  deptno  " + " job " +"  sal");
            var elist = getEmp();
            IEnumerable<ObjectFacotry> edb = 
                from e in elist where e.job.Contains("CLERK")  select e ; 
            //
            foreach (ObjectFacotry e1 in edb)
            {
                Console.WriteLine(e1.empno + " :"  + e1.ename + "  :  " + e1.deptno + " : "+ e1.job + " : " + e1.sal); 
            }
            Console.WriteLine("---");
            //
            List<ObjectFacotry> empdb = getEmp();
            IEnumerable<ObjectFacotry> query1 = 
                empdb.Where(emp => emp.job.Contains("CLERK")).OrderBy(e=>e.ename);
            Console.WriteLine(" ID " + "  Ename " + "    job " + "  \t    Manager" + "   hire-date" + "  sal  " + " Comm " + " deptno ");
            foreach (ObjectFacotry query in query1)
            {
                Console.WriteLine(query.empno + " : " + query.ename + " :"
                    + query.job + " : \t" + query.manager + " :\t" + query.hiredate
                    + " :" + query.sal + " :" + query.Comm + " : " + query.deptno);
            }
           

    
            //Console.Write(objList);
            Console.ReadLine();
        }
        static List<ObjectFacotry> getEmp()
        {
            return new List<ObjectFacotry>
            {
               

new ObjectFacotry  {  empno =7369, 	ename="SMITH  ", job="CLERK  " ,	manager= 7902, 	hiredate="1980-12-17",sal = 800 ,Comm=	00.00 , deptno= 20},
new ObjectFacotry  {  empno =7499, 	ename="ALLEN  ", 	job="SALESMAN", manager= 7698, 	hiredate="1981-02-20",sal = 1600 ,Comm=	300.00 , deptno=30},
new ObjectFacotry  {  empno =7521, 	ename="WARD   ",	job="SALESMAN", manager= 7698, 	hiredate="1981-02-22",sal = 1250 ,Comm=	500.00 , deptno=30},
new ObjectFacotry  {  empno =7566, 	ename="JONES  ",	job="MANAGER ",	manager= 7839, 	hiredate="1981-04-02",sal = 2975 ,Comm=	 00.00 , deptno=20},
new ObjectFacotry  {  empno =7654, 	ename="MARTIN  ", job="SALESMAN", manager= 7698, 	hiredate="1981-09-28",sal = 1250 ,Comm=	1400.00 , deptno=30},
new ObjectFacotry  {  empno =7698, 	ename="BLAKE   ", job="MANAGER ", 	manager= 7839, 	hiredate="1981-01-05",sal = 2850 ,Comm=	 00.00	, deptno= 30},
new ObjectFacotry  {  empno =7782, 	ename="CLARK   ", job="MANAGER ", 	manager= 7839, 	hiredate="1981-06-09",sal = 2450 ,Comm=	  00.00, deptno=10},
new ObjectFacotry  {  empno =7788, 	ename="SCOTT  ", 	job="ANALYST ", manager= 7566, 	hiredate="1987-04-19",sal = 3000 ,Comm=	  00.00	, deptno=20},
new ObjectFacotry  {  empno =7839, 	ename="KING    ", 	job="PRESIDENT",manager= 0000,	hiredate="1981-11-17",sal = 5000 ,Comm=	  00.00	, deptno=10},
new ObjectFacotry  {  empno =7844, 	ename="TURNER  ",	job="SALESMAN", manager= 7698, 	hiredate="1981-09-08",sal = 1500 ,Comm=	00.00	, deptno=30},
new ObjectFacotry  {  empno =7876, 	ename="ADAMS   ", 	job="CLERK" ,	manager= 7788, 	hiredate="1984-07-13",sal = 1100 ,Comm=	00.00  , deptno= 20},
new ObjectFacotry  {  empno =7900, 	ename="JAMES   ", 	job="CLERK",	manager= 7698, 	hiredate="1981-06-09",sal = 950 ,Comm= 00.00	, deptno=30},
new ObjectFacotry  {  empno =7902, 	ename="FORD    ", 	job="ANALYST", 	manager= 7566, 	hiredate="1981-12-03",sal = 3000 ,Comm=	 00.00 	, deptno=20},
new ObjectFacotry  {  empno =7934, 	ename="MILLER  ", job="CLERK" ,	manager= 7782, 	hiredate="1982-01-23",sal= 1300 ,Comm=	00.00  , deptno= 10},
            };
        }
    }
}