public bool isUserInDB(string login, string password)
{
using (MD5 md5Hash = MD5.Create())
{
string hash = CryptoMD5.GetMd5Hash(md5Hash, password);
StringBuilder myString = new StringBuilder();
myString.Append("SELECT id_user FROM orblanc.user where login_user="******"'" + login + "'");
myString.Append(" and password_user="******"'" + hash + "';");
MySqlConnection myconnexion = Global.InitMySqlConnection(Global.DBLogin, Global.DBPassword, Global.DBHost, Global.DBName, Global.Port, false);
ResultSelectOneValue result = Global.selectOneValue(myconnexion, myString.ToString());
if (String.IsNullOrEmpty(result.result))
{
return(false);
}
else
{
return(true);
}
}
}
public static string Hash(string data)
{
CryptoMD5 md5 = new CryptoMD5();
string hash = md5.EncryptTextU(data);
return hash;
}
public bool CreateUser(string login, string mail, string pwd)
{
MySqlConnection myconnexion = Global.InitMySqlConnection(Global.DBLogin, Global.DBPassword, Global.DBHost, Global.DBName, Global.Port, false);
List <string> listColumns = new List <String>();
List <string> listValue = new List <String>();
listColumns.Add("login_user");
listValue.Add(login);
using (MD5 md5Hash = MD5.Create())
{
listColumns.Add("password_user");
listValue.Add(CryptoMD5.GetMd5Hash(md5Hash, pwd));
}
listColumns.Add("email_user");
listValue.Add(mail);
return(Global.insert_into_db(myconnexion, "user", listColumns, listValue));
}
