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