E Marketing website in asp net MVC C# part 3

Click here to download the project

E Marketing website in asp net MVC C# part 3

Click here to download the source code

Hr management system part 4 (asp.net c#)

CLICK HERE TO DOWNLOAD THE SOURCE CODE

E Marketing website in asp net MVC C# part 2

Click here to download the source code

HR management system part 3

click here to download the source code

Select ,Any and All operator in Linq C#

using ConsoleApplication3.Model;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;



namespace ConsoleApplication3

{

    class Program

    {

        static void Main(string[] args)

        {





            List<Employee> li = new List<Employee>()

        {

            new Employee{id=1,name="Ali",salary=50000},

           new Employee{id=2,name="Ahmed",salary=30000},

          new Employee{id=3,name="Ahsan",salary=50000},

          new Employee{id=4,name="Asim",salary=40000},

          new Employee{id=5,name="Asad",salary=10000},





        };



        //  var  list = li.Select(x => new { ID = x.id, Name = x.name });

            //var list = li.ToList();







            //foreach (var item in list)

            //{

            //    Console.WriteLine("ID: " + item.id + "\nName" + item.name);

            //}



            //bool a = li.All(x => x.salary >= 10000);

            bool b = li.Any(x => x.salary > 30000);



            Console.WriteLine(b);







       

        }

    }

}

-----------------------------------------------------------------------------------------------

 class Employee

    {

        public int id { get; set; }

        public string name { get; set; }

        public int salary { get; set; }

    }

Join Query in Linq C#

using ConsoleApplication2.Model;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;



namespace ConsoleApplication2

{

    class Program

    {

        static void Main(string[] args)

        {

            List<department> deplist = new List<department>

            {

                new department{deptid=1, deptname="HR"},

                new department{deptid=2, deptname="Marketing"},

                new department{deptid=3, deptname="IT"},

                new department{deptid=4, deptname="Accounts"},



            };



            List<Employee> emplist = new List<Employee>

            {

                new Employee{empid=101,name="ali",deptfkid=1},

                new Employee{empid=102,name="ahmed",deptfkid=2},

               new Employee{empid=103,name="ahsan",deptfkid=1},

               new Employee{empid=104,name="bilal",deptfkid=3},

               new Employee{empid=105,name="zahid",deptfkid=1},

                new Employee{empid=106,name="fahad",deptfkid=2},







            };





            var joinlist = emplist.Join(deplist, emp => emp.deptfkid, dep => dep.deptid, (emp, dep) => new

            {

                empid=emp.empid,

                name=emp.name,

                deptname=dep.deptname

           

            });



           



            foreach (var item in joinlist)

            {

                Console.WriteLine("-------------------");



                Console.WriteLine("id: "+item.empid);

                Console.WriteLine("Name: " + item.name);

                Console.WriteLine("Department: " + item.deptname);



                Console.WriteLine("-------------------");



            }



            Console.ReadKey();





        }

    }

}

----------------------------------------------------------------------------------------------------

 class department

    {

        public int deptid { get; set; }

        public string deptname { get; set; }

    }

-----------------------------------------------------------------------------------------------

 class Employee

    {

        public int  empid { get; set; }

        public string name { get; set; }

        public int deptfkid { get; set; }

    }