// UPDATED BY HERON (id_abstract is now a key) public IList<InterfaceParameter> list(int id_abstract, string id_interface) { InterfaceParameter i = null; IList<InterfaceParameter> iList = new List<InterfaceParameter>(); IDbConnection dbcon = Connector.DBcon; IDbCommand dbcmd = dbcon.CreateCommand(); string sql = "SELECT id_interface, id_abstract, varid, parid, id_interface_parameter, id_unit_parameter, par_order " + "FROM interfaceparameters "+ "WHERE id_interface like '" + id_interface + "' AND " + "id_abstract=" + id_abstract + " ORDER BY par_order"; dbcmd.CommandText = sql; Console.WriteLine (sql); IDataReader reader = dbcmd.ExecuteReader(); while (reader.Read()) { i = new InterfaceParameter(); i.Id_interface = (string)reader["id_interface"]; i.Id_abstract = (int)reader["id_abstract"]; i.ParId = (string)reader["parid"]; i.VarId = (string)reader["varid"]; i.Id_interface_parameter = (string)reader["id_interface_parameter"]; i.Id_unit_parameter =(string)reader["id_unit_parameter"]; i.ParOrder = (int)reader["par_order"]; iList.Add(i); } // clean up reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; return iList; }
public void insert(InterfaceParameter ac) { String sql = "INSERT INTO interfaceparameters (id_interface, id_abstract, varid, parid, id_interface_parameter, id_unit_parameter, par_order)" + " VALUES ('" + ac.Id_interface + "'," + ac.Id_abstract + ",'" + ac.VarId + "','" + ac.ParId + "','" + ac.Id_interface_parameter + "','" + ac.Id_unit_parameter + "'," + ac.ParOrder + ")"; Console.WriteLine("InterfaceParameter.cs: TRY INSERT: " + sql); Connector.performSQLUpdate(sql); }
public InterfaceParameter retrieveByOrder(int id_abstract, string id_interface, int pos){ InterfaceParameter i = null; IDbConnection dbcon = Connector.DBcon; IDbCommand dbcmd = dbcon.CreateCommand(); string sql = "SELECT id_interface, id_abstract, varid, parid, id_interface_parameter, id_unit_parameter, par_order " + "FROM interfaceparameters "+ "WHERE id_interface like '" + id_interface + "' AND " + "id_abstract=" + id_abstract + " AND " + "par_order = " + pos ; dbcmd.CommandText = sql; IDataReader reader = dbcmd.ExecuteReader(); if (reader.Read()) { i = new InterfaceParameter(); i.Id_interface = (string)reader["id_interface"]; i.Id_abstract = (int)reader["id_abstract"]; i.ParId = (string)reader["parid"]; i.VarId = (string)reader["varid"]; i.Id_interface_parameter = (string)reader["id_interface_parameter"]; i.Id_unit_parameter =(string)reader["id_unit_parameter"]; i.ParOrder = (int)reader["par_order"]; // i.ExternalReferences = } else { // UNIT NOT FOUND } // clean up reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; return i; }