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(); * } */ }