}//list
internal InnerComponentExposed retrieve(int id_abstract, string id_inner_container, string id_inner_rename)
{
InnerComponentExposed ice = null ;
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
"FROM innercomponentexposed " +
"WHERE id_abstract=" + id_abstract + " AND " +
"id_inner_rename like '" + id_inner_rename + "' AND " +
"id_inner_owner like '" + id_inner_container + "'";
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
if (reader.Read())
{
ice = new InnerComponentExposed();
ice.Id_abstract = (int)reader["id_abstract"];
ice.Id_inner_rename = (string)reader["id_inner_rename"];
ice.Id_inner_owner = (string)reader["id_inner_owner"];
ice.Id_inner = (string)reader["id_inner"];
}//while
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
return ice;
}
}//list
public IList<InnerComponentExposed> listOwnerOfExposedInner(int id_abstract, string id_inner_rename)
{
IList<InnerComponentExposed> list = new List<InnerComponentExposed>();
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
"FROM innercomponentexposed " +
"WHERE id_abstract=" + id_abstract + " AND " +
"id_inner_rename like '" + id_inner_rename + "'";
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
Console.WriteLine ("listOwnerOfExposedInner: " + sql);
while (reader.Read())
{
InnerComponentExposed ic = new InnerComponentExposed();
ic.Id_abstract = (int)reader["id_abstract"];
ic.Id_inner_rename = (string)reader["id_inner_rename"];
ic.Id_inner_owner = (string)reader["id_inner_owner"];
ic.Id_inner = (string)reader["id_inner"];
list.Add(ic);
}//while
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
return list;
}//list
public void insert(InnerComponentExposed ac)
{
String sql =
"INSERT INTO innercomponentexposed (id_abstract, id_inner_rename, id_inner_owner, id_inner)" +
" VALUES (" + ac.Id_abstract + ",'" + ac.Id_inner_rename + "','" + ac.Id_inner_owner + "','" + ac.Id_inner + "')";
Console.WriteLine("InnerComponentExposedDAO.cs: TRY INSERT PUBLIC INNER COMPONENT :" + sql);
Connector.performSQLUpdate(sql);
}
internal IList<InnerComponentExposed> retrieveContainerList(int id_abstract_start, string id_inner_owner, string id_inner)
{
int id_abstract = id_abstract_start;
IList<InnerComponentExposed> iceList = new List<InnerComponentExposed>();
InnerComponentExposed ice = null;
while (id_abstract > 0)
{
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT id_abstract, id_inner_rename, id_inner_owner, id_inner " +
"FROM innercomponentexposed " +
"WHERE id_abstract=" + id_abstract + " AND " +
"id_inner like '" + id_inner + "' AND " +
"id_inner_owner like '" + id_inner_owner + "'";
Console.WriteLine("retrieveContainer: " + sql);
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while (reader.Read())
{
ice = new InnerComponentExposed();
ice.Id_abstract = (int)reader["id_abstract"];
ice.Id_inner_rename = (string)reader["id_inner_rename"];
ice.Id_inner_owner = (string)reader["id_inner_owner"];
ice.Id_inner = (string)reader["id_inner"];
iceList.Add(ice);
}//while
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
if (ice == null)
{
AbstractComponentFunctor acf = br.ufc.pargo.hpe.backend.DGAC.BackEnd.acfdao.retrieve(id_abstract);
if (acf.Id_functor_app_supertype > 0)
{
AbstractComponentFunctorApplication acfa = br.ufc.pargo.hpe.backend.DGAC.BackEnd.acfadao.retrieve(acf.Id_functor_app_supertype);
id_abstract = acfa.Id_abstract;
}
else
id_abstract = -1;
}
else
id_abstract = -1;
}
return iceList;
}
