public void ShouldThrowInvalidExtension()
{
var file = "TestFiles/Toggl_projects_2018-11-01_to_2018-11-30.xml";
TestDelegate code = () => CsvParser.ParseCsvFile(file);
Assert.Throws <ArgumentException>(code);
}
public void ShouldThrowInvalidHeaders()
{
try
{
CsvParser.ParseCsvFile("TestFiles/InvalidHeaders.csv");
}
catch (Exception e)
{
Assert.IsTrue(e.Message.Contains("Invalid"));
Assert.IsTrue(e.Message.Contains("Header"));
Assert.IsTrue(e.InnerException is HeaderValidationException);
return;
}
Assert.Fail("Exception should have been thrown");
}
public void ShouldThrowInvalidCell()
{
try
{
CsvParser.ParseCsvFile("TestFiles/InvalidTimeFormat.csv");
}
catch (Exception e)
{
if (!(e is InvalidCellException ex))
{
throw new AssertionException($"Exception should be of type InvalidCellException. Current type {e.GetType()}");
}
Assert.AreEqual(2, ex.Line);
Assert.AreEqual("carne", ex.RawValue);
return;
}
Assert.Fail("Exception should have been thrown");
}
public void SuccessfulProcessedTimeSheetWithoutDate()
{
var resultSheet = CsvParser.ParseCsvFile("TestFiles/MyProjects.csv");
Assert.AreEqual(5, resultSheet.TimeEntries.Count);
Assert.IsNotNull(resultSheet.Period == null, "resultSheet.Period == null");
resultSheet.TimeEntries[0]
.AssertRecord("Pedro Company", "CT", new TimeSpan(14, 41, 36));
resultSheet.TimeEntries[1]
.AssertRecord("Pedro Company", "MbOS", new TimeSpan(2, 5, 39));
resultSheet.TimeEntries[2]
.AssertRecord("Pedro Company", "Game Engine", new TimeSpan(2, 31, 38));
resultSheet.TimeEntries[3]
.AssertRecord("Pedro Company", "HiddenProject", new TimeSpan(4, 14, 24, 53));
}
public void SuccessfulProcessedSimpleEntriesSheetTest()
{
var resultSheet = CsvParser.ParseCsvFile("TestFiles/Toggl_projects_2018-11-01_to_2018-11-30.csv");
Assert.AreEqual(5, resultSheet.TimeEntries.Count);
Debug.Assert(resultSheet.Period != null, "resultSheet.Period != null");
Assert.AreEqual(new DateTime(2018, 11, 01), resultSheet.Period.Value.StartDate);
Assert.AreEqual(new DateTime(2018, 11, 30), resultSheet.Period.Value.EndDate);
resultSheet.TimeEntries[0]
.AssertRecord("Pedro Company", "CT", new TimeSpan(14, 41, 36));
resultSheet.TimeEntries[1]
.AssertRecord("Pedro Company", "MbOS", new TimeSpan(2, 5, 39));
resultSheet.TimeEntries[2]
.AssertRecord("Pedro Company", "Game Engine", new TimeSpan(2, 31, 38));
resultSheet.TimeEntries[3]
.AssertRecord("Pedro Company", "HiddenProject", new TimeSpan(4, 14, 24, 53));
}