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);
}
