public static string ReceiveDataLogin(string Username, string Tablename) { try { MySqlConnection conn = new MySqlConnection(connString); conn.Open(); // Verbeteren wanneer ik mijn laptop terug heb string sql = "select AES_DECRYPT(`password`, '" + AES_KEY + "') AS pass FROM login WHERE username = aes_encrypt('" + Username + "', '" + AES_KEY + "');"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { string PassName = dataReader.GetString(0); //TestScript.Debugging(PassName); return(PassName); } dataReader.Close(); conn.Close(); return(null); } catch (Exception ex) { TestScript.Debugging(ex.ToString()); return(null); } }
public static void DeleteUser(string Username, string Tablename) { try { MySqlConnection conn = new MySqlConnection(connString); conn.Open(); string sql = "DELETE FROM '" + Tablename + "' where username = aes_encrypt('" + Username + "','" + AES_KEY + "');"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { } dataReader.Close(); conn.Close(); }catch (Exception ex) { TestScript.Debugging(ex.ToString()); } }
public static void SendDataLogin(string FirstInsert, string SecondInsert, string TableName) { // dit veranderen wanneer naar echt server try { MySqlConnection conn = new MySqlConnection(connString); string sql = "INSERT INTO login (`username`, `password`) VALUES (AES_ENCRYPT('" + FirstInsert + "','" + AES_KEY + "'), AES_ENCRYPT('" + SecondInsert + "','" + AES_KEY + "'));"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader; conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { } reader.Close(); conn.Close(); } catch (Exception ex) { TestScript.Debugging(ex.ToString()); } }
public static void SendNewPassword(string Username, string NewPass, string TableName) { //later afmaken met Jesse try { MySqlConnection conn = new MySqlConnection(connString); string sql = "UPDATE LOGIN SET password = aes_encrypt('" + NewPass + "','" + AES_KEY + "') where username = aes_encrypt('" + Username + "','" + AES_KEY + "');"; MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader reader; conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { } reader.Close(); conn.Close(); } catch (Exception ex) { TestScript.Debugging(ex.ToString()); } }