private void btnFileOpen_Click(object sender, EventArgs e)
{
openFile = new OpenFileDialog();
openFile.InitialDirectory = "c:\\";
openFile.Filter = "csv files (*.csv)|*.csv";
openFile.FilterIndex = 2;
openFile.RestoreDirectory = true;
if (openFile.ShowDialog() == DialogResult.OK)
{
try
{
using (FileStream fStream = File.Open(openFile.FileName, FileMode.OpenOrCreate))
{
var csv = new CsvHelper.CsvHelper(fStream);
csv.Configuration.Delimiter = csvDelimiter.ToCharArray(0, 1)[0];
csv.Configuration.UseInvariantCulture = true;
tbFilePath.Text = openFile.FileName;
tradesList = csv.Reader.GetRecords <Trade>().ToList();
if (tradesList != null && tradesList.Count > 0)
{
btnImport.Enabled = true;
lblTradesCount.Text = tradesList.Count.ToString();
}
}
}
catch (Exception ex)
{
tbFilePath.Text = string.Empty;
MessageBox.Show("Error: Could not read file from disk. The file could be malformed or the delimiter is not properly defined. Original error: " + ex.Message);
}
}
}
public IEnumerable <T> Parse <T>(string fileName) where T : class, ISupplier
{
var csv = new CsvHelper.CsvHelper(fileSystem.File.Open(fileName, FileMode.OpenOrCreate));
var list = csv.Reader.GetRecords <T>();
return(list);
}
private static IEnumerable<Models.PostCode> GetPostCodes()
{
IEnumerable<Models.PostCode> postCodes;
using (var fileStream = File.Open("Test.csv", FileMode.Open, FileAccess.ReadWrite,FileShare.ReadWrite))
{
var csv = new CsvHelper.CsvHelper(fileStream);
csv.Configuration.ClassMapping<ReadPostCodeMap, Models.PostCode>();
postCodes = csv.Reader.GetRecords<Models.PostCode>().ToList();
}
return postCodes;
}
public List <Instrument> loadInstruments()
{
List <Instrument> instruments;
try
{
using (FileStream fStream = File.Open("instrument-list.txt", FileMode.OpenOrCreate))
{
var csv = new CsvHelper.CsvHelper(fStream);
csv.Configuration.Delimiter = ';';
csv.Configuration.UseInvariantCulture = true;
instruments = csv.Reader.GetRecords <Instrument>().ToList();
}
return(instruments);
}
catch (Exception e)
{
throw new CannotLoadInstrumentsException(string.Format("There is some problem starting application. Cannot load the instrumet list: {0}", e.Message));
}
}
public static ParseResult ParseFromCsv(string fileName)
{
var result = new ParseResult();
try
{
var csv = new CsvHelper.CsvHelper(File.OpenRead(fileName));
var records = csv.Reader.GetRecords<IngCsvRecord>();
result.Records.AddRange(records);
}
catch(FileNotFoundException)
{
result.Error = string.Format(Errors.IncorrectFile, fileName);
}
catch (Exception e)
{
result.Error = string.Format(Errors.InvalidFile, fileName, e.Message);
}
return result;
}
public static void Main(string[] args)
{
if (args.Length != 1)
{
Console.Error.WriteLine(Errors.IncorrectArguments);
}
else
{
var result = IngCsvParser.ParseFromCsv(args[0]);
if (!string.IsNullOrEmpty(result.Error))
{
Console.Error.WriteLine(result.Error);
}
else if (result.Records.Count == 0)
{
Console.Error.WriteLine(Errors.NoRecords);
}
else
{
try
{
var fullyParsed = IngCsvParser.ParseOutTransactions(result.Records);
var csv = new CsvHelper.CsvHelper(File.OpenWrite("out.csv"));
csv.Writer.WriteRecords(fullyParsed);
Console.WriteLine("Success!");
}
catch(Exception e)
{
Console.Error.WriteLine(e.ToString());
}
}
}
Console.WriteLine("Press any key to exit...");
Console.Read();
}
private static void WriteCsv(IEnumerable<Models.PostCode> postCodes)
{
var csvFile = Guid.NewGuid() + ".csv";
using (var f = File.Create(csvFile))
{
var csv = new CsvHelper.CsvHelper(f);
csv.Configuration.ClassMapping<WritePostCodeMap, Models.PostCode>();
csv.Writer.WriteRecords(postCodes);
}
}