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