private void button1_Click(object sender, EventArgs e) { if (txt_username.Text == "") { lbl_error.Text = "Definissez le nom utilisateur"; } else { if (txt_password.Text == "") { lbl_error.Text = "Entrez le mot de passe !"; } else { //continuer MySqlConnection dbConn = new MySqlConnection("Persist Security Info=False;server=localhost;database=archimed_new;uid=root;password=root"); MySqlCommand cmd = dbConn.CreateCommand(); cmd.CommandText = "SELECT password from user WHERE username = @username"; cmd.Parameters.AddWithValue("@username", txt_username.Text); try { dbConn.Open(); } catch (Exception erro) { MessageBox.Show("Erro" + erro); this.Close(); } MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { if (reader.GetString(0) == txt_password.Text) { Form frm = new Acceuil_interface(); frm.Show(); //trouver moyen de le fermer this.Hide(); } else { MessageBox.Show("Mauvais mot de passe!"); } } else { MessageBox.Show("Mauvais nom utilisateur!"); } } } }
public void synchro_add_patient() { string con_string = "Data Source = " + Application.StartupPath + "\\Database_carte\\bd_archimede.sdf"; SqlCeConnection dbConn_carte = new SqlCeConnection(con_string); try { dbConn_carte.Open(); } catch (Exception erro) { MessageBox.Show("Erro" + erro); //this.Close(); } using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM patient", dbConn_carte)) { SqlCeDataReader reader_carte = com.ExecuteReader(); while (reader_carte.Read()) { int num = reader_carte.GetInt32(0); // a remplacer, dépendant de ce que tu veux lire MessageBox.Show("Lidentifiant patient est : " + num); /// insert dans la base de donnée sql MySqlConnection dbConn = new MySqlConnection("Persist Security Info=False;server=localhost;database=archimed_new;uid=root;password=root"); MySqlCommand cmd = dbConn.CreateCommand(); cmd.CommandText = "INSERT INTO patient(id, matricule, nom, prenom, nomMarital, dateNaissance, lieuNaissance, trancheAge, telephone, telephoneUrgence, mail, domicile, ville, pays, antecedentPatient_id) VALUES(@id, @matricule, @nom, @prenom, @nomMarital, @dateNaissance, @lieuNaissance, @trancheAge, @telephone, @telephoneUrgence, @mail, @domicile, @ville, @pays, @antecedentPatient) "; cmd.Parameters.AddWithValue("@id", null); cmd.Parameters.AddWithValue("@matricule", reader_carte.GetString(1)); cmd.Parameters.AddWithValue("@nom", reader_carte.GetString(2)); cmd.Parameters.AddWithValue("@prenom", reader_carte.GetString(3)); cmd.Parameters.AddWithValue("@nomMarital", null); cmd.Parameters.AddWithValue("@dateNaissance", reader_carte.GetString(5)); cmd.Parameters.AddWithValue("@lieuNaissance", reader_carte.GetString(6)); cmd.Parameters.AddWithValue("@trancheAge", reader_carte.GetString(7)); cmd.Parameters.AddWithValue("@telephone", reader_carte.GetString(8)); cmd.Parameters.AddWithValue("@telephoneUrgence", reader_carte.GetString(9)); cmd.Parameters.AddWithValue("@mail", reader_carte.GetString(10)); cmd.Parameters.AddWithValue("@domicile", reader_carte.GetString(11)); cmd.Parameters.AddWithValue("@ville", null); cmd.Parameters.AddWithValue("@pays", null); cmd.Parameters.AddWithValue("@antecedentPatient", 0); dbConn.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("patient ajouté"); Acceuil_interface classPrincipale = new Acceuil_interface(); classPrincipale.add_file(reader_carte.GetString(1)); } catch (Exception erro) { MessageBox.Show("Erro" + erro); //this.Close(); } } } MessageBox.Show("patient en base table \"patient\""); }