private bool ParseCSV(string filePath) { try { LogiNextParser lnp = new LogiNextParser(); lnSummary = lnp.ParseLogiNextCSV(filePath); return(true); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message, "Exception", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } }
public LogiNextDriverSummary ParseLogiNextCSV(string filePath) { LogiNextDriverSummary lnDriverSummary = new LogiNextDriverSummary(); Regex csvParserRegex = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); List <string[]> fileContents = ReaderCSV.GetFileContents(filePath); List <LogiNextTransaction> tempTransactions = new List <LogiNextTransaction>(); foreach (string[] csvLine in fileContents) { //string[] csvFields = csvParserRegex.Split(csvLine); tempTransactions.Add(new LogiNextTransaction(csvLine)); } foreach (LogiNextTransaction transaction in tempTransactions) { lnDriverSummary.AddTransaction(transaction); } return(lnDriverSummary); }