public override Enseignement find(string nom) { Enseignement ens = null; using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_partie_annee, description FROM enseignement 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 <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO(); PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2)); ens = new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3)); reader_f.NextResult(); } } reader_f.Close(); } } return(ens); }
public override List <Enseignement> findAll() { List <Enseignement> enses = new List <Enseignement>(); using (SqlCommand command_f = new SqlCommand("SELECT * FROM enseignement;", 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 <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO(); PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2)); enses.Add(new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3))); } } } } return(enses); }
public override Enseignement find(int id) { Enseignement ens = null; using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_partie_annee, description FROM enseignement 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 <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO(); PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2)); ens = new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3)); reader_f.NextResult(); } } else { throw new Exception("Aucun objet avec cet id n'a été trouvé."); } reader_f.Close(); } } return(ens); }