public void UpdateThemasTest()
{
var target = new OracleAccess();
string nu = DateTime.Now.ToString();
var themaOld = new BeheerContextEntity
{
DataKeyValue = "aaP" + nu,
Tablename = "thema",
DataKeyName = "themanaam"
};
target.Insert(themaOld);
var themaNew= new BeheerContextEntity
{
DataKeyValue = "aapje" + nu,
Tablename = "thema",
DataKeyName = "themanaam"
};
int rowsAffected = target.Update(themaOld,themaNew);
Assert.AreEqual(1,rowsAffected );
var expected = target.GetBusinessObject(themaNew.Tablename, themaNew.DataKeyName,
themaNew.DataKeyValue) as BeheerContextEntity;
// ReSharper disable PossibleNullReferenceException
Assert.AreEqual(expected.DataKeyValue, themaNew.DataKeyValue);
// ReSharper restore PossibleNullReferenceException
Assert.AreEqual(expected.Tablename, themaNew.Tablename);
Assert.AreEqual(expected.DataKeyName, themaNew.DataKeyName);
}
public void DeleteThemasTest()
{
var target = new OracleAccess();
var thema = new BeheerContextEntity
{
DataKeyValue = "aaaDwight" + DateTime.Now,
Tablename = "thema",
DataKeyName = "themanaam"
};
Assert.IsTrue(target.Insert(thema) > 0);
int rowsAffected = target.Delete(thema);
Assert.IsTrue(rowsAffected == 1);
var expected = target.GetBusinessObject(thema.Tablename, thema.DataKeyName,
thema.DataKeyValue) as BeheerContextEntity;
Assert.AreEqual(expected, null);
}
public void InsertThemasTest()
{
var target = new OracleAccess();
var themaNew = new BeheerContextEntity
{
DataKeyValue = "aaaDwight" + DateTime.Now,
Tablename = "thema",
DataKeyName = "themanaam"
};
int rowsAffected = target.Insert(themaNew);
var expected = target.GetBusinessObject(themaNew.Tablename, themaNew.DataKeyName,
themaNew.DataKeyValue) as BeheerContextEntity;
Assert.IsTrue(rowsAffected == 1);
// ReSharper disable PossibleNullReferenceException
Assert.AreEqual(expected.DataKeyValue, themaNew.DataKeyValue);
// ReSharper restore PossibleNullReferenceException
Assert.AreEqual(expected.Tablename, themaNew.Tablename);
Assert.AreEqual(expected.DataKeyName, themaNew.DataKeyName);
}