private void simpleButton1_Click(object sender, EventArgs e) { if (textBox1.Text != "" || textBox2.Text != "") { if (glossaire.Instance.Login(textBox1.Text, textBox2.Text)) { clsConnecter c = new clsConnecter(); c.Ref_agent = textBox1.Text; c.Statut = 1; glos.insertConne(c); this.Hide(); layout.formMain main = new layout.formMain(textBox1.Text); main.ShowDialog(); } } else { MessageBox.Show("Remplissez tous les champs svp!!"); } }
public void insertConne(clsConnecter c) { try { InitializeConnection(); string q = "insert into connecter(ref_agent,statut) values(@ref_agent,@statut)"; cmd = new MySqlCommand(q, con); cmd.Parameters.Add(new MySqlParameter("@ref_agent", c.Ref_agent)); cmd.Parameters.Add(new MySqlParameter("@statut", c.Statut)); if (cmd.ExecuteNonQuery() == 1) { //MessageBox.Show("prensent"); } } catch (Exception) { } }