public void TestProjectEventContactCreate() { bool PrimaryContact = true; var ProjectEventContact_bll = new sp_ProjectEventContact_BLL(); var ProjectEventContact_dm = new sp_ProjectEventContact_DM(); var ProjectEvent_bll = new sp_ProjectEvent_BLL(); var Contact_bll = new sp_Contact_BLL(); ProjectEventContact_dm.PrimaryContact = PrimaryContact; var allProjectEvents = ProjectEvent_bll.ListEvents(); Assert.IsTrue(allProjectEvents.Count > 0, "The ListEvents() is broken, or no data in DB"); ProjectEventContact_dm.EventID = allProjectEvents[0].EventID; var allContacts = Contact_bll.ListContacts(); Assert.IsTrue(allContacts.Count > 0, "The ListContacts() is broken, or no data in DB"); ProjectEventContact_dm.ContactID = allContacts[0].ContactID; ProjectEventContact_bll.InsertProjectEventContactContext(ProjectEventContact_dm); var ProjectEventContact_dm_selected = ProjectEventContact_bll.ListEventsContacts( ProjectEventContact_dm.EventID, ProjectEventContact_dm.ContactID); Assert.AreEqual(1, ProjectEventContact_dm_selected.Count); Assert.IsTrue(Equals(ProjectEventContact_dm, ProjectEventContact_dm_selected[0])); }
public void TestProjectEventContactDelete() { var ProjectEventContact_bll = new sp_ProjectEventContact_BLL(); var allProjectEventContacts = ProjectEventContact_bll.ListEventsContacts(); Assert.IsTrue(allProjectEventContacts.Count > 0, "The ListProjectEventContacts() is broken, or no data in DB"); var currProjectEventContact = allProjectEventContacts[0]; var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEventContact]"); ProjectEventContact_bll.DeleteProjectEventContactContext(currProjectEventContact); var selectedProjectEventContact = ProjectEventContact_bll.ListEventsContacts( currProjectEventContact.EventID, currProjectEventContact.ContactID); Assert.AreEqual(1, selectedProjectEventContact.Count); var numCurrRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEventContact]"); Assert.AreEqual(numRows - 1, numCurrRows); }
public void TestProjectEventContactRead() { //Pull our data from the excel file string helperDir = cExcel.GetHelperFilesDir(); DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "ProjectEventContact.xlsx")); var excelDMs = DMsFrom(dt); //Pull our data directly from the DB var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblProjectEventContact]"); //Pull our data from the DB through the BLL var ProjectEventContact_bll = new sp_ProjectEventContact_BLL(); var allProjectEventContacts = ProjectEventContact_bll.ListEventsContacts(); //Test the data from the BLL Assert.AreEqual(numRows, allProjectEventContacts.Count); foreach (var testProjectEventContact in excelDMs) { var selectedProjectEventContact = ProjectEventContact_bll.ListEventsContacts( testProjectEventContact.EventID, testProjectEventContact.ContactID); Assert.AreEqual(1, selectedProjectEventContact.Count); Assert.IsTrue(Equals(testProjectEventContact, selectedProjectEventContact[0])); } }
public void TestProjectEventContactUpdate() { var ProjectEventContact_bll = new sp_ProjectEventContact_BLL(); var allProjectEventContacts = ProjectEventContact_bll.ListEventsContacts(); Assert.IsTrue(allProjectEventContacts.Count > 0, "The ListEventsContacts() is broken, or no data in DB"); var firstProjectEventContact = allProjectEventContacts[0]; firstProjectEventContact.PrimaryContact = !firstProjectEventContact.PrimaryContact; ProjectEventContact_bll.UpdateProjectEventContactContext(firstProjectEventContact); var selectedProjectEventContact = ProjectEventContact_bll.ListEventsContacts( firstProjectEventContact.EventID, firstProjectEventContact.ContactID); Assert.AreEqual(1, selectedProjectEventContact.Count); Assert.IsTrue(Equals(firstProjectEventContact, selectedProjectEventContact)); }