public City searchForAmenities(string Amenity, City inCity)
        {
            //Check if amenity is Park or School and then return list from that City

            //Or should searchForAmenities be something you call on a city like city.searchForAmenity()
            //instead of passing in the city?
            return null;
        }
 public TrainStation(double Lat, double Long, string tsName)
     : base(Lat, Long, tsName)
 {
     this.city = null;
     this.wheelchairFriendly = true;
     this.taxiRank = true;
     this.carPark = true;
 }
 public void addLocation(Location venue, City toCity)
 {
     //look up the City database and add the location to the city
     /*
     if (venue is School)
     {
         toCity.schools.Add((School)venue);
         ((School)venue).city = toCity;
     }
     else if (venue is Hospital)
     {
         toCity.hospitals.Add((Hospital)venue);
         ((Hospital)venue).city = toCity;
     }
     else
     {
         toCity.venues.Add(venue);
     }
      * */
 }
        public bool addCityToDb(City c)
        {
            City inc = new City();
            try
            {

                inc = db.cities.Add(c);
            }

            catch (Exception e)
            {
                Exception j = e;
                return false;
                //do something
            }

            if (inc is City)
            {
                db.SaveChanges();
                return true;
            }
            return false;
        }
 public City deleteLocation(Location venue, City fromCity)
 {
     return null;
 }
 public bool updateCityInDb(City c)
 {
     db.Entry(c).State = EntityState.Modified;
     try
     {
         db.SaveChanges();
         return true;
     }
     catch (Exception e)
     {
         // do something
         return false;
     }
 }
        public BuildCities()
        {
            // list of all museums in dB
            // list of all other venues to follow
            List<Museum> ms = new List<Museum>();
            List<Park> ps = new List<Park>();
            // temporary list of cities
            List<City> cs = new List<City>();
            MuseumDAL mDal = new MuseumDAL();
            ParkDAL pDal = new ParkDAL();

            ms = mDal.getAllMuseumsFromDb();

            foreach (Museum m in ms)
            {
                bool notFound = true;
                foreach (City c in cs)
                {
                    if (m.cityStr.Equals(c.lname))
                    {
                        // Add museum to list of this city's museums
                        c.museums.Add(m);
                        notFound = false;
                        break;
                    }
                }
                if (notFound)
                {
                    City addCity = new City();
                    addCity.lname = m.cityStr;
                    addCity.latitude = m.latitude;
                    addCity.longitude = m.longitude;
                    // Add museum to list of this city's museums
                    //addCity.museums = new List<Museum>();
                    addCity.museums.Add(m);
                    cs.Add(addCity);
                }
            }

            // Do this again for each other venue
            ps = pDal.getAllParksFromDb();
            foreach (Park p in ps)
            {
                bool notFound = true;
                foreach (City c in cs)
                {
                    if (p.cityStr.Equals(c.lname))
                    {
                        // Add museum to list of this city's museums
                        c.parks.Add(p);
                        notFound = false;
                        break;
                    }
                }
                if (notFound)
                {
                    City addCity = new City();
                    addCity.lname = p.cityStr;
                    addCity.latitude = 79.0;
                    addCity.longitude = 79.0;
                    // Add museum to list of this city's museums
                    //addCity.museums = new List<Museum>();
                    addCity.parks.Add(p);
                    cs.Add(addCity);
                }
            }

            // We have created our temporary list of cities, now add them to the dB
            CitiesDAL cDal = new CitiesDAL();
            List<City> lCitiesInDB = new List<City>();
            lCitiesInDB = cDal.getAllCitiesFromDb();
            bool result = false, notIndB = true;
            foreach (City c in cs)
            {
                foreach (City dcb in lCitiesInDB)
                {
                    if (dcb.lname.Equals(c.lname))
                    {
                        notIndB = false;
                        break;
                    }
                }
                if (notIndB)
                {
                    result = cDal.addCityToDb(c);
                    if (result.Equals(false))
                    {
                        //do something
                    }
                }
                notIndB = true;
                // see if it has an id now
            }
        }