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);
}