public List <Jedi> getAllJedi()
        {
            List <Jedi> jedis        = new List <Jedi>();
            DataTable   jedis_en_dur = SelectByDataAdapter("SELECT * FROM jedi;");

            foreach (DataRow row in jedis_en_dur.Rows) // Loop over the rows.
            {
                int jediId = (int)row.ItemArray.ElementAt(0);

                List <Caracteristique> caracts = new List <Caracteristique>();
                DataTable caracts_en_dur       = SelectByDataAdapter("SELECT * FROM caracteristic,link_jedi_caracteristic" +
                                                                     " WHERE caracteristic.numcaract = link_jedi_caracteristic.numcaracteristic" +
                                                                     " AND link_jedi_caracteristic.numjedi =" + jediId + ";");
                foreach (DataRow row2 in caracts_en_dur.Rows) // Loop over the rows.
                {
                    caracts.Add(new Caracteristique((int)row2.ItemArray.ElementAt(0),
                                                    Caracteristique.stringToEDef((string)row2.ItemArray.ElementAt(1)),
                                                    (string)row2.ItemArray.ElementAt(2),
                                                    Caracteristique.stringToEType((string)row2.ItemArray.ElementAt(3)),
                                                    (int)row2.ItemArray.ElementAt(4)));
                }

                jedis.Add(new Jedi((int)row.ItemArray.ElementAt(0),
                                   (string)row.ItemArray.ElementAt(1),
                                   (bool)row.ItemArray.ElementAt(2),
                                   caracts));
            }

            return(jedis);
        }
        public List <Stade> getAllStade()
        {
            List <Stade> stades       = new List <Stade>();
            DataTable    stade_en_dur = SelectByDataAdapter("SELECT * FROM stade;");

            foreach (DataRow row in stade_en_dur.Rows) // Loop over the rows.
            {
                int stadeId = (int)row.ItemArray.ElementAt(0);

                List <Caracteristique> caracts = new List <Caracteristique>();
                DataTable caracts_en_dur       = SelectByDataAdapter("SELECT * FROM caracteristic,link_stade_caracteristic" +
                                                                     " WHERE caracteristic.numcaract = link_stade_caracteristic.numcaracteristic" +
                                                                     " AND link_stade_caracteristic.numstade =" + stadeId + ";");
                foreach (DataRow row2 in caracts_en_dur.Rows) // Loop over the rows.
                {
                    caracts.Add(new Caracteristique((int)row2.ItemArray.ElementAt(0),
                                                    Caracteristique.stringToEDef((string)row2.ItemArray.ElementAt(1)),
                                                    (string)row2.ItemArray.ElementAt(2),
                                                    Caracteristique.stringToEType((string)row2.ItemArray.ElementAt(3)),
                                                    (int)row2.ItemArray.ElementAt(4)));
                }

                stades.Add(new Stade((int)row.ItemArray.ElementAt(0),
                                     (int)row.ItemArray.ElementAt(1),
                                     (string)row.ItemArray.ElementAt(2),
                                     caracts));
            }

            return(stades);
        }
        public List <Caracteristique> getAllCaracteristic()
        {
            List <Caracteristique> caracts = new List <Caracteristique>();
            DataTable caracts_en_dur       = SelectByDataAdapter("SELECT * FROM caracteristic;");

            foreach (DataRow row in caracts_en_dur.Rows) // Loop over the rows.
            {
                //STUB
                caracts.Add(new Caracteristique((int)row.ItemArray.ElementAt(0),
                                                Caracteristique.stringToEDef((string)row.ItemArray.ElementAt(1)),
                                                (string)row.ItemArray.ElementAt(2),
                                                Caracteristique.stringToEType((string)row.ItemArray.ElementAt(3)),
                                                (int)row.ItemArray.ElementAt(4)));
            }

            return(caracts);
        }
        public Stade getStadeById(int stadeId)
        {
            Stade        res;
            List <Stade> stades       = new List <Stade>();
            DataTable    stade_en_dur = SelectByDataAdapter("SELECT * FROM stade WHERE numstade=" + stadeId + ";");

            foreach (DataRow row in stade_en_dur.Rows) // Loop over the rows.
            {
                List <Caracteristique> caracts = new List <Caracteristique>();
                DataTable caracts_en_dur       = SelectByDataAdapter("SELECT * FROM caracteristic,link_stade_caracteristic" +
                                                                     " WHERE caracteristic.numcaract = link_stade_caracteristic.numcaracteristic" +
                                                                     " AND link_stade_caracteristic.numstade =" + stadeId + ";");
                foreach (DataRow row2 in caracts_en_dur.Rows) // Loop over the rows.
                {
                    caracts.Add(new Caracteristique((int)row2.ItemArray.ElementAt(0),
                                                    Caracteristique.stringToEDef((string)row2.ItemArray.ElementAt(1)),
                                                    (string)row2.ItemArray.ElementAt(2),
                                                    Caracteristique.stringToEType((string)row2.ItemArray.ElementAt(3)),
                                                    (int)row2.ItemArray.ElementAt(4)));
                }

                stades.Add(new Stade((int)row.ItemArray.ElementAt(0),
                                     (int)row.ItemArray.ElementAt(1),
                                     (string)row.ItemArray.ElementAt(2),
                                     caracts));
            }

            try
            {
                res = stades[0];
            }
            catch (Exception)
            {
                throw new Exception("Stade ID doesn't exist !");
            }

            return(res);
        }
        private Jedi getJediById(int jediId)
        {
            Jedi        res;
            List <Jedi> jedis        = new List <Jedi>();
            DataTable   jedis_en_dur = SelectByDataAdapter("SELECT * FROM jedi WHERE numjedi=" + jediId + ";");

            foreach (DataRow row in jedis_en_dur.Rows) // Loop over the rows.
            {
                List <Caracteristique> caracts = new List <Caracteristique>();
                DataTable caracts_en_dur       = SelectByDataAdapter("SELECT * FROM caracteristic,link_stade_caracteristic" +
                                                                     " WHERE caracteristic.numcaract = link_stade_caracteristic.numcaracteristic" +
                                                                     " AND link_stade_caracteristic.numcaracteristic =" + jediId + ";");
                foreach (DataRow row2 in caracts_en_dur.Rows) // Loop over the rows.
                {
                    caracts.Add(new Caracteristique((int)row2.ItemArray.ElementAt(0),
                                                    Caracteristique.stringToEDef((string)row2.ItemArray.ElementAt(1)),
                                                    (string)row2.ItemArray.ElementAt(2),
                                                    Caracteristique.stringToEType((string)row2.ItemArray.ElementAt(3)),
                                                    (int)row2.ItemArray.ElementAt(4)));
                }

                jedis.Add(new Jedi((int)row.ItemArray.ElementAt(0),
                                   (string)row.ItemArray.ElementAt(1),
                                   (bool)row.ItemArray.ElementAt(2),
                                   caracts));
            }

            try
            {
                res = jedis[0];
            }
            catch (Exception)
            {
                throw new Exception("Jedi ID doesn't exist !");
            }

            return(res);
        }