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"); } }
public void TestVendEmailInsert() { //Test Our Read sp_VendEmail_DM data = new sp_VendEmail_DM(); string EmailAddr = "*****@*****.**"; data.EmailAddr = EmailAddr; data.ActiveFlg = true; sp_VendEmail_BLL vend = new sp_VendEmail_BLL(); vend.InsertEmailContext(data); Assert.AreEqual(EmailAddr, data.EmailAddr, "EmailAddr Not Set As Expected"); }