Ejemplo n.º 1
0
        public string InsertValidation(BDDValidation validation)
        {
            MySqlConnection conn = DBConf.GetDBConnection();

            try
            {
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "INSERT INTO rfid(InfoCarte,idPreinscrit) VALUES(@infoCarte,@idPreinscrit)";
                command.Parameters.AddWithValue("InfoCarte", validation.infoCarte);
                command.Parameters.AddWithValue("idPreinscrit", validation.idPreinscrit);
                command.ExecuteNonQuery();
                return("Success !");
            }
            catch (Exception e)
            {
                return(e.ToString());

                throw;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }
Ejemplo n.º 2
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;
            }
        }
Ejemplo n.º 3
0
        public string InsertXbee(BDDXbee xbee)
        {
            MySqlConnection conn = DBConf.GetDBConnection();

            try
            {
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "INSERT INTO portique(idPortique,infoCarte,Temps) VALUES(@portique,@carteId,@temps)";
                //{"portique":"1","carteId":"316548461","date":"11:34:52"}
                command.Parameters.AddWithValue("portique", xbee.portique);
                command.Parameters.AddWithValue("carteId", xbee.carteId);
                command.Parameters.AddWithValue("temps", xbee.temps);
                command.ExecuteNonQuery();
                return("Success !");
            }
            catch (Exception e)
            {
                Debug.Print(e.ToString());
                return(e.ToString());

                throw;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }
Ejemplo n.º 4
0
        public string InsertAlerte(BDDAlerte alerte)
        {
            MySqlConnection conn = DBConf.GetDBConnection();

            try
            {
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "INSERT INTO alerte (alerte) VALUES (@alerte)";
                command.Parameters.AddWithValue("alerte", alerte.alerte);
                command.ExecuteNonQuery();
                return("Success !");
            }
            catch (Exception e)
            {
                return(e.ToString());

                throw;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }
Ejemplo n.º 5
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;
            }
        }
Ejemplo n.º 6
0
        public List <BDDAffichage> SelectAffichage()
        {
            MySqlConnection conn = DBConf.GetDBConnection();

            try
            {
                List <BDDAffichage> affichagesL = new List <BDDAffichage>();
                conn.Open();
                MySqlCommand command = conn.CreateCommand();
                command.CommandText = "SELECT preinscrit.Nom, preinscrit.Prenom,portique.idPortique,portique.Temps,preinscrit.Club " +
                                      "FROM preinscrit, portique,rfid " +
                                      "WHERE rfid.InfoCarte=portique.infoCarte and preinscrit.IdPreinscrit = rfid.idPreinscrit " +
                                      "ORDER BY portique.idPortique DESC, portique.Temps ASC";
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    BDDAffichage affichage = new BDDAffichage
                    {
                        nom        = reader[0].ToString(),
                        prenom     = reader[1].ToString(),
                        checkpoint = Convert.ToInt32(reader[2]),
                        temps      = reader[3].ToString(),
                        club       = reader[4].ToString()
                    };
                    affichagesL.Add(affichage);
                }
                return(affichagesL);
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }