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