Filter records based on another list in ASP.Net using Linq

mahesh21...

SOLVED CLOSED ACTIVE ANSWERED
User: mahesh213
Posted: on Apr 02, 2022 12:24 AM
Forum: Data Controls
Answer: 1
Views: 1622

HI,

I have one complex object class that contains multiple values.

my requirement is that based need to filter the records based upon.

List<int> CustomerIds and add that data to another variable if any one of Customerid matches for each row

public List<Employee> EmployeeDetails()
{ 
    List<int> customersId =new List<int> { 1,4};
    List<Employee> employees = new List<Employee>();
 
    Employee e1 = new Employee()
    {
        Id = 1,
        Name = "aa",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=2,CustomerName="Cus2"},
            new Customer(){ CustomerId=3,CustomerName="Cus3"},
            new Customer(){ CustomerId=4,CustomerName="Cus4"},
            new Customer(){ CustomerId=5,CustomerName="Cus5"}
 
        }
    };
    Employee e2 = new Employee()
    {
        Id = 2,
        Name = "bb",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=2,CustomerName="Cus1"},
             new Customer(){ CustomerId=3,CustomerName="Cus3"},
 
        }
    };
    Employee e3 = new Employee()
    {
        Id = 4,
        Name = "dd",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=1,CustomerName="Cus1"},
            new Customer(){ CustomerId=2,CustomerName="Cus2"},
            new Customer(){ CustomerId=4,CustomerName="Cus4"},
 
        }
    };
    Employee e4 = new Employee()
    {
        Id = 3,
        Name = "cc",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=3,CustomerName="Cus3"},
            new Customer(){ CustomerId=5,CustomerName="Cus5"},
 
        }
    };
 
    employees.Add(e1);
 
    employees.Add(e2);
    employees.Add(e3);
    employees.Add(e4);
 
 
    //need to filter records based upon customersId varaible and bind that data to filtersdata varible
    //if CustomersId exists(anyone on each row) then add that row to filtersdata
    List<Employee> filtersdata;
 
    return employees;
}

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public List<Customer> customers { get; set; }
}
public class Customer
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Apr 02, 2022 07:03 AM
Modified: on Apr 04, 2022 12:58 AM
Report

Hi mahesh213,

Refer below code.

protected void Page_Load(object sender, EventArgs e)
{
    EmployeeDetails();
}

public List<Employee> EmployeeDetails()
{
    List<int> customersId = new List<int> { 1, 4 };
    List<Employee> employees = new List<Employee>();
    Employee e1 = new Employee()
    {
        Id = 1,
        Name = "aa",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=2,CustomerName="Cus2"},
            new Customer(){ CustomerId=3,CustomerName="Cus3"},
            new Customer(){ CustomerId=4,CustomerName="Cus4"},
            new Customer(){ CustomerId=5,CustomerName="Cus5"}
        }
    };
    Employee e2 = new Employee()
    {
        Id = 2,
        Name = "bb",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=2,CustomerName="Cus1"},
            new Customer(){ CustomerId=3,CustomerName="Cus3"}
        }
    };
    Employee e3 = new Employee()
    {
        Id = 4,
        Name = "dd",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=1,CustomerName="Cus1"},
            new Customer(){ CustomerId=2,CustomerName="Cus2"},
            new Customer(){ CustomerId=4,CustomerName="Cus4"}
        }
    };
    Employee e4 = new Employee()
    {
        Id = 3,
        Name = "cc",
        customers = new List<Customer>()
        {
            new Customer(){ CustomerId=3,CustomerName="Cus3"},
            new Customer(){ CustomerId=5,CustomerName="Cus5"}
        }
    };

    employees.Add(e1);
    employees.Add(e2);
    employees.Add(e3);
    employees.Add(e4);

    List<Employee> filtersdata = new List<Employee>();
    foreach (Employee employee in employees)
    {
        if (employee.customers.Where(e => customersId.Any(c => c == e.CustomerId)).ToList().Count > 0)
        {
            employee.customers = employee.customers.Where(e => customersId.Any(c => c == e.CustomerId)).ToList();
            filtersdata.Add(employee);
        }
    }

    return filtersdata;
}

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public List<Customer> customers { get; set; }
}

public class Customer
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Filter records based on another list in ASP.Net using Linq

Company

Explore

Follow us

Contact Us