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