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"); } }
public void TestVendEmailRead() { //Test Our Read 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_BLL vend = new sp_VendEmail_BLL(); sp_VendEmail_DM data = vend.ListEmails(EmailID); Assert.AreEqual(row["EmailAddr"].ToString(), data.EmailAddr, "EmailAddr Not Set As Expected"); } }