|
public ListEvent ( System.Guid EventID ) : |
||
| EventID | System.Guid | |
| return | ||
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);
}
