public void TestVendorAddrDelete()
{
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(cExcel.GetHelperFilesDir(), "VendorAddr.xlsx"));
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
Guid vendorID = new Guid(row["VendorID"].ToString());
sp_VendorAddr_DM data = new sp_VendorAddr_DM();
data.VendorID = vendorID;
sp_VendorAddr_BLL vendor = new sp_VendorAddr_BLL();
vendor.DeleteAddressContext(data);
var newdata = vendor.ListAddresses(vendorID);
Assert.IsNull(newdata);
}
}