Filter list by another list using Linq in ASP.Net

Hi dilipsharm,

Refer below sample code.

C#

protected void Page_Load(object sender, EventArgs e)
{
    List<CitiesPair> citiesPairs = CitiesPairList();
    List<Cities> customersList = CitiesList();
    IEnumerable<Cities> FinalResult = customersList.Where(x => citiesPairs.Any(y => x.CityID == y.OriginId && x.CityID == y.DetinationId));
    List<Cities> asList = FinalResult.ToList();
}

private List<Cities> CitiesList()
{
    List<Cities> cities = new List<Cities>();
    cities.Add(new Cities { CityID = "1", CityName = "Mumbai" });
    cities.Add(new Cities { CityID = "2", CityName = "Delhi" });
    cities.Add(new Cities { CityID = "3", CityName = "Hyderabad" });
    cities.Add(new Cities { CityID = "4", CityName = "Odisha" });

    return cities;
}

private List<CitiesPair> CitiesPairList()
{
    List<CitiesPair> citiesPair = new List<CitiesPair>();
    citiesPair.Add(new CitiesPair { OriginId = "1", DetinationId = "1", OpratorCode = "Mumbai" });
    citiesPair.Add(new CitiesPair { OriginId = "2", DetinationId = "2", OpratorCode = "Delhi" });
    citiesPair.Add(new CitiesPair { OriginId = "3", DetinationId = "4", OpratorCode = "Hyderabad" });
    citiesPair.Add(new CitiesPair { OriginId = "4", DetinationId = "3", OpratorCode = "Odisha" });

    return citiesPair;
}

public class Cities
{
    public string CityID { get; set; }
    public string CityName { get; set; }
}

public class CitiesPair
{
    public string OriginId { get; set; }
    public string DetinationId { get; set; }
    public string OpratorCode { get; set; }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim citiesPairs As List(Of CitiesPair) = CitiesPairList()
    Dim customersList As List(Of Cities) = CitiesList()
    Dim FinalResult As IEnumerable(Of Cities) = customersList _
                                                .Where(Function(x) citiesPairs.Any(Function(y) x.CityID = y.OriginId AndAlso x.CityID = y.DetinationId))
    Dim asList As List(Of Cities) = FinalResult.ToList()
End Sub

Private Function CitiesList() As List(Of Cities)
    Dim cities As List(Of Cities) = New List(Of Cities)()
    cities.Add(New Cities With {.CityID = "1", .CityName = "Mumbai"})
    cities.Add(New Cities With {.CityID = "2", .CityName = "Delhi"})
    cities.Add(New Cities With {.CityID = "3", .CityName = "Hyderabad"})
    cities.Add(New Cities With {.CityID = "4", .CityName = "Odisha"})
    Return cities
End Function

Private Function CitiesPairList() As List(Of CitiesPair)
    Dim citiesPair As List(Of CitiesPair) = New List(Of CitiesPair)()
    citiesPair.Add(New CitiesPair With {.OriginId = "1", .DetinationId = "1", .OpratorCode = "Mumbai"})
    citiesPair.Add(New CitiesPair With {.OriginId = "2", .DetinationId = "2", .OpratorCode = "Delhi"})
    citiesPair.Add(New CitiesPair With {.OriginId = "3", .DetinationId = "4", .OpratorCode = "Hyderabad"})
    citiesPair.Add(New CitiesPair With {.OriginId = "4", .DetinationId = "3", .OpratorCode = "Odisha"})
    Return citiesPair
End Function

Public Class Cities
    Public Property CityID As String
    Public Property CityName As String
End Class

Public Class CitiesPair
    Public Property OriginId As String
    Public Property DetinationId As String
    Public Property OpratorCode As String
End Class