public void TestVendEmailDelete()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "tblVendEmail.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
int EmailID = Convert.ToInt32(row["EmailID"].ToString());
sp_VendEmail_DM data = new sp_VendEmail_DM();
sp_VendEmail_BLL vend = new sp_VendEmail_BLL();
data.EmailID = EmailID;
vend.DeleteEmailContext(data);
data = vend.ListEmails(EmailID);
Assert.AreEqual(false, data.ActiveFlg, "ActiveFlag not set as expected");
}
}