public override List <EC> findAll() { List <EC> ECs = new List <EC>(); using (SqlCommand command_f = new SqlCommand("SELECT * FROM ec;", Connexion.getInstance())) { using (SqlDataReader reader_f = command_f.ExecuteReader()) { if (reader_f.HasRows) { while (reader_f.Read()) { AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY); DAO <Enseignement> TPSQL = factoSQL.getEnseignementDAO(); Enseignement ens = TPSQL.find(reader_f.GetInt32(2)); ECs.Add(new EC(reader_f.GetInt32(0), reader_f.GetString(1), ens)); } } } } return(ECs); }
public override EC find(int id) { EC ec = null; using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_enseignement FROM ec WHERE id=" + id + ";", Connexion.getInstance())) { using (SqlDataReader reader_f = command_f.ExecuteReader()) { if (reader_f.HasRows) { while (reader_f.Read()) { AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY); DAO <Enseignement> TPSQL = factoSQL.getEnseignementDAO(); Enseignement ens = TPSQL.find(reader_f.GetInt32(2)); ec = new EC(reader_f.GetInt32(0), reader_f.GetString(1), ens); reader_f.NextResult(); } } else { throw new Exception("Aucun objet avec cet id n'a été trouvé."); } reader_f.Close(); } } return(ec); }
public override EC find(string nom) { EC ec = null; using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_enseignement FROM ec WHERE nom='" + nom + "';", Connexion.getInstance())) { using (SqlDataReader reader_f = command_f.ExecuteReader()) { if (reader_f.HasRows) { while (reader_f.Read()) { AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY); DAO <Enseignement> TPSQL = factoSQL.getEnseignementDAO(); Enseignement ens = TPSQL.find(reader_f.GetInt32(2)); ec = new EC(reader_f.GetInt32(0), reader_f.GetString(1), ens); reader_f.NextResult(); } } reader_f.Close(); } } return(ec); }
public override List <EnseignementEnseignant> findAll() { List <EnseignementEnseignant> enss = new List <EnseignementEnseignant>(); using (SqlCommand command_f = new SqlCommand("SELECT * FROM enseignement_enseignant;", Connexion.getInstance())) { using (SqlDataReader reader_f = command_f.ExecuteReader()) { if (reader_f.HasRows) { while (reader_f.Read()) { AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY); DAO <Enseignement> TPSQL = factoSQL.getEnseignementDAO(); DAO <Enseignant> TPSQL2 = factoSQL.getEnseignantDAO(); Enseignement ensfacto = TPSQL.find(reader_f.GetInt32(1)); Enseignant ensfacto2 = TPSQL2.find(reader_f.GetInt32(2)); enss.Add(new EnseignementEnseignant(reader_f.GetInt32(0), ensfacto, ensfacto2)); } } } } return(enss); }