Q:

C# program to sort a list of employees based on salary in descending order and whose department is XYZ using Linq

belongs to collection: C# LINQ Programs

mahmoud2506
Save to bookmark
|
2022-05-12
|
  314 
0

C# program to sort a list of employees based on salary in descending order and whose department is XYZ using Linq

c# programming, exam questions, c# programming exam-questions,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-12
need an explanation for this answer? contact us directly to get an explanation for this answer

Program:

The source code to sort a list of employees based on salary in descending order and whose department is XYZ using Linq is given below. The given program is compiled and executed successfully on Microsoft Visual Studio.

//C# program to sort the list of employees based on 
//salary in descending order whose department is XYZ

using System;
using System.Linq;
using System.Collections.Generic;

public class Employee
{
    int ID;
    string Name;
    int Salary;
    string Department;

    public override string ToString()
    {
        return ID + " " + Name + " " + Salary + " " + Department;
    }

    static void Main(string[] args)
    {
        List<Employee> employees = new List<Employee>()
        {
             new Employee {ID=101,   Name="Amit  "    , Salary=4000,Department="ABC"},
             new Employee {ID=102,   Name="Gautam"    , Salary=6000,Department="XYZ"},
             new Employee {ID=103,   Name="Salman"    , Salary=3000,Department="ABC"},
             new Employee {ID=104,   Name="Ram   "    , Salary=2000,Department="XYZ"},
             new Employee {ID=105,   Name="Shyam "    , Salary=7000,Department="ABC"},
             new Employee {ID=106,   Name="Kishor"    , Salary=5000,Department="XYZ"},
        };


        var result = employees.Where(emp => emp.Department == "XYZ").OrderByDescending(sal => sal.Salary);


        Console.WriteLine("ID  Name  Salary  Department");
        Console.WriteLine("============================");
        foreach (Employee emp in result)
        {
            Console.WriteLine(emp.ToString());
        }
        Console.WriteLine("============================");
    }
}

Output:

ID  Name  Salary  Department
============================
102 Gautam 6000 XYZ
106 Kishor 5000 XYZ
104 Ram    2000 XYZ
============================
Press any key to continue . . .

Explanation:

In the above program, we created a class Demo that contains the Main() method. In the Main() method we created a list of employees with fields ID, Name, Salary, and Department.

var result = employees.Where(emp => emp.Department == "XYZ").OrderByDescending(sal => sal.Salary);

In the above code, we sorted a list of employees based on salary using OrderByDescending() in descending order and checked the department using Where() method.

Console.WriteLine("ID  Name  Salary  Department");
Console.WriteLine("============================");
foreach (Employee emp in result)
{
    Console.WriteLine(emp.ToString());
}
Console.WriteLine("============================");

In the above code, we accessed the employee detail one by one and print on the console screen.

 

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

C# LINQ Programs
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
C# program to demonstrate the example of Linq Then... >>
<< C# program to sort student names in descending ord...