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");
}