using System;
using System.Collections;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
//csc LINQ_local_remote1.cs
namespace ConsoleApplication2
{
    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; }
        ArrayList list = new ArrayList();
        public List<ObjectFacotry> cEmp()
        {
            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},
            };
        }
        
    }

    class Program
    {
        static void Main(string[] args)
        {
            
             ObjectFacotry of1 = new ObjectFacotry(); 
            List<ObjectFacotry> empdb = getEmp();
            List<ObjectFacotry> empdb2 = of1.cEmp();
            Console.WriteLine("-----List<ObjectFacotry> empdb2 = of1.cEmp()------------");
            Console.WriteLine(" ID " + "  Ename " + "    job " + "  \t    Manager" + "   hire-date" + "  sal  " + " Comm " + " deptno "); 
           foreach(var v1 in of1.cEmp())
           {
               Console.WriteLine(v1.empno + " : " + v1.ename + " :"
                    + v1.job + " : \t" + v1.manager + " :\t" + v1.hiredate
                    + " :" + v1.sal + " :" + v1.Comm + " : " + v1.deptno);
           }
            int n2 = getEmp().Count();
            Console.WriteLine("-----------------");
            IEnumerable<ObjectFacotry> query1 = empdb.OrderBy(emp => emp.ename);
             Console.WriteLine("---Local Function Call to Remote class -----"); 
            Console.WriteLine("---- List<ObjectFacotry> empdb = getEmp();----");
            foreach (var query in query1)
            {
                   Console.WriteLine(query.empno + " : " + query.ename + " :"
                    + query.job + " : \t" + query.manager + " :\t" + query.hiredate
                    + " :" + query.sal + " :" + query.Comm + " : " + query.deptno);
            }

            Console.ReadLine();
        }
        static List<ObjectFacotry> getEmp()
        {
           Console.WriteLine("-- Entering Local :  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},
            };
        }
    }
}