void GenerateCodeFromCSV()
{
var source = @"C:\Users\Kaveh\Downloads\City_of_Iran.csv";
var destination = @"C:\Users\Kaveh\Downloads\code.txt";
using (var csvFile = new Microsoft.VisualBasic.FileIO.TextFieldParser(source, Encoding.UTF8))
using (var code = new System.IO.StreamWriter(destination, false, Encoding.UTF8))
{
foreach (var rec in csvFile.Records())
{
try
{
code.WriteLine(
"yield return new Models.Location {{ Name = \"{0}\", Longitude = \"{1}\", Latitude = \"{2}\", Timezone = \"-3:30\", DST = \"0\" }};"
, rec[2].Replace(";", string.Empty).Replace("-", string.Empty).Trim()
, TimeSpan.FromHours(double.Parse(rec[0])).ShowAsDegree()
, TimeSpan.FromHours(double.Parse(rec[1])).ShowAsDegree());
}
catch { }
}
code.Flush();
}
}
public static IEnumerable <string[]> Records(this Microsoft.VisualBasic.FileIO.TextFieldParser csv)
{
return(csv.Records(true));
}