public static string CsvWriter(string path)
{
var doubleTypeConversion = new DoubleConversion();
IList <CityModel> myList = ReadCsv.ReadCsvFile <CityModel, CityMap>(path, doubleTypeConversion);
var countryCapitalQueryAdmin = from s in myList
where s.Capital.Equals("admin")
orderby s.Country ascending
select s;
// Hello
foreach (CityModel city in countryCapitalQueryAdmin)
{
Debug.Write(city.Country + ": " + city.City_name + Environment.NewLine);
}
var queryName = nameof(countryCapitalQueryAdmin);
var writePath = "c://csvfiles//" + queryName + ".csv";
using (var writer = new StreamWriter(writePath))
using (var csv = new CsvWriter(writer))
{
csv.WriteRecords(countryCapitalQueryAdmin);
}
return(writePath);
}
public void ReadCsvFileTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
IList <CityModelImport> myList = ReadCsv.ReadCsvFile <CityModelImport, CityMap>(path, doubleTypeConversion);
Assert.AreEqual(15493, myList.Count());
}
public void ReadCsvTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
myList = ReadCsv.ReadCsvFile <CitiesImportModel, CityMap>(path, doubleTypeConversion);
Assert.IsNotNull(myList);
}
public void WriteCsvFileTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
var myList = ReadCsv.ReadCsvFile <CitiesImportModel, CityMap>(path, doubleTypeConversion);
var writeName = "Output1";
var writePath = "c://csvfiles//" + writeName + ".csv";
writecsv.WriteCsvFile <CitiesImportModel>(myList, writeName);
Assert.IsTrue(File.Exists(writePath));
}
public void ReadInCSVTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
IList <CityModel> myList = ReadCsv.ReadCsvFile <CityModel, CityMap>(path, doubleTypeConversion);
var countryCapitalQuery = from s in myList
where s.Capital.Equals("primary")
orderby s.Country ascending
select s;
// SOme Update
foreach (CityModel 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();
Debug.Write(QSCount);
Assert.AreEqual(15493, myList.Count());
// countryQuery = records.Where(city => city.Country.Equals("United States"));
/*
* foreach (CityModel city in countryQuery)
* {
* var name = city.City_name.ToString();
* }
*/
}
public static string CsvWrite(string path)
{
var doubleTypeConversion = new DoubleConversion();
IList <CityModelImport> myList = ReadCsv.ReadCsvFile <CityModelImport, CityMap>(path, doubleTypeConversion);
var countryCapitalQueryprimary = (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(countryCapitalQueryprimary);
var writePath = "c://csvfiles//" + queryName + ".csv";
using (var writer = new StreamWriter(writePath))
using (var csv = new CsvWriter(writer))
{
csv.WriteRecords(countryCapitalQueryprimary);
}
return(writePath);
}
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();
* }
*/
}
public void ReadInCSVTest()
{
var path = "c://csvfiles//worldcities.csv";
var doubleTypeConversion = new DoubleConversion();
IList <CityModelImport> myList = ReadCsv.ReadCsvFile <CityModelImport, CityMap>(path, doubleTypeConversion);
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())
//{
// 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();
* }
*/
}
