private void Routes()
{
FileHelpers.FileHelperAsyncEngine<BigDataData.Csv.Route> engine = new FileHelpers.FileHelperAsyncEngine<BigDataData.Csv.Route>();
List<BigDataData.Models.Route> routes = new List<BigDataData.Models.Route>();
try
{
int h = 0;
int i = 0;
foreach (BigDataData.Csv.Route air in engine)
{
BigDataData.Models.Route route = new BigDataData.Models.Route
{
Airline = air.Airline,
AirlineId = air.AirlineId,
SourceAirport = air.SourceAirport,
SourceAirportId = air.SourceAirportId,
DestinationAirport = air.DestinationAirport,
DestinationAirportId = air.DestinationAirportId,
Codeshare = air.Codeshare,
Stops = air.Stops,
Equipment = air.Equipment
};
routes.Add(route);
if (h < 249)
{
h++;
}
else
{
h = 0;
SaveRoutes(routes);
routes.Clear();
Console.WriteLine(i);
}
i++;
}
SaveRoutes(routes);
routes.Clear();
Console.WriteLine(i);
}
catch (Exception eek)
{
Console.WriteLine("Save error: {0}", eek.Message);
}
}
private void dataWorker_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker bw = sender as BackgroundWorker;
if (bw.CancellationPending)
{
e.Cancel = true;
}
records = new List <TenykobRecord>();
FileHelpers.FileHelperAsyncEngine <TenykobRecord> engine = new FileHelpers.FileHelperAsyncEngine <TenykobRecord>();
engine.Options.IgnoreFirstLines = 1;
// Read
using (engine.BeginReadFile(filename))
{
// The engine is IEnumerable
int cnt = 0;
foreach (TenykobRecord cust in engine)
{
records.Add(cust);
}
}
}
