public IBeheerContextEntity GetBusinessObject(string qry, BeheerContextEntity beheerObject)
{
using (var conn = new OracleConnection(_oradb))
{
conn.Open();
var cmd = new OracleCommand
{
Connection = conn,
CommandText = qry,
CommandType = CommandType.Text
};
cmd.Connection = conn;
var reader = cmd.ExecuteReader();
var smartReader = new SmartDataReader(reader);
BeheerContextEntity businessObject = null;
while (smartReader.Read())
{
businessObject = new BeheerContextEntity
{
Id = smartReader.GetInt32("id"),
DataKeyValue = smartReader.GetString(beheerObject.DataKeyName, ""),
Tablename = beheerObject.Tablename,
DataKeyName = beheerObject.DataKeyName
};
}
return businessObject;
}
}
public void OnViewLoadedSetsBusinessObjectenIntheView()
{
//Arrange
var controller = new MockTrefwoordController();
var beheerObject = new BeheerContextEntity { DataKeyValue = "test1" };
beheerObject.Details.Add(new BeheerContextEntity
{
DataKeyValue = "Test-Detail"
});
controller.MockBusinessentity.Add(beheerObject);
controller.AddDetail(beheerObject.Details[0]);
var presenter = new TrefwoordenPresenter(controller);
var view = new MockTrefwoordenView();
presenter.View = view;
//Act
presenter.OnViewLoaded();
//Assert
Assert.AreEqual(1, view.BusinessEntities.Count);
Assert.AreSame(beheerObject, view.BusinessEntities[view.BusinessEntities.Count - 1]);
Assert.AreEqual(beheerObject.Details, view.Details);
}
public void OnViewLoadedSetsCategorieIntheView()
{
// Mock the View
MockRepository mocks = new MockRepository();
//Arrange
var service = mocks.DynamicMock<ICategorieService>();
//Act
var controller = mocks.DynamicMock<ICategorieController>();
// Create Presenter With Mock View and Dummy BlogService
CategorieService serviceActual = new MockCategorieService();
var controllerActual = new CategorieController(serviceActual,null,null);
var presenter = new CategorieenPresenter(controllerActual);
var cat = new BeheerContextEntity { DataKeyValue = "added" };
IList<BeheerContextEntity> list= new List<BeheerContextEntity>();
list.Add(cat);
//controller.AddBusinessEntity(cat);
// Set Expectations
controller.Expect(action=>action.AddBusinessEntity(cat));
//presenter.Expect(action => action.OnViewLoaded());
// Tell Rhino Mocks We're Done Setting Expectations
mocks.ReplayAll();
presenter.OnViewLoaded();
mocks.VerifyAll();
}
/// <summary>
/// Alleen als de application-controller een select-proces in behandeling neemt van zijn presenter
/// deze functie gebruiken.
/// </summary>
/// <param name="master"></param>
public void UpdateDetails(BeheerContextEntity master)
{
m_DetailsLastUpdated = master.Details;
AddMaster(master);
Master = master;
}
/// <summary>
/// De repository van masters inrichten en herinrichten, als de master al bestaat.
/// </summary>
/// <param name="master"></param>
public void AddMaster(BeheerContextEntity master)
{
BeheerContextEntity found;
m_QueueMasters.TryGetValue(master.Id, out found);
if (m_QueueMasters != null && found == null)
{
m_QueueMasters.Add(new KeyValuePair<int, BeheerContextEntity>(master.Id, master));
}
}
public virtual void AddBusinessEntity(BeheerContextEntity entity)
{
//Master info meegeven.
entity.Parent= new ParentKeyEntity
{
DataKeyValue = m_Master.DataKeyValue,
Id = m_Master.Id,
DataKeyName = "categorienaam",
Tablename = "categorie"
};
TrefwoordService.AddBusinessEntity(entity);
}
protected void ThemaTableDataSource_Inserted(object sender, ObjectContainerDataSourceStatusEventArgs e)
{
BeheerContextEntity thema = new BeheerContextEntity();
thema = e.Instance as BeheerContextEntity;
if (thema != null)
{
thema.Tablename = "thema";
thema.DataKeyName = "themanaam";
m_Presenter.OnBusinessEntityAdded(thema);
}
m_Presenter.OnViewLoaded();
}
public virtual void AddBusinessEntity(BeheerContextEntity entity)
{
//Master info meegeven voor business layer
entity.Parent= new ParentKeyEntity
{
DataKeyValue = m_Master.DataKeyValue,
Id = m_Master.Id,
DataKeyName = "categorienaam",
Tablename = "categorie"
};
entity.MasterId = m_Master.Id;
entity.Master = m_Master.DataKeyValue;//for system-bindings
TrefwoordService.AddBusinessEntity(entity);
}
/// <summary>
/// Deze wordt aangeroepen tijdens de page_load van trefwoord.
/// </summary>
/// <returns></returns>
public virtual IList<BeheerContextEntity> GetEntities()
{
if(m_Master==null)
{
m_Master = TrefwoordService.GetMaster();
}
if (m_Master != null)
{
var result = m_Master.Details;
return result;
}
return null;
}
public void OnViewLoadedSetsBusinessObjectenIntheView()
{
//Arrange
var controller = new MockCategorieController();
var beheerObject = new BeheerContextEntity { DataKeyValue = "test1" };
controller.MockBusinessentity.Add(beheerObject);
var presenter = new CategorieenPresenter(controller);
var view= new MockCategorieenView();
presenter.View = view;
//Act
presenter.OnViewLoaded();
//Assert
Assert.AreEqual(1, view.BusinessEntities.Count);
Assert.AreSame(beheerObject, view.BusinessEntities[view.BusinessEntities.Count - 1]);
}
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);
}
/// <summary>
/// Dit geldt alleen voor inline insert van Trefwoord.
/// </summary>
protected void AccepteerTrefwoord()
{
int i;
if (Int32.TryParse(Request.Form["RowId"], out i))
{
var detail = m_ListDetailsEntities[i - 1];// m_Presenter.m_ListDetails[i - 1];// m_ListDetailsEntities[i - 1]
var updatedMaster = new BeheerContextEntity
{
Id = detail.MasterId,
DataKeyValue = detail.Master
};
var trefwoord = new BeheerContextEntity
{
Id = -3, //-1 = geen trefwoord, -2 = lege tabel, -3 = nieuw trefwoord.
DataKeyValue = Request.Form["InlineInsert"],
Master = detail.Master,
MasterId = detail.MasterId,
Parent = new ParentKeyEntity
{
Id = detail.MasterId,
DataKeyValue = detail.Master
}
};
updatedMaster.Details.Add(trefwoord);
m_Presenter.OnBusinessEntityUpdated(updatedMaster);
m_Presenter.OnViewLoaded();
}
else
{
//TODO: this.ErrorMessages["TxtBox1"] = "Input data is not an integer";
}
}
public override void AddDetail(BeheerContextEntity detail)
{
MockBusinessentity[0].Details.Add(detail);
}
public int Insert(ParentKeyEntity masterForeignKey, BeheerContextEntity newBusinessObject)
{
int rowsAffected = 0;
using (OracleConnection conn = new OracleConnection(_oradb))
{
conn.Open();
var trans = conn.BeginTransaction();
try
{
string sqlUpdate =
@"INSERT INTO {0}
({1}, {3})
VALUES
('{2}','{4}')
";
sqlUpdate = string.Format(sqlUpdate,
newBusinessObject.Tablename,
newBusinessObject.DataKeyName,
newBusinessObject.DataKeyValue,
masterForeignKey.DataKeyName,
masterForeignKey.DataKeyValue);
var cmd = new OracleCommand
{
Connection = conn,
CommandText = sqlUpdate,
CommandType = CommandType.Text
};
cmd.Connection = conn;
rowsAffected = cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
return rowsAffected;
}
/// <summary>
/// Na Delete wordt het aantal verwijderde rijen teruggegeven.
/// </summary>
/// <param name="businessObject"></param>
/// <returns></returns>
public int Delete(BeheerContextEntity businessObject)
{
int rowsaffected = 0;
using (OracleConnection conn = new OracleConnection(_oradb))
{
conn.Open();
var trans = conn.BeginTransaction();
try
{
string sqlUpdate =
@"
DELETE FROM {0}
WHERE {1} = '{2}'
";
sqlUpdate = string.Format(sqlUpdate, businessObject.Tablename,
businessObject.DataKeyName, businessObject.DataKeyValue);
var cmd = new OracleCommand
{
Connection = conn,
CommandText = sqlUpdate,
CommandType = CommandType.Text
};
cmd.Connection = conn;
rowsaffected = cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
return rowsaffected;
}
// TODO: Forward events to the presenter and show state to the user.
// For examples of this, see the View-Presenter (with Application Controller) QuickStart:
// ms-help://MS.VSCC.v80/MS.VSIPCC.v80/ms.practices.wcsf.2007oct/wcsf/html/08da6294-8a4e-46b2-8bbe-ec94c06f1c30.html
protected void TrefwoordTableDataSource_Inserted(object sender, ObjectContainerDataSourceStatusEventArgs e)
{
BeheerContextEntity trefwoord = new BeheerContextEntity();
trefwoord = e.Instance as BeheerContextEntity;
if (trefwoord != null)
{
trefwoord.Tablename = "trefwoord";
trefwoord.DataKeyName = "trefwoord";
m_Presenter.OnBusinessEntityAdded(trefwoord);
}
AllowCrud = true;
}
protected void BtnSaveFooter_Click(object sender, ImageClickEventArgs e)
{
var footer = TrefwoordView.FooterRow;
var categorie = footer.FindControl("tbCategorieFooter") as TextBox;
BeheerContextEntity master = new BeheerContextEntity
{
DataKeyValue = categorie.Text
};
var trefwoord = footer.FindControl("tbTrefwoordInsertFooter") as TextBox;
BeheerContextEntity detail = null;
if (trefwoord != null && !string.IsNullOrEmpty(trefwoord.Text))
{
detail = new BeheerContextEntity
{
Id = -1,
DataKeyValue = trefwoord.Text,
Master = master.DataKeyValue
};
master.Details.Add(detail);
}
var found = m_ListBeheerEntities.Where(cat => cat.DataKeyValue.Equals(master.DataKeyValue)).FirstOrDefault();
if(found==null)
{
m_Presenter.OnBusinessEntityAdded(master);
if (detail != null && trefwoord != null && !string.IsNullOrEmpty(trefwoord.Text))
{
m_Presenter.OnDetailEntityUpdated(detail);
}
m_Presenter.OnViewLoaded();
}
else
{
m_Presenter.DuplicateMaster = new StateValue<BeheerContextEntity>(master);
m_Presenter.OnViewShowErrorMessage("<b>" + master.DataKeyValue + " bestaat al. Dubbele categorieen zijn niet toegestaan.</b>");
m_Presenter.OnViewShowfooter(true);
m_Presenter.OnViewLoaded();//ondataboundchecks
}
}
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 Datasettest()
{
var target = new OracleAccess();
var themaNew = new BeheerContextEntity
{
DataKeyValue = "aaaDwight" + DateTime.Now,
Tablename = "thema",
DataKeyName = "themanaam"
};
string qry = @"select id, {0} from {1} where {0} = '{2}'";
qry = string.Format(CultureInfo.InvariantCulture, qry, themaNew.DataKeyName, themaNew.Tablename,
themaNew.DataKeyValue);
int rowsAffected = target.Insert(themaNew);
var ds = target.GetDaBusinessObject(qry,themaNew);
}
protected void TrefwoordenTableDatasource_Updated(object sender, ObjectContainerDataSourceStatusEventArgs e)
{
BeheerContextEntity trefwoord = new BeheerContextEntity();
trefwoord = e.Instance as BeheerContextEntity;
if (!m_IsInsertingInline)
{
if (trefwoord != null)
{
trefwoord.DataKeyValue = trefwoord.DataKeyValue.Trim();
trefwoord.Tablename = "trefwoord";
trefwoord.DataKeyName = "trefwoord";
//var detail = m_ListDetailsEntities.Where(det => det.Id == trefwoord.Id).FirstOrDefault();
var master = m_ListBeheerEntities.Where(mas => mas.Id == trefwoord.MasterId).FirstOrDefault();
var updatedMaster = new BeheerContextEntity
{
Id = master.Id,
DataKeyValue = trefwoord.Master//update de master.
};
trefwoord.Parent= new ParentKeyEntity
{
Id = master.Id,
DataKeyValue = master.DataKeyValue
};
if (trefwoord.Id == -1 && !trefwoord.DataKeyValue.Equals(string.Empty))
{
//-1 = geen trefwoord, -2 = lege tabel, -3 = nieuw trefwoord.
trefwoord.Id = -3;
updatedMaster.Details.Add(trefwoord);
m_Presenter.OnBusinessEntityUpdated(updatedMaster);
}
else
m_Presenter.OnDetailEntityUpdated(trefwoord);
}
}
else
{
#region inline insert trefwoord gebruikt een selectedrow
int selectedIndex = TrefwoordView.SelectedIndex;
GridViewRow row = TrefwoordView.Rows[selectedIndex];
var tbCategorie = row.FindControl("tbCategorie") as TextBox;
var tbTrefwoordInline = TrefwoordView.Rows[selectedIndex].FindControl("TrefwoordTextBoxInline") as TextBox;
var master = m_ListBeheerEntities.Where(mas => mas.DataKeyValue == tbCategorie.Text).FirstOrDefault();
var updatedMaster = new BeheerContextEntity
{
Id = master.Id,
DataKeyValue = master.DataKeyValue
};
trefwoord = new BeheerContextEntity
{
Id = -3, //-1 = geen trefwoord, -2 = lege tabel, -3 = nieuw trefwoord.
DataKeyValue = tbTrefwoordInline.Text,
Master = master.DataKeyValue,
MasterId = master.Id,
Parent = new ParentKeyEntity
{
Id = master.Id,
DataKeyValue = master.DataKeyValue
}
};
updatedMaster.Details.Add(trefwoord);
m_Presenter.OnBusinessEntityUpdated(updatedMaster);
#endregion
TrefwoordView.SelectedIndex = -1;
}
m_Presenter.OnViewLoaded();
}
public static BeheerContextEntity FindBusinessEntity(IList<BeheerContextEntity> entities,
BeheerContextEntity entity)
{
// <pex>
if (Equals(entity, default(BeheerContextEntity)))
throw new ArgumentNullException("entity");
// </pex>
IEnumerable<BeheerContextEntity> result;
if (entities != null)
{
result = entities.Where(businessObject => businessObject.Id.Equals(entity.Id));
return result.FirstOrDefault();
}
return null;
}
public void UpdateDetailBusinessEntity(BeheerContextEntity updatedDetail)
{
// <pex>
if (updatedDetail == null)
throw new ArgumentNullException("updatedDetail");
// </pex>
var master = m_BusinessEntities.Where(mas => mas.DataKeyValue == updatedDetail.Master).FirstOrDefault();
var details = master.Details;
var found = FindBusinessEntity(details, updatedDetail);
if (found != null)
{
details.Where(detail => detail.Id == found.Id).
Update( detail =>
{
detail.DataKeyValue = updatedDetail.DataKeyValue;
});
}
}
public void DeleteDetailBusinessEntity(BeheerContextEntity detail)
{
var master = m_BusinessEntities.Where(mas => mas.DataKeyValue == detail.Master).FirstOrDefault();
var details = master.Details;
var found = FindBusinessEntity(details, detail);
if (found != null)
{
details.Remove(found);
}
}
public void AddDetailBusinessEntity(BeheerContextEntity detail)
{
var master = m_BusinessEntities.Where(mas => mas.Id == detail.Parent.Id).FirstOrDefault();
var details = master.Details;
var found = FindBusinessEntity(details, detail);
if (found == null)
{
detail.Id = m_Id;
details.Add(detail);
m_Id++;
}
}
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 DataSet GetDaBusinessObject(string qry, BeheerContextEntity beheerObject)
{
using (var conn = new OracleConnection(_oradb))
{
DataSet myDs = new DataSet();
conn.Open();
var cmd = new OracleCommand
{
Connection = conn,
CommandText = qry,
CommandType = CommandType.Text
};
cmd.Connection = conn;
OracleDataAdapter dataAdapter = new OracleDataAdapter(cmd);
dataAdapter.Fill(myDs);
return myDs;
}
}
public void Datasettest2()
{
var target = new MyAccess<OracleConnection, OracleCommand, OracleDataAdapter>();
var themaNew = new BeheerContextEntity
{
DataKeyValue = "aaaDwight" + DateTime.Now,
Tablename = "thema",
DataKeyName = "themanaam"
};
string qry = @"select id, {0} from {1} where {0} = '{2}'";
qry = string.Format(CultureInfo.InvariantCulture, qry, themaNew.DataKeyName, themaNew.Tablename,
themaNew.DataKeyValue);
target.Insert(themaNew);
var ds = target.GetDaBusinessObject(qry, themaNew);
Assert.AreEqual(themaNew.DataKeyValue, ds.Tables[0].Rows[0].ItemArray[1].ToString());
}
public IList<BeheerContextEntity> GetBusinessObjects(string tableName, string kolomName)
{
var theTables = new List<BeheerContextEntity>();
using (OracleConnection conn = new OracleConnection(_oradb))
{
conn.Open();
var cmd = new OracleCommand
{
Connection = conn,
CommandText = "select "+ kolomName + " from " + tableName +
" order by " + kolomName,
CommandType = CommandType.Text
};
cmd.Connection = conn;
var reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
int i = 0;
while (smartReader.Read())
{
BeheerContextEntity aTable = new BeheerContextEntity
{
Id = i++,
DataKeyValue = smartReader.GetString(kolomName, ""),
Tablename = tableName,
DataKeyName = kolomName
};
theTables.Add(aTable);
}
return theTables;
}
}
/// <summary>
/// Na Update wordt het aantal bijgewerkte rijen teruggegeven.
/// </summary>
/// <param name="oldBusinessObject"></param>
/// <param name="newBusinessObject"></param>
/// <returns></returns>
public int Update(BeheerContextEntity oldBusinessObject, BeheerContextEntity newBusinessObject)
{
int rowsAffected = 0;
using (OracleConnection conn = new OracleConnection(_oradb))
{
string sqlUpdate = "update {0} set {1} ='{2}' where {1} = '{3}'";
string tableName = oldBusinessObject.Tablename;
string columnName = oldBusinessObject.DataKeyName;
sqlUpdate = string.Format(sqlUpdate,
tableName,
columnName,
newBusinessObject.DataKeyValue,
oldBusinessObject.DataKeyValue);
conn.Open();
var trans = conn.BeginTransaction();
try
{
var cmd = new OracleCommand
{
Connection = conn,
CommandText = sqlUpdate,
CommandType = CommandType.Text
};
cmd.Connection = conn;
rowsAffected = cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
return rowsAffected;
}
protected void TrefwoordenTableDatasource_Deleted(object sender, ObjectContainerDataSourceStatusEventArgs e)
{
BeheerContextEntity trefwoord = new BeheerContextEntity();
trefwoord = e.Instance as BeheerContextEntity;
if (trefwoord != null)
{
if (m_DeleteAlleenTrefwoord)
{
trefwoord.Tablename = "trefwoord";
trefwoord.DataKeyName = "trefwoord";
m_Presenter.OnDetailEntityDeleted(trefwoord);
}
else
{
//Verwijder de master/categorie.
var detail = trefwoord;
BeheerContextEntity categorie;
//Haal gegevens op van de master.
string naam = detail.Master;
var master = m_ListBeheerEntities.Where(cat => cat.DataKeyValue == naam).FirstOrDefault();
categorie = new BeheerContextEntity
{
DataKeyValue = naam,
Id = master.Id
};
m_Presenter.OnBusinessEntityDeleted(categorie);
}
}
m_Presenter.OnViewLoaded();
}
