public override Annee find(string nom)
{
Annee annee = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_departement, description FROM annee 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 <Departement> TPSQL = factoSQL.getDepartementDAO();
Departement dep2 = TPSQL.find(reader_f.GetInt32(2));
annee = new Annee(reader_f.GetInt32(0), reader_f.GetString(1), dep2, reader_f.GetString(3));
}
}
reader_f.Close();
}
// Connexion.getInstance().Close();
return(annee);
}
}
public override List <InfosAssignation> findAll()
{
List <InfosAssignation> IAs = new List <InfosAssignation>();
using (SqlCommand command_f = new SqlCommand("SELECT * FROM infos_assignation;", 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 <EC> TPSQLEC = factoSQL.getECDAO();
DAO <TypeCours> TPSQLTP = factoSQL.getTypeCoursDao();
DAO <Enseignant> TPSQLEns = factoSQL.getEnseignantDAO();
EC ec = TPSQLEC.find(reader_f.GetInt32(2));
TypeCours tp = reader_f.IsDBNull(3) ? default(TypeCours) : TPSQLTP.find(reader_f.GetInt32(3));
Enseignant ens = reader_f.IsDBNull(4) ? default(Enseignant) : TPSQLEns.find(reader_f.GetInt32(4));
IAs.Add(new InfosAssignation(reader_f.GetInt32(0), reader_f.GetString(1), ec, tp, ens, reader_f.GetDouble(5)));
}
}
}
}
return(IAs);
}
public override List <Enseignant> findAll()
{
List <Enseignant> enss = new List <Enseignant>();
using (SqlCommand command_f = new SqlCommand("SELECT * FROM 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 <Categorie> TPSQL = factoSQL.getCategorieDAO();
Categorie categ2 = TPSQL.find(reader_f.GetInt32(4));
enss.Add(new Enseignant(reader_f.GetInt32(0), reader_f.GetString(1), reader_f.GetString(2), reader_f.GetDouble(3), categ2, reader_f.GetString(5)));
}
}
}
}
return(enss);
}
public override List <Annee> findAll()
{
List <Annee> ans = new List <Annee>();
using (SqlCommand command_f = new SqlCommand("SELECT * FROM annee;", 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 <Departement> TPSQL = factoSQL.getDepartementDAO();
Departement dep2 = TPSQL.find(reader_f.GetInt32(2));
ans.Add(new Annee(reader_f.GetInt32(0), reader_f.GetString(1), dep2, reader_f.GetString(3)));
}
}
}
}
return(ans);
}
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 Enseignant find(string nom)
{
Enseignant ens = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, prenom, nb_heures_assignees, id_categorie_enseignant, image FROM enseignant 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 <Categorie> TPSQL = factoSQL.getCategorieDAO();
Categorie categ2 = TPSQL.find(reader_f.GetInt32(4));
ens = new Enseignant(reader_f.GetInt32(0), reader_f.GetString(1), reader_f.GetString(2), reader_f.GetDouble(3), categ2, reader_f.GetString(5));
reader_f.NextResult();
}
}
reader_f.Close();
}
}
return(ens);
}
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);
}
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 InfosAssignation find(string nom)
{
InfosAssignation IA = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_ec, id_typecours, id_enseignant, nb_heures FROM infos_assignation 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 <EC> TPSQLEC = factoSQL.getECDAO();
DAO <TypeCours> TPSQLTP = factoSQL.getTypeCoursDao();
DAO <Enseignant> TPSQLEns = factoSQL.getEnseignantDAO();
EC ec = TPSQLEC.find(reader_f.GetInt32(2));
TypeCours tp = TPSQLTP.find(reader_f.GetInt32(3));
Enseignant ens = TPSQLEns.find(reader_f.GetInt32(4));
IA = new InfosAssignation(reader_f.GetInt32(0), reader_f.GetString(1), ec, tp, ens, reader_f.GetDouble(5));
}
}
reader_f.Close();
}
// Connexion.getInstance().Close();
return(IA);
}
}
public override Annee find(int id)
{
Annee annee = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_departement, description FROM annee 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 <Departement> TPSQL = factoSQL.getDepartementDAO();
Departement dep2 = TPSQL.find(reader_f.GetInt32(2));
annee = new Annee(reader_f.GetInt32(0), reader_f.GetString(1), dep2, reader_f.GetString(3));
reader_f.NextResult();
}
}
else
{
throw new Exception("Aucun objet avec cet id n'a été trouvé.");
}
reader_f.Close();
}
}
return(annee);
}
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(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 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 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);
}
public override InfosAssignation find(int id)
{
InfosAssignation IA = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_ec, id_typecours, id_enseignant, nb_heures FROM infos_assignation 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 <EC> TPSQLEC = factoSQL.getECDAO();
DAO <TypeCours> TPSQLTP = factoSQL.getTypeCoursDao();
DAO <Enseignant> TPSQLEns = factoSQL.getEnseignantDAO();
EC ec = TPSQLEC.find(reader_f.GetInt32(2));
TypeCours tp = TPSQLTP.find(reader_f.GetInt32(3));
Enseignant ens = TPSQLEns.find(reader_f.GetInt32(4));
IA = new InfosAssignation(reader_f.GetInt32(0), reader_f.GetString(1), ec, tp, ens, reader_f.GetDouble(5));
reader_f.NextResult();
}
}
else
{
throw new Exception("Aucun objet avec cet id n'a été trouvé.");
}
reader_f.Close();
}
}
return(IA);
}
ServiceFacade()
{
rateDao = AbstractDAOFactory.getFactory().getRateDAO();
moviesDao = AbstractDAOFactory.getFactory().getMovieDAO();
userDao = AbstractDAOFactory.getFactory().getUserDAO();
}
/// <summary>
/// Initialise l'objet d'application de singleton. Il s'agit de la première ligne du code créé
/// à être exécutée. Elle correspond donc à l'équivalent logique de main() ou WinMain().
/// </summary>
///
public App()
{
Connexion connexion = new Connexion();
connexion.creerConnexion();
AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY);
DAO <Categorie> categorie = factoSQL.getCategorieDAO();
Categorie categorieDefaut = new Categorie {
Id = 1, Nom = "Catégorie par défaut", Heures = 0
};
if (!(categorie.find(categorieDefaut.Id).Id == 1))
{
categorie.create(categorieDefaut);
}
//TypeCours CM = new TypeCours { Id = 1, Nom = "CM", Groupes = 1};
//if (!(typeCours.find(CM.Nom) is TypeCours))
// typeCours.create(CM);
//TypeCours TD = new TypeCours { Id = 2, Nom = "TD", Groupes = 2 };
//if (!(typeCours.find(TD.Nom) is TypeCours))
// typeCours.create(TD);
//TypeCours TP = new TypeCours { Id = 3, Nom = "TP", Groupes = 2 };
//if (!(typeCours.find(TP.Nom) is TypeCours))
// typeCours.create(TP);
/*TypeCours tp = new TypeCours("TP", true);
* Categorie maitreDeConference = new Categorie("maitre de conférences", 240);
* Departement dpt = new Departement("Informatique");
* Departement dpt2 = new Departement("Informatique2");
* AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY);
*
* DAO<Departement> depart = factoSQL.getDepartementDAO();
* //depart.create(dpt2);
*
* DAO<Annee> an = factoSQL.getAnneeDAO();
* an.create(new Annee("M1", depart.find(1)));
* an.create(new Annee("M2", depart.find(1)));
* an.create(new Annee("M3", depart.find(2)));
*
* DAO<PartieAnnee> pan = factoSQL.getPartieAnneeDAO();
* PartieAnnee test = new PartieAnnee("Semestre 1", an.find(1));
* pan.create(test);
* pan.create(new PartieAnnee("Semestre 2", an.find(1)));
* pan.create(new PartieAnnee("Semestre 3", an.find(2)));
*
* DAO<Enseignement> en = factoSQL.getEnseignementDAO();
* en.create(new Enseignement("EC1", pan.find(1)));
*
* //Console.WriteLine(maitreDeConference);
* //Console.ReadLine();
* DAO<Categorie> categorie = factoSQL.getCategorieDAO();
* categorie.create(new Categorie("maitre de conference", 130));
*
*
* DAO<Enseignant> ens = factoSQL.getEnseignantDAO();
* ens.create(new Enseignant("John", "Bob", categorie.find(1)));
* ens.create(new Enseignant("Bobby", "Malik", categorie.find(1)));
* ens.create(new Enseignant("Benoit", "Martin", categorie.find(1)));
* ens.create(new Enseignant("Make", "Crelo", categorie.find(1)));*/
Connexion.getInstance().Close();
this.InitializeComponent();
this.Suspending += OnSuspending;
}