예제 #1
0
        public string Insert(BDDPreinscrit preinscrit)
        {
            MySqlConnection conn = DBConf.GetDBConnection();

            try
            {
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "INSERT INTO preinscrit(Nom,Prenom,Adresse,CodePostal,Ville,DateNaissance,Telephone,Email,Club,Ufolep,Parcours) VALUES(@Nom,@Prenom,@Adresse,@CodePostal,@Ville,@DateNaissance,@Telephone,@Email,@Club,@Ufolep,@Parcours)";
                //{"Nom":"MARC","Prenom":"Jérémy","Adresse":"59 Cours Clemenceau","CodePostal":"76100","Ville":"Rouen","DateNaissance":"02-06-1998","Telephone":"0782062639","Email":"*****@*****.**","Club":"azerty","Parcours":"1"}
                command.Parameters.AddWithValue("Nom", preinscrit.Nom);
                command.Parameters.AddWithValue("Prenom", preinscrit.Prenom);
                command.Parameters.AddWithValue("Adresse", preinscrit.Adresse);
                command.Parameters.AddWithValue("CodePostal", preinscrit.CodePostal);
                command.Parameters.AddWithValue("Ville", preinscrit.Ville);
                command.Parameters.AddWithValue("DateNaissance", preinscrit.DateNaissance);
                command.Parameters.AddWithValue("Telephone", preinscrit.Telephone);
                command.Parameters.AddWithValue("Email", preinscrit.Email);
                command.Parameters.AddWithValue("Club", preinscrit.Club);
                command.Parameters.AddWithValue("Ufolep", preinscrit.Ufolep);
                command.Parameters.AddWithValue("Parcours", preinscrit.Parcours);
                command.ExecuteNonQuery();
                return("Success !");
            }
            catch (Exception e)
            {
                return(e.ToString());
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }
예제 #2
0
        public List <BDDPreinscrit> SelectPreinscrit()
        {
            List <BDDPreinscrit> preinscritL = new List <BDDPreinscrit>();
            MySqlConnection      conn        = DBConf.GetDBConnection();

            conn.Open();
            try
            {
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "SELECT * FROM preinscrit";
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    BDDPreinscrit preinscrit = new BDDPreinscrit()
                    {
                        IdPreinscrit  = Convert.ToInt32(reader[0]),
                        Nom           = reader[1].ToString(),
                        Prenom        = reader[2].ToString(),
                        Adresse       = reader[3].ToString(),
                        CodePostal    = Convert.ToInt32(reader[4]),
                        Ville         = reader[5].ToString(),
                        DateNaissance = reader[6].ToString(),
                        Telephone     = reader[7].ToString(),
                        Email         = reader[8].ToString(),
                        Club          = reader[9].ToString(),
                        Ufolep        = reader[10].ToString()
                    };
                    preinscritL.Add(preinscrit);
                }
                return(preinscritL);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }
예제 #3
0
        //******SELECT******//

        public List <BDDPreinscrit> Select()
        {
            BDDPreinscrit preinscrit = new BDDPreinscrit();

            return(preinscrit.SelectPreinscrit());
        }
예제 #4
0
        public string Insert(BDDPreinscrit bddpreinscrit)
        {
            BDDPreinscrit preinscrit = new BDDPreinscrit();

            return(preinscrit.Insert(bddpreinscrit));
        }