Example #1
0
 void RefreshDatas(IInscription insc)
 {
     if (radioAgent.Checked == true)
     {
         dgInscit.DataSource = insc.AllAgent();
     }
     else if (radioMembre.Checked == true)
     {
         dgInscit.DataSource = insc.AllInscriptionsRound(InstantRound.GetInstance().Id);
     }
 }
Example #2
0
        public void Enregistrer(IInscription membre)
        {
            if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
            {
                ImplementeConnexion.Instance.Conn.Open();
            }
            using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
            {
                cmd.CommandText = "INSERT_INSCRIPTION";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id));
                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_membre", 4, DbType.Int32, RefMembre));
                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_round", 4, DbType.Int32, RefRound));
                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@user_session", 30, DbType.String, UserSession));

                cmd.ExecuteNonQuery();

                MessageBox.Show("Enregistrement reussie", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
Example #3
0
 void RefreshDatas(IInscription insc)
 {
     dgInscit.DataSource = insc.AllInscriptionsRound(InstantRound.GetInstance().Id);
     sexeTxt.DataSource  = Enum.GetNames(typeof(Sexe));
     dn.chargeCombo(membreCombo, "Nom_Complet", "SELECT_NOM_COMPLET_MEMBRE");
 }
Example #4
0
 void Search(IInscription cot)
 {
     dgInscit.DataSource = cot.Research(serchTxt.Text);
 }