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