public static Profil unProfil(string pseudo, string mdp)
{
Profil p = null;
MySqlDataReader reader;
open();
MySqlCommand requete = new MySqlCommand();
requete.Connection = conn;
requete.CommandText = ("SELECT * FROM (profil p INNER JOIN profil_role pr ON p.idProfil = pr.idProfil) INNER JOIN role r ON pr.idRole = r.idRole WHERE pseudo = @pseudo AND mdp = @mdp");
requete.Prepare();
requete.Parameters.AddWithValue("@pseudo", pseudo);
requete.Parameters.AddWithValue("@mdp", Encrypt(mdp));
requete.Connection = conn;
reader = requete.ExecuteReader();
bool trouve = false;
while (reader.Read())
{
if (!trouve)
{
double score = 0;
int premiereCo = 0;
if (!reader.IsDBNull(7))
{
score = reader.GetDouble(7);
}
if (!reader.IsDBNull(9))
{
premiereCo = reader.GetInt32(9);
}
p = new Profil(reader.GetInt32("idProfil"), reader.GetString("nom"), reader.GetString("prenom"), reader.GetString("mail"), reader.GetDateTime("date_naiss"), score, (String)reader["numLicence"], premiereCo);
trouve = true;
}
Role r = new Role(reader.GetInt32("idRole"), reader.GetString("libelle"));
p.Roles.Add(r);
r.getProfils().Add(p);
}
reader.Close();
return(p);
}
public static Role unRole(string libelle)
{
Role r = null;
MySqlDataReader reader;
open();
MySqlCommand requete = new MySqlCommand();
requete.Connection = conn;
requete.CommandText = ("SELECT * FROM(role r INNER JOIN profil_role pr ON r.idRole = pr.FK_idRole) INNER JOIN profil p ON pr.FK_idProfil = p.idProfil WHERE libelle = @libelle");
requete.Parameters.AddWithValue("@libelle", libelle);
requete.ExecuteNonQuery();
reader = requete.ExecuteReader();
while (reader.Read())
{
r = new Role(reader.GetInt32("idRole"), reader.GetString("libelle"));
Profil p = new Profil(reader.GetInt32("idProfil"), reader.GetString("nom"), reader.GetString("prenom"), reader.GetString("mail"), reader.GetString("pseudo"), reader.GetString("mdp"), reader.GetDateTime("DateNaissance"));
r.getProfils().Add(p);
p.getRoles().Add(r);
}
reader.Close();
return(r);
}
private void btnConnexion_Click(object sender, RoutedEventArgs e)
{
menuItemRecruteur.Visibility = Visibility.Collapsed;
menuItemEntraineur.Visibility = Visibility.Collapsed;
menuItemJoueur.Visibility = Visibility.Collapsed;
lblCache.Visibility = Visibility.Visible;
Profil p = AdoProfil.unProfil(tbxPseudo.Text, pbxMdp.Password);
if (p != null)
{
lblNom.Content = "Bienvenue" + " " + p.getNom() + " " + p.getPrenom();
menu.Visibility = Visibility.Visible;
gridConnexion.Visibility = Visibility.Hidden;
foreach (Role r in p.getRoles())
{
if (r.getLibelle().Equals("Admin"))
{
menuItemRecruteur.Visibility = Visibility.Visible;
}
if (r.getLibelle().Equals("Educateur"))
{
menuItemEntraineur.Visibility = Visibility.Visible;
}
if (r.getLibelle().Equals("Joueur"))
{
menuItemJoueur.Visibility = Visibility.Visible;
}
}
}
else
{
MessageBox.Show("Pseudo ou mot de passe incorrect");
}
}
public static void createProfil(Profil p, Role role)
{
long id = 0;
try
{
open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO profil_role(idProfil, idRole) VALUES(@idProfil, @idRole)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@idProfil", p.IdProfil);
cmd.Parameters.AddWithValue("@idRole", role.getIdRole());
cmd.ExecuteNonQuery();
Console.WriteLine("Profil crée");
close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
}
private void Btn_Supprimer_Joueur_Click(object sender, RoutedEventArgs e)
{
Profil p = (Profil)cbxListeJoueurs.SelectedItem;
AdoProfil.delete(p.IdProfil);
}
private void dgVoirJoueur_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Profil p = (Profil)(dgVoirJoueur.CurrentItem);
}
