public Connexion Find(Connexion logs) { connect.Open(); SqlCommand requete = new SqlCommand("SELECT * FROM Connexion WHERE login_connexion=@login AND mdp_connexion=@mdp", connect); requete.Parameters.AddWithValue("@login", logs.Login); requete.Parameters.AddWithValue("@mdp", logs.MdP); SqlDataReader lecture = requete.ExecuteReader(); Connexion info = new Connexion(); if (lecture.Read()) { info.IdCommercial = Convert.ToInt32(lecture["id_commercial_connexion"]); } connect.Close(); return info; }
public bool TestConnexion(Connexion logs) { bool test; connect.Open(); SqlCommand requete = new SqlCommand("SELECT * FROM Connexion WHERE login_connexion=@login AND mdp_connexion=@mdp", connect); requete.Parameters.AddWithValue("@login", logs.Login); requete.Parameters.AddWithValue("@mdp", logs.MdP); SqlDataReader lecture = requete.ExecuteReader(); if (lecture.Read()) { test = true; } else { test = false; } connect.Close(); return test; }
private void btnConnect_Click(object sender, EventArgs e) { Connexion logs = new Connexion(); logs.Login = txtId.Text; logs.MdP = txtPwd.Text; if (connexionDB.TestConnexion(logs)) { txtId.Clear(); txtPwd.Clear(); logs = connexionDB.Find(logs); Global.idCommercial = logs.IdCommercial; Accueil a = new Accueil(); this.Hide(); a.ShowDialog(); this.Show(); } else { MessageBox.Show("Identifiant / Mot de Passe Incorrect", "Erreur de connexion", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtId.Select(); } }