public void HandleRecordInsertNewRecordToDBTest() { PTRecord record = new PTRecord("name", DateTime.Today, new TimeSpan(0, 10, 0)); PTDatabase.HandleRecord(record); PTDate expectedDate = new PTDate(1, DateTime.Today); PTProcessInfo expectedInfo = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0)); PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today); PTProcessInfo actaulInfo = PTDatabase.GetInfoForProcessOnDate(record.name, actualDate); Assert.AreEqual(expectedDate, actualDate); Assert.AreEqual(expectedInfo, actaulInfo); }
public void GetInfoForProcessOnDateTest() { string processName = "name"; PTDate date = new PTDate(1, DateTime.Today); string otherProcessName = "otherName"; PTProcessInfo expected = new PTProcessInfo(1, processName, new TimeSpan(0, 10, 0)); PTProcessInfo otherInfo = new PTProcessInfo(2, otherProcessName, new TimeSpan(0, 10, 0)); PTDatabase.InsertDate(date); PTDatabase.InsertProcessInfo(expected, date); PTDatabase.InsertProcessInfo(otherInfo, date); PTProcessInfo actual = PTDatabase.GetInfoForProcessOnDate(processName, date); Assert.AreEqual(expected, actual); }
public void HandleRecordInsertsSeparateRecordforDifferentProcessInDBTest() { PTRecord record1 = new PTRecord("name1", DateTime.Today, new TimeSpan(0, 10, 0)); PTRecord record2 = new PTRecord("name2", DateTime.Today, new TimeSpan(0, 20, 0)); PTDate expectedDate = new PTDate(1, DateTime.Today); PTProcessInfo expectedInfo1 = new PTProcessInfo(1, record1.name, new TimeSpan(0, 10, 0)); PTProcessInfo expectedInfo2 = new PTProcessInfo(2, record2.name, new TimeSpan(0, 20, 0)); PTDatabase.HandleRecord(record1); PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today); PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate); Assert.AreEqual(expectedDate, actualDate); Assert.AreEqual(expectedInfo1, actaulInfo1); PTDatabase.HandleRecord(record2); PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record2.name, actualDate); Assert.AreEqual(expectedInfo2, actaulInfo2); }
public void HandleRecordUpdatesExistingEntryInDBTest() { PTRecord record1 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 10, 0)); PTRecord record2 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 20, 0)); PTDate expectedDate = new PTDate(1, DateTime.Today); PTProcessInfo expectedInfo1 = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0)); PTProcessInfo expectedInfo2 = new PTProcessInfo(1, "name", new TimeSpan(0, 30, 0)); PTDatabase.HandleRecord(record1); PTDate actualDate = PTDatabase.GetDateForDateTime(DateTime.Today); PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate); Assert.AreEqual(expectedDate, actualDate); Assert.AreEqual(expectedInfo1, actaulInfo1); PTDatabase.HandleRecord(record2); PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate); Assert.AreEqual(expectedInfo2, actaulInfo2); }
public void processInfoForDateTest() { PTDate date = new PTDate(1, DateTime.Now.Date); PTDate otherDate = new PTDate(2, DateTime.Today + new TimeSpan(1, 0, 0, 0)); List <PTProcessInfo> expected = new List <PTProcessInfo>() { new PTProcessInfo(1, "name1", new TimeSpan(0, 5, 0)), new PTProcessInfo(2, "name2", new TimeSpan(0, 75, 0)), new PTProcessInfo(3, "name3", new TimeSpan(1, 5, 0)) }; PTProcessInfo otherInfo = new PTProcessInfo(4, "name4", new TimeSpan(1, 25, 0)); PTDatabase.InsertProcessInfo(expected[0], date); PTDatabase.InsertProcessInfo(expected[1], date); PTDatabase.InsertProcessInfo(expected[2], date); PTDatabase.InsertProcessInfo(otherInfo, otherDate); List <PTProcessInfo> actual = PTDatabase.ProcessInfoForDate(date); CollectionAssert.AreEqual(expected, actual); }
public void HandleRecordInsertsNewEntryForTheSameProcessIfTheDateIsDifferentDBTest() { PTRecord record1 = new PTRecord("name", DateTime.Today - new TimeSpan(1, 0, 0, 0), new TimeSpan(0, 10, 0)); PTRecord record2 = new PTRecord("name", DateTime.Today, new TimeSpan(0, 20, 0)); PTDate expectedDate1 = new PTDate(1, record1.datetime); PTDate expectedDate2 = new PTDate(2, record2.datetime); PTProcessInfo expectedInfo1 = new PTProcessInfo(1, "name", new TimeSpan(0, 10, 0)); PTProcessInfo expectedInfo2 = new PTProcessInfo(2, "name", new TimeSpan(0, 20, 0)); PTDatabase.HandleRecord(record1); PTDate actualDate1 = PTDatabase.GetDateForDateTime(DateTime.Today - new TimeSpan(1, 0, 0, 0)); PTDate actualDate2 = PTDatabase.GetDateForDateTime(DateTime.Today); PTProcessInfo actaulInfo1 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate1); Assert.AreEqual(expectedDate1, actualDate1); Assert.AreEqual(expectedInfo1, actaulInfo1); PTDatabase.HandleRecord(record2); PTProcessInfo actaulInfo2 = PTDatabase.GetInfoForProcessOnDate(record1.name, actualDate2); Assert.AreEqual(expectedDate2, actualDate2); Assert.AreEqual(expectedInfo2, actaulInfo2); }