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