public void CreateBillToID_WhenBillToIDDoesNotExist_ItShouldBeCreated() { var sut = new BMPresenter(databaseConnection, userName, viewer); string billToId = "123456"; string msg = sut.Create(billToId); DataTable billToIdDt = sut.Search(); Assert.That(msg, Is.EqualTo(string.Format("BillToID: {0} is created successfully!", billToId))); Assert.That(billToIdDt.Rows, Has.Count.EqualTo(1)); databaseConnection.RunSqlCommand("truncate table BillToIDs"); }
public void Search_WhenBillToIDIsNotProvided_ReturnAllRecords() { var sut = new BMPresenter(databaseConnection, userName, viewer); CreateTestData(); DataTable dt = sut.Search(); Assert.That(dt.Rows, Has.Count.EqualTo(4)); databaseConnection.RunSqlCommand("truncate table BillToIDs"); }
public void Search_WhenBillToIDIsProvided_ReturnOnlyTheMatchedRecords(string billToId, int expectedRecords) { var sut = new BMPresenter(databaseConnection, userName, viewer); CreateTestData(); DataTable dt = sut.Search(billToId); Assert.That(dt.Rows, Has.Count.EqualTo(expectedRecords)); databaseConnection.RunSqlCommand("truncate table BillToIDs"); }
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"); }