private void addParksFiletoDB()
{
List<Park> pList = csvr.getCSVFileDataParks();
ParkDAL pDAL = new ParkDAL();
// Get all the Parks already in the dB and compare to this list
// Add any in this list that aren't in the dB
// Update any in this list that are already in the dB
List<Park> dbpList = pDAL.getAllParksFromDb();
bool result = false, notIndB = true;
// stick it in the dB
foreach (Park p in pList)
{
foreach (Park dbp in dbpList)
{
if (dbp.lname.Equals(p.lname))
{
notIndB = false;
break;
}
}
if (notIndB)
{
// Add to the dB
// we could bother to check the result
result = pDAL.addParkToDb(p);
}
else
{
// Update the record in the dB (assuming structure the same)
// I think we change every field in the dbp that could have changed
// and then call pDAL.updateParkInDb(dbp)
}
}
}
public ActionResult Index()
{
List<City> cList = new List<City>();
CitiesDAL cDal = new CitiesDAL();
List<Museum> mList = new List<Museum>();
MuseumDAL mDal = new MuseumDAL();
List<Park> pList = new List<Park>();
ParkDAL pDal = new ParkDAL();
List<Market> mkList = new List<Market>();
MarketDAL mkDal = new MarketDAL();
cList = cDal.getAllCitiesFromDb(true);
mList = mDal.getAllMuseumsFromDb(true);
pList = pDal.getAllParksFromDb(true);
mkList = mkDal.getAllMarketsFromDb(true);
//System.Web.Script.Serialization.JavaScriptSerializer oSerializer =
//new System.Web.Script.Serialization.JavaScriptSerializer();
//string sJSON = oSerializer.Serialize(cList);
var serializerSettings = new JsonSerializerSettings { PreserveReferencesHandling = PreserveReferencesHandling.Objects };
string cjson = JsonConvert.SerializeObject(cList, Formatting.Indented, serializerSettings);
string mjson = JsonConvert.SerializeObject(mList, Formatting.Indented, serializerSettings);
string pjson = JsonConvert.SerializeObject(pList, Formatting.Indented, serializerSettings);
string mkjson = JsonConvert.SerializeObject(mkList, Formatting.Indented, serializerSettings);
//string sjson2 = JsonConvert.ToString(cList[0]);
ViewData["Cities"] = cjson;
ViewData["Museums"] = mjson;
ViewData["Parks"] = pjson;
ViewData["Markets"] = mkjson;
return View(cList);
}
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
}
}