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))); }