public InnerConcreteComponent retrieve(int id_concrete, string id_inner, int id_index)
{
InnerConcreteComponent c = null;
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT id_concrete, id_inner, id_index, id_concrete_actual " +
"FROM innerconcrete " +
"WHERE id_concrete=" + id_concrete + " AND " +
"id_inner like '" + id_inner + "' AND " +
"id_index=" + id_index;
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
if (reader.Read())
{
c = new InnerConcreteComponent();
c.Id_concrete = (int)reader["id_concrete"];
c.Id_inner = (string)reader["id_inner"];
c.Id_index = (int)reader["id_index"];
c.Id_concrete_actual = (int)reader["id_concrete_actual"];
}//if
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
return(c);
}
public IList <InnerConcreteComponent> retrieveEnumeration(int id_concrete, string id_inner)
{
InnerConcreteComponent c = null;
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
IList <InnerConcreteComponent> l = new List <InnerConcreteComponent>();
string sql =
"SELECT id_concrete, id_inner, id_index, id_concrete_actual " +
"FROM innerconcrete " +
"WHERE id_concrete=" + id_concrete + " AND " +
"id_inner like '" + id_inner;
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while (reader.Read())
{
c = new InnerConcreteComponent();
c.Id_concrete = (int)reader["id_concrete"];
c.Id_inner = (string)reader["id_inner"];
c.Id_index = (int)reader["id_index"];
c.Id_concrete_actual = (int)reader["id_concrete_actual"];
l.Add(c);
}//while
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
return(l);
}
public void insert(InnerConcreteComponent ac)
{
String sql =
"INSERT INTO innerconcrete (id_concrete, id_inner, id_index, id_concrete_actual)" +
" VALUES (" + ac.Id_concrete + ",'" + ac.Id_inner + "'," + ac.Id_index + "," + ac.Id_concrete_actual + ")";
Connector.performSQLUpdate(sql);
}