public void Delete_WhenBillToIDIsNotMatechedInDB_NoRecordIsDeleted(string billToId) { var sut = new BMPresenter(databaseConnection, userName, viewer); CreateTestData(); string msg = sut.Delete(billToId); DataTable dt = sut.Search(); Assert.That(dt.Rows, Has.Count.EqualTo(4)); databaseConnection.RunSqlCommand("truncate table BillToIDs"); }
public void Delete_WhenBillToIDIsMatechedInDB_DeleteTheMatchedRecord() { var sut = new BMPresenter(databaseConnection, userName, viewer); CreateTestData(); string billToId = "123456"; string msg = sut.Delete("123456"); DataTable dt = sut.Search(); Assert.That(msg, Is.EqualTo(string.Format("BillToID: {0} is deleted successfully!", billToId))); Assert.That(dt.Rows, Has.Count.EqualTo(3)); databaseConnection.RunSqlCommand("truncate table BillToIDs"); }