public void TestVendEmailUpdate()
{
//Test Our Read
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendEmail.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
string EmailAddr = "*****@*****.**";
int EmailID = Convert.ToInt32(row["EmailID"].ToString());
sp_VendEmail_DM data = new sp_VendEmail_DM();
data.EmailID = EmailID;
data.EmailAddr = EmailAddr;
sp_VendEmail_BLL vend = new sp_VendEmail_BLL();
vend.UpdateEmailContext(data);
data = vend.ListEmails(EmailID);
Assert.AreEqual(EmailAddr, data.EmailAddr, "EmailAddr Not Set As Expected");
}
}