1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
public static bool AuthentificationUtilisateur(string login, string mp)
{
bool estConnecter = false;
string loginCrypt = string.Empty;
string mpCrypt = string.Empty;
using (MD5 crypt = MD5.Create())
{
loginCrypt = Cryptage(login, crypt);
mpCrypt = Cryptage(mp, crypt);
}
using (SqlConnection connexion = new SqlConnection(ChaineConnexion))
{
using (SqlCommand command = new SqlCommand("SP_SelectUtilisateur", connexion))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@login", SqlDbType.VarChar).Value = loginCrypt;
command.Parameters.Add("@password", SqlDbType.VarChar).Value = mpCrypt;
connexion.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader["Login"].ToString() == loginCrypt && reader.["Password"].ToString() == mpCrypt)
{
estConnecter = true;
}
}
}
}
return estConnecter;
} |
Partager