public SourceCodeReference retrieve(char type_owner, int id_owner_container, string id_owner, string filename, string reference)
{
SourceCodeReference sc = null;
IDbConnection dbcon = Connector.DBcon;
IDbCommand dbcmd = dbcon.CreateCommand();
string sql =
"SELECT type_owner, id_owner_container, id_owner, file_name, reference " +
"FROM sourcecode_references " +
"WHERE type_owner like '" + type_owner +
"' AND id_owner_container=" + id_owner_container +
" AND id_owner like '" + id_owner +
"' AND file_name like '" + filename +
"' AND reference like '" + reference + "'";
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
if (reader.Read())
{
sc = new SourceCodeReference();
sc.Type_owner = ((string)reader["type_owner"])[0];
sc.Id_owner_container = (int)reader["id_owner_container"];
sc.Id_owner = (string)reader["id_owner"];
sc.File_name = (string)reader["file_name"];
sc.Reference = (string)reader["reference"];
}//while
// clean up
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
return(sc);
}//retrieve
public void insert(SourceCodeReference ac)
{
String sql =
"INSERT INTO sourcecode_references (type_owner, id_owner_container, id_owner, file_name, reference)" +
" VALUES ('" + ac.Type_owner + "'," + ac.Id_owner_container + ",'" + ac.Id_owner + "','" + ac.File_name + "','" + ac.Reference + "')";
Connector.performSQLUpdate(sql);
}
}//retrieve
internal void update(SourceCodeReference ss)
{
String sql =
"UPDATE sourcecode_references SET reference = '" + ss.Reference + "' WHERE type_owner like '" + ss.Type_owner + "'"
+ " and id_owner like '" + ss.Id_owner + "'"
+ " and file_name like '" + ss.File_name + "'"
+ " and id_owner_container = " + ss.Id_owner_container;
Connector.performSQLUpdate(sql);
}
}//list
public SourceCodeReference retrieve(SourceCodeReference scr)
{
return(retrieve(scr.Type_owner, scr.Id_owner_container, scr.Id_owner, scr.File_name, scr.Reference));
}
