public void ReadInCSVTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
IList <CityModelImport> myList = ReadCsv.ReadCsvFile <CityModelImport, CityMap>(path, doubleTypeConversion);
var countryCapitalQuery = (from s in myList
where s.Capital.Equals("primary")
orderby s.Country ascending
select s);
/*
* foreach (CityModelImport city in countryCapitalQuery)
* {
* Debug.Write(city.Country + ": " + city.City_name + Environment.NewLine);
* }*/
var queryName = nameof(countryCapitalQuery);
var writePath = "c://csvfiles//" + queryName + ".csv";
using (var writer = new StreamWriter(writePath))
using (var csv = new CsvWriter(writer))
{
csv.WriteRecords(countryCapitalQuery);
}
Assert.IsTrue(File.Exists(writePath));
var QSCount = (from city in countryCapitalQuery
select city).Count();
CountryModel cm = new CountryModel();
cm.AddCountries <CityModelImport>(countryCapitalQuery);
//Debug.Write(QSCount);
Assert.AreEqual(15493, myList.Count());
using (var dbContext = new CitiesContext())
{
dbContext.Database.Connection.Close();
}
var countryGroups = from city in countryCapitalQuery
group city by new
{
city.Country,
city.ISO2,
city.ISO3
}
into countryGroup
orderby countryGroup.Key.Country
select countryGroup;
//using (var db = new CitiesContext())
// DBConn conn = new DBConn();
// var db=conn.conn();
var db = DBConn.conn();
using (db)
{
foreach (var country in countryGroups)
{
var countryName = country.Key.Country;
var ISO2 = country.Key.ISO2;
var ISO3 = country.Key.ISO3;
var CountryEntity = new CountryEntity
{
Name = countryName,
ISO2 = ISO2,
ISO3 = ISO3
};
db.Countries.Add(CountryEntity);
db.SaveChanges();
int id = CountryEntity.CountryID;
Debug.Write(country);
foreach (var city in country)
{
var CityEntity = new CityEntity
{
City_name = city.City_name,
Admin_name = city.Admin_name,
City_ascii = city.City_ascii,
Lat = city.Lat,
Lng = city.Lng,
Capital = city.Capital,
CountryId = id,
Population = city.Population
};
db.Cities.Add(CityEntity);
db.SaveChanges();
}
}
}
// countryQuery = records.Where(city => city.Country.Equals("United States"));
/*
* foreach (CityModel city in countryQuery)
* {
* var name = city.City_name.ToString();
* }
*/
}