public void TestVendAddressDelete()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "VendAddress.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
int AddrID = Convert.ToInt32(row["AddrID"].ToString());
sp_VendAddress_DM data = new sp_VendAddress_DM();
sp_VendAddress_BLL vend = new sp_VendAddress_BLL();
data.AddrID = AddrID;
vend.DeleteAddressContext(data);
data = vend.ListAddresses(AddrID);
Assert.AreEqual(false, data.ActiveFlg, "ActiveFlag not set as expected");
}
}