コード例 #1
0
ファイル: FrmMateriel.cs プロジェクト: samuelplante1/sim
        private void btnEnvoi_Click(object sender, EventArgs e)
        {
            if (cboMateriel1.SelectedIndex != -1)
            {
                sql msql = new sql("INSERT INTO dbo.Numero_Materiel VALUES (" + (cboParticipant.SelectedIndex + 1) + "," + (cboMateriel1.SelectedIndex + 1) + "," + nUDMateriel1.Value.ToString() + ")", "A18_Sim_Eq07");
                msql.executeNonQuery();
            }
            if (cboMateriel2.SelectedIndex != -1)
            {
                sql msql = new sql("INSERT INTO dbo.Numero_Materiel VALUES (" + (cboParticipant.SelectedIndex + 1) + "," + (cboMateriel2.SelectedIndex + 1) + "," + nUDMateriel12.Value.ToString() + ")", "A18_Sim_Eq07");
                msql.executeNonQuery();
            }
            if (cboMateriel3.SelectedIndex != -1)
            {
                sql msql = new sql("INSERT INTO dbo.Numero_Materiel VALUES (" + (cboParticipant.SelectedIndex + 1) + "," + (cboMateriel3.SelectedIndex + 1) + "," + nUDMateriel13.Value.ToString() + ")", "A18_Sim_Eq07");
                msql.executeNonQuery();
            }
            if (cboMateriel4.SelectedIndex != -1)
            {
                sql msql = new sql("INSERT INTO dbo.Numero_Materiel VALUES (" + (cboParticipant.SelectedIndex + 1) + "," + (cboMateriel4.SelectedIndex + 1) + "," + nUDMateriel14.Value.ToString() + ")", "A18_Sim_Eq07");
                msql.executeNonQuery();
            }
            if (cboMateriel5.SelectedIndex != -1)
            {
                sql msql = new sql("INSERT INTO dbo.Numero_Materiel VALUES (" + (cboParticipant.SelectedIndex + 1) + "," + (cboMateriel5.SelectedIndex + 1) + "," + nUDMateriel15.Value.ToString() + ")", "A18_Sim_Eq07");
                msql.executeNonQuery();
            }

            MessageBox.Show("Envoyé!");
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: samuelplante1/sim
        private void btnInscrire_Click(object sender, EventArgs e)
        {
            if (txtNom.Text != "" && txtPrenom.Text != "" && txtCourriel.Text != "" && cmbCategorie.SelectedIndex != -1 && cmbCegep.SelectedIndex != -1)
            {
                foreach (Personne personne in m_listPersonnes)
                {
                    if (personne.Nom == txtNom.Text && personne.Prenom == txtPrenom.Text)
                    {
                        return;
                    }
                }
                sql insertionPersonneSQL = new sql("INSERT INTO [dbo].[Personne] VALUES ('" + txtPrenom.Text + "', '" + txtNom.Text + "', '" + txtCourriel.Text + "', " + "123123" + ")", "A18_Sim_Eq07");
                insertionPersonneSQL.executeNonQuery();

                //sql insertioInscriptionnSQL = new sql("INSERT INTO [dbo].[Inscription] VALUES ()", "A18_Sim_Eq07");
                //insertioInscriptionnSQL.executeNonQuery();


                // Ajouter à la liste locale
                m_objPersonne = new Personne(txtNom.Text, txtPrenom.Text, txtCourriel.Text);
                if (cmbGroupesExistants.SelectedIndex != -1)
                {
                    foreach (Participant participant in m_listParticipant)
                    {
                        if (participant.Nom == txtGroupe.Text)
                        {
                            participant.Ajouter(m_objPersonne);
                        }
                    }
                }
                else
                {
                    m_objParticipant = new Participant(txtGroupe.Text);
                    m_listParticipant.Add(m_objParticipant);
                    m_objParticipant.Ajouter(m_objPersonne);
                }
                MessageBox.Show("Vous avez bien étés enrigistrés");
            }
        }