public EditCharcheur(String username, string type, ConsulterCher cc) { InitializeComponent(); this.cc = cc; Chercheur c = null; DataBases bd = new DataBases(); if (type == "chercheur") { c = bd.GetChercheur(username); } else if (type == "chef") { c = bd.GetChef(username); } else if (type == "directeur") { c = bd.GetDirectuer(username); } else { } this.nom.Text = c.nom; this.prenom.Text = c.prenom; this.DataNais.Value = c.date_nais; this.lieu.Text = c.lieu_nais; this.adresse.Text = c.adresse; this.username.Text = c.username; this.password.Text = ""; this.email.Text = c.email; this.sexe.SelectedItem = c.sexe; this.interet.Text = c.interet[0]; this.domaine.Text = c.domaine; }
private void ajouterChercheurButton_Click(object sender, EventArgs e) { string nom = this.nom.Text; string prenom = this.prenom.Text; DateTime date = Convert.ToDateTime(this.DataNais.Text); Debug.WriteLine("---------- " + date); string lieu = this.lieu.Text; string adresse = this.adresse.Text; string username = this.username.Text; string password = this.password.Text; string email = this.email.Text; string sexe = this.sexe.Text; string[] interets = { this.interet.Text }; string domaine = this.domaine.Text; Chercheur ch = new Chercheur(nom, prenom, date, lieu, adresse, username, password, email, sexe, interets, domaine); DataBases bd = new DataBases(); if (this.ChercheurCheckBox.Checked) { if (bd.AddChercheur(ch)) { MessageBox.Show("Bien ajouter"); clearFileds(); } else { MessageBox.Show("erreur"); } } else if (this.ChefCheckBox.Checked) { if (bd.AddChef(ch)) { MessageBox.Show("Bien ajouter"); clearFileds(); } else { MessageBox.Show("erreur"); } } else if (this.DirectureCheckBox.Checked) { if (bd.AddDirecteur(ch)) { MessageBox.Show("Bien ajouter"); clearFileds(); } else { MessageBox.Show("erreur"); } } else { MessageBox.Show("a choisi une option (chercheur,Directeur,Chef)"); } }
public Chercheur GetDirectuer(string user) { string query = "SELECT * FROM directure WHERE username = '******';"; if (this.OpenConnection() == true) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = query; using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { reader.Read(); string nom = reader.GetString(0); string prenom = reader.GetString(1); DateTime date_niass = reader.GetDateTime(2); string lieu_naiss = reader.GetString(3); string adress = reader.GetString(4); string username = reader.GetString(5); string password = reader.GetString(6); string email = reader.GetString(7); string sexe = reader.GetString(8); string interetString = reader.GetString(9); string[] interet = interetString.Split(','); string domaine = reader.GetString(10); Chercheur chercheur = new Chercheur(nom, prenom, date_niass, lieu_naiss, adress, username, password, email, sexe, interet, domaine); return(chercheur); } } this.CloseConnection(); } return(null); }
public bool AddChef(Chercheur chercheur) { string query = "INSERT INTO chef_equipe (nom, prenom, date_niass, lieu_naiss, adress, username, password, email, sexe, interet, domaine) VALUES(@nom, @prenom, @date_niass, @lieu_naiss, @adress, @username, MD5(@password), @email, @sexe, @interet, @domaine);"; if (this.OpenConnection() == true) { //MySqlCommand cmd = connection.CreateCommand(); try { var cmd = new MySqlCommand(query, connection); cmd.CommandText = query; cmd.Parameters.AddWithValue("@nom", chercheur.nom); cmd.Parameters.AddWithValue("@prenom", chercheur.prenom); cmd.Parameters.AddWithValue("@date_niass", chercheur.date_nais); cmd.Parameters.AddWithValue("@lieu_naiss", chercheur.lieu_nais); cmd.Parameters.AddWithValue("@adress", chercheur.adresse); cmd.Parameters.AddWithValue("@username", chercheur.username); cmd.Parameters.AddWithValue("@password", chercheur.password); cmd.Parameters.AddWithValue("@email", chercheur.email); cmd.Parameters.AddWithValue("@sexe", chercheur.sexe); cmd.Parameters.AddWithValue("@interet", chercheur.interet[0]); cmd.Parameters.AddWithValue("@domaine", chercheur.domaine); cmd.Prepare(); cmd.ExecuteNonQuery(); return(true); } catch { } this.CloseConnection(); } return(false); }
public bool ModChercheur(Chercheur chercheur) { DataBases bd = new DataBases(); bd.DeleteCher(chercheur.username); if (bd.AddChercheur(chercheur)) { return(true); } else { return(false); } }
public List <Chercheur> SearchChercheurs(string word) { List <Chercheur> chercheurs = new List <Chercheur>(); string query = "SELECT * FROM chercheur WHERE nom like '%" + word + "%' or prenom like '%" + word + "%' or lieu_naiss like '%" + word + "%' or adress like '%" + word + "%'or username like '%" + word + "%' or email like '%" + word + "%' or sexe like '%" + word + "%' or interet like '%" + word + "%' or domaine like '%" + word + "%';"; if (this.OpenConnection() == true) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = query; using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string nom = reader.GetString(0); string prenom = reader.GetString(1); DateTime date_niass = reader.GetDateTime(2); string lieu_naiss = reader.GetString(3); string adress = reader.GetString(4); string username = reader.GetString(5); string password = reader.GetString(6); string email = reader.GetString(7); string sexe = reader.GetString(8); string interetString = reader.GetString(9); string[] interet = interetString.Split(','); string domaine = reader.GetString(10); Chercheur chercheur = new Chercheur(nom, prenom, date_niass, lieu_naiss, adress, username, password, email, sexe, interet, domaine); chercheurs.Add(chercheur); } } } this.CloseConnection(); } return(chercheurs); }