public void ShouldReturnMinValueDateTimeWhenReadingStartTimeFromAnEmptyCell()
{
using (var report = new XlsReport(TestTimesheet))
{
var readTime = report.ReadStartTime(new DateTime(2012, 12, 19));
Assert.That(readTime, Is.EqualTo(DateTime.MinValue));
}
}
public void ShouldReturnTimeFromStartTimeCellWhenPassedARequestedStartTime()
{
var startTime = new DateTime(2012, 12, 20, 08, 15, 00);
using (var report = new XlsReport(TestTimesheet))
{
report.WriteStartTime(startTime);
var readTime = report.ReadStartTime(new DateTime(2012, 12, 20));
Assert.That(readTime, Is.EqualTo(startTime));
}
}
public void ShouldWriteEndTimeToCorrectCellForThursday()
{
using (var report = new XlsReport(TestTimesheet))
{
var thursdayEndTime = new DateTime(2012, 12, 20, 08, 15, 00);
report.WriteEndTime(thursdayEndTime);
}
var date = GetValueFromCell(TestTimesheet, "January", "D10");
Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
}
public void ShouldWriteTimeToCorrectCellForMondayNextMonth()
{
using (var report = new XlsReport(TestTimesheet))
{
var nextMondayStartTime = new DateTime(2013, 01, 21, 08, 15, 00);
report.WriteStartTime(nextMondayStartTime);
}
var date = GetValueFromCell(TestTimesheet, "February", "C7");
Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
}
public void ShouldWritetimeToCorrectCellForTuesdayInCoupleOfWeeks()
{
using (var report = new XlsReport(TestTimesheet))
{
var nextMondayStartTime = new DateTime(2013, 01, 01, 08, 15, 00);
report.WriteStartTime(nextMondayStartTime);
}
var date = GetValueFromCell(TestTimesheet, "January", "C40");
Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
}
public void ShouldWriteTimeToCorrectCellForSundayStartTime()
{
using (var report = new XlsReport(TestTimesheet))
{
var tuesdayStartTime = new DateTime(2012, 12, 23, 08, 15, 00);
report.WriteStartTime(tuesdayStartTime);
}
var date = GetValueFromCell(TestTimesheet, "January", "C13");
Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(8, 15, 0)));
}
public void ShouldWriteTimeToCorrectCellForMondayStartTime()
{
using (var report = new XlsReport(TestTimesheet))
{
var mondayStartTime = new DateTime(2012, 12, 17, 9, 30, 0);
report.WriteStartTime(mondayStartTime);
}
var date = GetValueFromCell(TestTimesheet, "January", "C7");
Assert.That(ConvertToDateTime(date), Is.EqualTo(new TimeSpan(9, 30, 0)));
}
