//open connection to database
private bool OpenConnection()
{
try
{
connection.Open();
return(true);
}
catch (MySqlException ex)
{
//When handling errors, you can your application's response based
//on the error number.
//The two most common error numbers when connecting are as follows:
//0: Cannot connect to server.
//1045: Invalid user name and/or password.
switch (ex.Number)
{
case 0:
Msgbox.Show("Cannot connect to server. Contact administrator");
break;
case 1045:
Msgbox.Show("Invalid username/password, please try again");
break;
}
return(false);
}
}
//Close connection
private bool CloseConnection()
{
try
{
connection.Close();
return(true);
}
catch (MySqlException ex)
{
Msgbox.Show(ex.Message);
return(false);
}
}
private void btnIngresar_Click(object sender, RoutedEventArgs e)
{
var username = txtUsuario.Text;
var pass = txtPassword.Password.ToString();
MySQLCon mysql = new MySQLCon();
List <string>[] checkUsers = new List <string> [1000];
checkUsers = mysql.Select();
if (username == "NobleSix" && pass == "haha")
{
Msgbox.Show("Bienvenido NobleSix");
}
else
{
Msgbox.Show("Usuario/Password Incorrecto");
}
}
private async void btnRegistrar_Click(object sender, RoutedEventArgs e)
{
string stringKey = "XZ*+2!@#4>.";
var button = sender as Button;
var username = txtUsuario.Text;
var password = txtPassword.Password.ToString();
var confpass = txtConfirmaPassword.Password.ToString();
string encryptPass = await EncryptStringHelper(password, stringKey);
if (password == confpass)
{
MySQLCon mysql = new MySQLCon();
mysql.InsertUser(username, password);
}
else
{
Msgbox.Show("Los passwords no coinciden.");
}
}