public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
Age = TestConstants.PETAPOCO_InsertDogAge,
Name = TestConstants.PETAPOCO_InsertDogName
};
//Act
repository.Add(dog);
//Assert
int actualCount = DataUtil.GetRecordCount(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName);
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, actualCount);
}
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID()
{
//Arrange
var mockCache = new Mock <ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
Age = TestConstants.PETAPOCO_InsertDogAge,
Name = TestConstants.PETAPOCO_InsertDogName
};
//Act
repository.Add(dog);
//Assert
int newId = DataUtil.GetLastAddedRecordID(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName, "ID");
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, newId);
}
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object);
var dog = new Dog
{
Age = TestConstants.PETAPOCO_InsertDogAge,
Name = TestConstants.PETAPOCO_InsertDogName
};
//Act
repository.Add(dog);
//Assert
DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName);
DataRow row = table.Rows[table.Rows.Count - 1];
Assert.AreEqual(TestConstants.PETAPOCO_InsertDogAge, row["Age"]);
Assert.AreEqual(TestConstants.PETAPOCO_InsertDogName, row["Name"]);
}
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues()
{
//Arrange
var mockCache = new Mock <ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository <Dog>(_petaPocoUnitOfWork, mockCache.Object);
var dog = new Dog
{
Age = TestConstants.PETAPOCO_InsertDogAge,
Name = TestConstants.PETAPOCO_InsertDogName
};
//Act
repository.Add(dog);
//Assert
DataTable table = DataUtil.GetTable(TestConstants.PETAPOCO_DatabaseName, TestConstants.PETAPOCO_TableName);
DataRow row = table.Rows[table.Rows.Count - 1];
Assert.AreEqual(TestConstants.PETAPOCO_InsertDogAge, row["Age"]);
Assert.AreEqual(TestConstants.PETAPOCO_InsertDogName, row["Name"]);
}
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID()
{
//Arrange
var mockCache = new Mock<ICacheProvider>();
SetUpDatabase(TestConstants.PETAPOCO_RecordCount);
var repository = new PetaPocoRepository<Dog>(_pecaPocoDb, mockCache.Object);
var dog = new Dog
{
Age = TestConstants.PETAPOCO_InsertDogAge,
Name = TestConstants.PETAPOCO_InsertDogName
};
//Act
repository.Add(dog);
//Assert
int newId = DataUtil.GetLastAddedRecordID(TestConstants.PETAPOCO_DatabaseName,
TestConstants.PETAPOCO_TableName, "ID");
Assert.AreEqual(TestConstants.PETAPOCO_RecordCount + 1, newId);
}
