public void TestProjectEventDelete() { var ProjectEvent_bll = new sp_ProjectEvent_BLL(); var allProjectEvents = ProjectEvent_bll.ListEvents(); Assert.IsTrue(allProjectEvents.Count > 0, "The ListProjectEvents() is broken, or no data in DB"); var currProjectEvent = allProjectEvents[0]; var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEvent]"); //ProjectEvent_bll.DeleteEventContext(currProjectEvent); var selectedProjectEvent = ProjectEvent_bll.ListEvent(currProjectEvent.EventID); var numCurrRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEvent]"); Assert.AreEqual(numRows - 1, numCurrRows); }
public void TestProjectEventRead() { //Pull our data from the excel file string helperDir = cExcel.GetHelperFilesDir(); DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "ProjectEvent.xlsx")); var excelDMs = DMsFrom(dt); //Pull our data directly from the DB var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEvent]"); //Pull our data from the DB through the BLL var ProjectEvent_bll = new sp_ProjectEvent_BLL(); var allProjectEvents = ProjectEvent_bll.ListEvents(); //Test the data from the BLL Assert.AreEqual(numRows, allProjectEvents.Count); foreach (var testProjectEvent in excelDMs) { var selectedProjectEvent = ProjectEvent_bll.ListEvent(testProjectEvent.EventID); Assert.IsTrue(Equals(testProjectEvent, selectedProjectEvent)); } }
public void TestProjectEventUpdate() { var ProjectEvent_bll = new sp_ProjectEvent_BLL(); var allProjectEvents = ProjectEvent_bll.ListEvents(); Assert.IsTrue(allProjectEvents.Count > 0, "The ListEvents() is broken, or no data in DB"); var firstProjectEvent = allProjectEvents[0]; DateTime StartDate = new DateTime(1998, 02, 03, 1, 2, 3); DateTime EndDate = new DateTime(1999, 04, 05, 3, 2, 1); firstProjectEvent.StartDateTime = StartDate; firstProjectEvent.EndDateTime = EndDate; //ProjectEvent_bll.UpdateEventContext(firstProjectEvent); var selectedProjectEvent = ProjectEvent_bll.ListEvent(firstProjectEvent.EventID); Assert.IsTrue(Equals(firstProjectEvent, selectedProjectEvent)); Assert.AreEqual(StartDate, selectedProjectEvent.StartDateTime); Assert.AreEqual(EndDate, selectedProjectEvent.EndDateTime); }