public static List <City> GetCities() { using (RepositoryCity repositoryCity = new RepositoryCity()) { return(repositoryCity.WhereWithExplicitLoad(I => true, I => I.OrderBy(J => J.Name), paths: new string[] { "Counties" }).ToList()); } }
public List <City> GetHospitalCities() { using (RepositoryCity repositoryCity = new RepositoryCity()) { List <Hospital> hospitals = new List <Hospital>(); using (RepositoryHospital repositoryHospital = new RepositoryHospital()) { hospitals = repositoryHospital.WhereWithExplicitLoad(I => I.IsActive == true).ToList(); } List <City> cities = new List <City>(); foreach (var item in hospitals) { cities.AddRange(repositoryCity.WhereWithExplicitLoad(I => I.Name == item.City, I => I.OrderBy(J => J.Name)).ToList()); } return(cities.Distinct().ToList()); } }