コード例 #1
0
ファイル: Program.cs プロジェクト: Elisa758/Projet3_New
        static List <County> GenerateCounty(District district, int numbreOfCounty)
        {
            List <County> counties = new List <County>();

            for (int i = 1; i <= numbreOfCounty; i++)
            {
                var newCounty = new County();
                newCounty.Name     = "county" + i;
                newCounty.District = district;
                //newCounty.Cities = GenerateCity(newCounty,2);

                counties.Add(newCounty);
            }
            return(counties);
        }
コード例 #2
0
ファイル: Filter.cs プロジェクト: Elisa758/Projet3_New
        public static void FilterByCounty(County county)
        {
            using (var context = new ShopContext())
            {
                var shopList = from s in context.Shops
                               join c in context.City
                               on s.City.CityId equals c.CityId
                               join co in context.County
                               on c.County.CountyId equals co.CountyId
                               where co.CountyId == county.CountyId
                               select new { CountyName = co.Name, c.Name, s.ShopId, shopName = s.Name };

                foreach (var Shop in shopList)
                {
                    Console.WriteLine(Shop);
                }
            }
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: Elisa758/Projet3_New
        static List <City> GenerateCity(County county, int numbreOfCities)
        {
            List <City> cities = new List <City>();

            for (int i = 1; i <= numbreOfCities; i++)
            {
                var newCity = new City();
                newCity.Name   = "city" + i;
                newCity.County = county;
                Random random  = new Random();
                int    zipcode = random.Next(10000, 99999);
                newCity.ZipCode = zipcode;
                //newCity.Shops = GenerateShop(newCity, 1);

                cities.Add(newCity);
            }
            return(cities);
        }
コード例 #4
0
ファイル: Program.cs プロジェクト: Elisa758/Projet3_New
        public static List <City> GetCityList(County county)
        {
            using (var context = new ShopContext())
            {
                List <City> cities = new List <City>();

                var citiesList = from c in context.City.AsEnumerable()
                                 where c.County.CountyId == county.CountyId
                                 select c;
                cities.AddRange(citiesList);

                /*foreach (var District in france.Districts)
                 * {
                 *  foreach (var County in District.Counties)
                 *  {
                 *      foreach (var city in County.Cities)
                 *      {
                 *          cities.Add(city);
                 *      }
                 *  }
                 * }*/
                return(cities);
            }
        }