public string ParseFirstRowForDelimiters(string path)
{
using (ITextFieldParser parser = parserFactory.Create(path)) {
string line = parser.ReadLine();
return(delimiterLogic.Invoke(line));
}
}
public LowerLayerSuperOutputAreaCodeToWardCodeParserShould()
{
_textFieldParser = Substitute.For <ITextFieldParser>();
_lowerLayerSuperOutputAreaCodeToWardCodeParser =
new LowerLayerSuperOutputAreaCodeToWardCodeParser(_textFieldParser);
}
public CsvParser(ITextFieldParser textFieldParser)
{
_textFieldParser = textFieldParser;
}
/// <summary>
/// Loads and parses a csv file.
/// </summary>
/// <returns>Task.</returns>
public async Task ParseCSVFile()
{
try
{
EnableControls = false;
OnStatusUpdated("Reading CSV file...");
Scrobbles.Clear();
using (ITextFieldParser parser = _parserFactory.CreateParser(CSVFilePath))
{
parser.SetDelimiters(Settings.Default.CSVDelimiters.Select(x => new string(x, 1)).ToArray());
string[] fields = null;
List <string> errors = new List <string>();
ObservableCollection <ParsedCSVScrobbleViewModel> parsedScrobbles = new ObservableCollection <ParsedCSVScrobbleViewModel>();
await Task.Run(() =>
{
while (!parser.EndOfData)
{
try
{
fields = parser.ReadFields();
string dateString = fields[Settings.Default.TimestampFieldIndex];
// check for 'now playing'
if (dateString == "" && ScrobbleMode == CSVScrobbleMode.Normal)
{
continue;
}
DateTime date = DateTime.Now;
if (!DateTime.TryParse(dateString, out date))
{
bool parsed = false;
// try different formats until succeeded
foreach (string format in _formats)
{
parsed = DateTime.TryParseExact(dateString, format, CultureInfo.CurrentCulture, DateTimeStyles.None, out date);
if (parsed)
{
break;
}
}
if (!parsed && ScrobbleMode == CSVScrobbleMode.Normal)
{
throw new Exception("Timestamp could not be parsed!");
}
}
// try to get optional parameters first
string album = fields.ElementAtOrDefault(Settings.Default.AlbumFieldIndex);
string albumArtist = fields.ElementAtOrDefault(Settings.Default.AlbumArtistFieldIndex);
string duration = fields.ElementAtOrDefault(Settings.Default.DurationFieldIndex);
TimeSpan time = TimeSpan.FromSeconds(Duration);
TimeSpan.TryParse(duration, out time);
DatedScrobble parsedScrobble = new DatedScrobble(date.AddSeconds(1), fields[Settings.Default.TrackFieldIndex],
fields[Settings.Default.ArtistFieldIndex], album,
albumArtist, time);
ParsedCSVScrobbleViewModel vm = new ParsedCSVScrobbleViewModel(parsedScrobble, ScrobbleMode);
vm.ToScrobbleChanged += ToScrobbleChanged;
parsedScrobbles.Add(vm);
}
catch (Exception ex)
{
string errorString = "CSV line number: " + parser.LineNumber + ",";
foreach (string s in fields)
{
errorString += s + ",";
}
errorString += ex.Message;
errors.Add(errorString);
}
}
});
if (errors.Count == 0)
{
OnStatusUpdated("Successfully parsed CSV file. Parsed " + parsedScrobbles.Count + " rows");
}
else
{
OnStatusUpdated("Partially parsed CSV file. " + errors.Count + " rows could not be parsed");
if (MessageBox.Show("Some rows could not be parsed. Do you want to save a text file with the rows that could not be parsed?", "Error parsing rows", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SaveFileDialog sfd = new SaveFileDialog()
{
Filter = "Text Files|*.txt"
};
if (sfd.ShowDialog() == DialogResult.OK)
{
File.WriteAllLines(sfd.FileName, errors.ToArray());
}
}
}
Scrobbles = parsedScrobbles;
}
}
catch (Exception ex)
{
Scrobbles.Clear();
OnStatusUpdated("Error parsing CSV file: " + ex.Message);
}
finally
{
EnableControls = true;
}
}
public HousePriceParserShould()
{
_textFieldParser = Substitute.For <ITextFieldParser>();
_housePriceParser = new HousePriceParser(_textFieldParser);
}
public HousePriceParser([KeyFilter("housePriceDatasetPath")] ITextFieldParser textFieldParser) : base(
textFieldParser)
{
}
public LowerLayerSuperOutputAreaCodeToWardCodeParser(
[KeyFilter("lowerLayerSuperOutputAreaCodeToWardCodeDatasetPath")]
ITextFieldParser textFieldParser) : base(textFieldParser)
{
}
