public void TestContactEmailCreate()
{
//Insert a Contact First
sp_Contact_DM contact_dm = new sp_Contact_DM();
contact_dm.ContactID = new Guid();
sp_Contact_BLL contact_bll = new sp_Contact_BLL();
contact_bll.InsertContactContext(ref contact_dm);
//Insert an ContactEmail
sp_ContactEmail_DM data = new sp_ContactEmail_DM();
data.ContactID = contact_dm.ContactID;
data.EmailID = 1;
data.PrimaryEmail = true;
sp_ContactEmail_BLL vendor = new sp_ContactEmail_BLL();
vendor.InsertContactEmailContext(data);
var newdata = vendor.ListContactEmails(data.ContactID, data.EmailID);
Assert.AreEqual(data.ContactID, newdata.ContactID, "Contact ID Not Set As Expected");
Assert.AreEqual(data.EmailID, newdata.EmailID, "Email ID Not Set As Expected");
Assert.AreEqual(data.PrimaryEmail, newdata.PrimaryEmail, "PrimaryEmail Not Set As Expected");
}
public void TestContactEmailRead()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "ContactEmail.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
Guid contactID = new Guid(row["ContactID"].ToString());
int emailID = Convert.ToInt32(row["EmailID"]);
sp_ContactEmail_BLL contact = new sp_ContactEmail_BLL();
var data = contact.ListContactEmails(contactID, emailID);
Assert.AreEqual(contactID, data.ContactID, "ContactID Not Set As Expected");
Assert.AreEqual(emailID, data.EmailID, "EmailID Not Set As Expected");
}
}
public void TestContactEmailUpdate()
{
//Test Our Read
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "ContactEmail.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
bool primaryEmail = true;
int emailID = Convert.ToInt32(row["EmailID"]);
Guid contactID = new Guid( row["ContactID"].ToString());
sp_ContactEmail_DM data = new sp_ContactEmail_DM();
data.ContactID = contactID;
data.EmailID = emailID;
data.PrimaryEmail = primaryEmail;
sp_ContactEmail_BLL contact = new sp_ContactEmail_BLL();
contact.UpdateContactEmailContext(data);
var newdata = contact.ListContactEmails(contactID, emailID);
Assert.AreEqual(primaryEmail, newdata.PrimaryEmail, "PrimaryEmail Not Set As Expected");
Assert.AreEqual(emailID, newdata.EmailID, "EmailID Not Set As Expected");
Assert.AreEqual(contactID, newdata.ContactID, "ContactIDe Not Set As Expected");
}
}
public void TestContactEmailReadAll()
{
//Pull our data from the excel file
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "ContactEmail.xlsx"));
//Pull our data directly from the DB
var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblContactEmail]");
//Pull our data from the DB through the BLL
sp_ContactEmail_BLL contactEmails = new sp_ContactEmail_BLL();
var allContactsEmails = contactEmails.ListContactEmails();
//Test the data from the BLL
Assert.AreEqual(numRows, allContactsEmails.Count);
}
