예제 #1
0
        public List <Stagiaire> Select()
        {
            List <Stagiaire> ListStagiaires = new List <Stagiaire>();
            String           Requete        = "Select * from Stagiaires where etat =1";
            OleDbDataReader  read           = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Stagiaire s = new Stagiaire();
                s.Id            = read.GetInt32(0);
                s.Filiere       = new FiliereDAO().FindById(read.GetInt32(1));
                s.Nom           = (string)read["Nom"];
                s.Prenom        = (string)read["Prenom"];
                s.DateNaissance = (DateTime)read["DateNaissance"];
                s.Sexe          = read.GetBoolean(5);
                s.Cin           = read.GetString(6);
                s.Email         = read.GetString(7);
                s.Telephone     = read.GetString(8);
                s.Adresse       = read.GetString(9);
                s.ProfilImage   = read.GetString(10);
                s.Etat          = read.GetInt32(11);
                ListStagiaires.Add(s);
            }


            return(ListStagiaires);
        }
예제 #2
0
        public List <Stagiaire> SelectNotConfirm()
        {
            List <Stagiaire> ListStagiaires = new List <Stagiaire>();
            String           Requete        = "Select * from Stagiaires where etat =0";
            OleDbDataReader  read           = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Stagiaire s = new Stagiaire();
                s.Id            = read.GetInt32(0);
                s.Nom           = read.GetString(1);
                s.Prenom        = read.GetString(2);
                s.DateNaissance = read.GetDateTime(3);
                s.Sexe          = read.GetBoolean(4);
                s.Cin           = read.GetString(5);
                s.Email         = read.GetString(6);
                s.Telephone     = read.GetString(7);
                s.Adresse       = read.GetString(8);
                s.ProfilImage   = read.GetString(9);
                s.Etat          = read.GetInt32(10);
                s.Groupe        = new  GroupeDAO().FindById(read.GetInt32(11));
                ListStagiaires.Add(s);
            }


            return(ListStagiaires);
        }
예제 #3
0
        public List <Groupe> FindByGroup(Groupe g)
        {
            string Requete = "Select * from Groupes ";

            if (g.Code != "" || g.Nom != "" || g.Description != "" || g.Filiere.Titre != "")
            {
                Requete += " where ";
            }
            bool and = false;

            if (g.Code != "")
            {
                Requete += " Code like '%" + g.Code + "%'";
                and      = true;
            }
            if (g.Nom != "")
            {
                if (and)
                {
                    Requete += " and ";
                }
                Requete += " Nom like '%" + g.Nom + "%'";
                and      = true;
            }
            if (g.Description != "")
            {
                if (and)
                {
                    Requete += " and ";
                }
                Requete += " Description like '%" + g.Description + "%'";
                and      = true;
            }
            if (g.Filiere.Titre != "")
            {
                if (and)
                {
                    Requete += " and ";
                }
                Requete += " IdFiliere like '%" + g.Filiere.Id + "%'";
                and      = true;
            }

            List <Groupe>   ListGroupe = new List <Groupe> ();
            OleDbDataReader read       = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Groupe gr = new Groupe();
                gr.Id          = read.GetInt32(0);
                gr.Nom         = read.GetString(1);
                gr.Code        = read.GetString(2);
                gr.Description = read.GetString(3);
                gr.Filiere     = new FiliereDAO().FindById(read.GetInt32(4));
                ListGroupe.Add(gr);
            }
            MyConnection.Close();
            return(ListGroupe);
        }
        public Filiere FindByName(string Name)
        {
            string          Requete = "Select * from Filieres where Nom=" + Name;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);
            Filiere         f       = new Filiere();

            f.Id    = read.GetInt32(0);
            f.Code  = read.GetString(1);
            f.Titre = read.GetString(2);
            return(f);
        }
예제 #5
0
        public Formation FindById(int id)
        {
            string          Requete = "Select * from Formations where id=" + id;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);
            Formation       g       = new Formation();

            read.Read();
            g.Id = read.GetInt32(0);

            MyConnection.Close();
            return(g);
        }
예제 #6
0
        public List <AnneeFormation> select()
        {
            List <AnneeFormation> lstanneformation = new List <AnneeFormation>();
            string          rqt  = "select *from AnneeFormations";
            OleDbDataReader lire = MyConnection.ExecuteReader(rqt);

            while (lire.Read())
            {
                lstanneformation.Add(new AnneeFormation(lire.GetInt32(0), lire.GetString(1), lire.GetDateTime(2), lire.GetDateTime(3)));
            }
            return(lstanneformation);
        }
예제 #7
0
        public Module getModulepre(int id)
        {
            List <Module>   m   = new List <Module>();
            string          req = "Select * from [Module] where id = " + id;
            OleDbDataReader da  = MyConnection.ExecuteReader(req);

            while (da.Read())
            {
                m.Add(new Module(da.GetInt32(0), new PackageFilieres.FiliereDAO().FindById(da.GetInt32(1)), da.GetString(2), da.GetInt32(3), da.GetString(4), da.GetString(5), da.GetString(6), da.GetString(7), da.GetString(8), da.GetString(9), da.GetString(10), da.GetString(11), da.GetString(12)));
            }
            MyConnection.Close();
            return(m.ElementAt(0));
        }
예제 #8
0
        public List <Precision> GetallPres(int id)
        {
            List <Precision> p   = new List <Precision>();
            string           req = "Select * From [Precisions] where modules_id =" + id;
            OleDbDataReader  sqr = MyConnection.ExecuteReader(req);

            while (sqr.Read())
            {
                p.Add(new Precision(sqr.GetInt32(0), sqr.GetInt32(1), sqr.GetString(2), sqr.GetString(3), sqr.GetInt32(4), sqr.GetInt32(5), new ModuleDAO().FindById(sqr.GetInt32(6))));
            }
            MyConnection.Close();
            return(p);
        }
        public Filiere FindById(int id)
        {
            string          Requete = "Select * from Filieres where id=" + id;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);

            read.Read();
            Filiere f = new Filiere();

            f.Id    = read.GetInt32(0);
            f.Code  = read.GetString(1);
            f.Titre = read.GetString(2);
            return(f);
        }
        /// <summary>
        /// Recherche par Code, Titre, et Description
        /// </summary>
        /// <param name="filier"></param>
        /// <returns></returns>
        public List <Filiere> FindByFilier(Filiere filier)
        {
            string Requete = "Select * from Filieres ";

            if (filier.Code != "" || filier.Titre != "" || filier.Description != "")
            {
                Requete += " where ";
            }
            bool and = false;

            if (filier.Code != "")
            {
                Requete += " Code like '%" + filier.Code + "%'";
                and      = true;
            }
            if (filier.Titre != "")
            {
                if (and)
                {
                    Requete += " and ";
                }
                Requete += " Titre like '%" + filier.Titre + "%'";
                and      = true;
            }
            if (filier.Description != "")
            {
                if (and)
                {
                    Requete += " and ";
                }
                Requete += " Description like '%" + filier.Description + "%'";
                and      = true;
            }



            List <Filiere>  ListFiliere = new List <Filiere>();
            OleDbDataReader read        = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Filiere f = new Filiere();
                f.Id          = read.GetInt32(0);
                f.Titre       = read.GetString(1);
                f.Code        = read.GetString(2);
                f.Description = read.GetString(3);
                ListFiliere.Add(f);
            }
            MyConnection.Close();
            return(ListFiliere);
        }
예제 #11
0
        public Seanceplanning FindById(int id)
        {
            string          Requete = "Select * from SeancePlannings where id=" + id;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);

            read.Read();
            Seanceplanning f = new Seanceplanning();

            f.Id         = read.GetInt32(0);
            f.Jour       = read.GetString(1);
            f.Heuredebut = read.GetInt32(2);
            f.Heurefin   = read.GetInt32(3);
            return(f);
        }
예제 #12
0
        public List <Module> Select()
        {
            List <Module>   liste = new List <Module>();
            string          req   = "select * from Modules";
            OleDbDataReader da    = MyConnection.ExecuteReader(req);

            while (da.Read())
            {
                liste.Add(new Module(da.GetInt32(0), new PackageFilieres.FiliereDAO().FindById(da.GetInt32(1)), da.GetString(2), da.GetInt32(3), da.GetString(4), da.GetString(5), da.GetString(6), da.GetString(7), da.GetString(8), da.GetString(9), da.GetString(10), da.GetString(11), da.GetString(12)));
            }

            MyConnection.Close();
            return(liste);
        }
        public Groupe FindById(int id)
        {
            string          Requete = "Select * from Groupes where id=" + id;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);
            Groupe          g       = new Groupe();

            read.Read();
            g.Id      = read.GetInt32(0);
            g.Code    = read.GetString(1);
            g.Nom     = read.GetString(2);
            g.Filiere = new FiliereDAO().FindById(read.GetInt32(3));
            MyConnection.Close();
            return(g);
        }
예제 #14
0
        public List <Precision> Select()
        {
            List <Precision> p   = new List <Precision>();
            string           req = "Select * From Precisions";
            OleDbDataReader  sqr = MyConnection.ExecuteReader(req);

            while (sqr.Read())
            {
                p.Add(new Precision(sqr.GetInt32(0), sqr.GetInt32(1), sqr.GetString(2), sqr.GetString(3), sqr.GetInt32(4), sqr.GetInt32(5), new ModuleDAO().FindById(sqr.GetInt32(6))));
                // p.Add(new Precision(sqr.GetInt32(0), sqr.GetInt32(1), sqr.GetString(2), sqr.GetString(3), sqr.GetInt32(4), sqr.GetInt32(5),new ModuleDAO().FindById(sqr.GetInt32(6))));
            }
            MyConnection.Close();
            return(p);
        }
예제 #15
0
        public IEnumerable <IncrementationDB> SelectFromDB()
        {
            List <IncrementationDB> listIncrementationDB = new List <IncrementationDB>();
            string          query    = "Select * from VersionDB";
            OleDbDataReader listeRox = MyConnection.ExecuteReader(query);

            while (listeRox.Read())
            {
                IncrementationDB incrementationDB = new IncrementationDB();
                incrementationDB.Code = (string)listeRox["Version"];
                listIncrementationDB.Add(incrementationDB);
            }

            return(listIncrementationDB);
        }
예제 #16
0
        public List <Formation> select()
        {
            List <Formation> listformation = new List <Formation>();
            string           reqeute       = "select * from Formations";
            OleDbDataReader  lire          = MyConnection.ExecuteReader(reqeute);

            while (lire.Read())
            {
                listformation.Add(new Formation(1));
            }



            return(listformation);
        }
예제 #17
0
        public EmploisTemp FindById(int id)
        {
            string          Requete = "Select * from EmploisTemps where id=" + id;
            OleDbDataReader read    = MyConnection.ExecuteReader(Requete);

            read.Read();
            EmploisTemp f = new EmploisTemp();

            f.Id        = read.GetInt32(0);
            f.DateDebut = read.GetDateTime(1);
            f.DateFin   = read.GetDateTime(2);
            //   f.Anneeformation = read.GetDateTime(3);


            return(f);
        }
예제 #18
0
        public List <Module> findbyname(Module m)
        {
            string req = "select * from [modules]";

            if (m.Nom != "" || m.Description != "" || m.Id_f.Id != 0 || m.Duree != 0)
            {
                req += " where ";
            }
            bool and = false;

            if (m.Nom != "")
            {
                req += " nom like '%" + m.Nom + "%'";
                and  = true;
            }
            if (m.Id_f.Id != 0)
            {
                req += " and Filiere_id like '%" + m.Id_f.Id + "%'";
                and  = true;
            }

            if (m.Description != null)
            {
                if (and)
                {
                    req += " and description like '%" + m.Description + "%'";
                }
                and = true;
            }
            if (m.Duree != null)
            {
                if (and)
                {
                    req += " and duree like " + m.Duree;
                }
            }


            List <Module>   liste = new List <Module>();
            OleDbDataReader da    = MyConnection.ExecuteReader(req);

            while (da.Read())
            {
                liste.Add(new Module(da.GetInt32(0), new PackageFilieres.FiliereDAO().FindById(da.GetInt32(1)), da.GetString(2), da.GetInt32(3), da.GetString(4), da.GetString(5), da.GetString(6), da.GetString(7), da.GetString(8), da.GetString(9), da.GetString(10), da.GetString(11), da.GetString(12)));
            }
            return(liste);
        }
        public List <Groupe> Select()
        {
            string          Requete    = "Select * from Groupes";
            List <Groupe>   ListGroupe = new List <Groupe>();
            OleDbDataReader read       = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Groupe g = new Groupe();
                g.Id   = read.GetInt32(0);
                g.Code = read.GetString(1);
                g.Nom  = read.GetString(2);
                ListGroupe.Add(g);
            }
            MyConnection.Close();
            return(ListGroupe);
        }
예제 #20
0
        public List <Filiere> Select()
        {
            string          Requete     = "Select * from Filieres";
            List <Filiere>  ListFiliere = new List <Filiere>();
            OleDbDataReader read        = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Filiere f = new Filiere();
                f.Id   = read.GetInt32(0);
                f.Code = read.GetString(1);
                f.Nom  = read.GetString(2);
                ListFiliere.Add(f);
            }
            MyConnection.Close();
            return(ListFiliere);
        }
예제 #21
0
        public List <EmploisTemp> Select()
        {
            string             Requete         = "Select * from EmploisTemps";
            List <EmploisTemp> ListEmploisTemp = new List <EmploisTemp>();
            OleDbDataReader    read            = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                EmploisTemp f = new EmploisTemp();
                f.Id        = read.GetInt32(0);
                f.DateDebut = read.GetDateTime(1);
                f.DateFin   = read.GetDateTime(2);
                //   f.Anneeformation = read.GetDateTime(3);
                ListEmploisTemp.Add(f);
            }
            MyConnection.Close();
            return(ListEmploisTemp);
        }
예제 #22
0
        public List <Seanceplanning> Select()
        {
            string Requete = "Select * from SeancePlannings";
            List <Seanceplanning> ListSeancePlannings = new List <Seanceplanning>();
            OleDbDataReader       read = MyConnection.ExecuteReader(Requete);

            while (read.Read())
            {
                Seanceplanning f = new Seanceplanning();
                f.Id         = read.GetInt32(1);
                f.Jour       = read.GetString(2);
                f.Heuredebut = read.GetInt32(3);
                f.Heurefin   = read.GetInt32(4);
                f.Formation  = new PackageFormations.FormationDAO().FindById(read.GetInt32(5));
                ListSeancePlannings.Add(f);
            }
            MyConnection.Close();
            return(ListSeancePlannings);
        }