private void btnGuardar_Click(object sender, EventArgs e)
{
MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas");
try
{
conectar.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
String sql = "insert into login(correo, usuario, contrasena) values ('" + txtEmail.Text + "' , '" + txtUser.Text + "' , '" + txtPass.Text + "' )";
MySqlCommand cmd = new MySqlCommand(sql, conectar);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Usuario Registrado con exito");
this.Hide();
principal.Show();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnCambiar_Click(object sender, EventArgs e)
{
MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas");
try
{
conectar.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}
String sql = "UPDATE login SET contrasena = '" + txtContrasena.Text + "' WHERE correo = '" + txtCorreoElectronico.Text + "'";
MySqlCommand cmd = new MySqlCommand(sql, conectar);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Contrasena cambiada correctamente");
this.Hide();
formularioPrincipal.Show();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnEntrar_Click_1(object sender, EventArgs e)
{
MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas");
conectar.Open();
MySqlCommand codigo = new MySqlCommand();
codigo.Connection = conectar;
codigo.CommandText = ("select * from login where correo = '" + txtUser.Text + "'and contrasena = '" + txtContrasena.Text + "'");
MySqlDataReader leer = codigo.ExecuteReader();
if (leer.Read())
{
MessageBox.Show("Bienvenido" + " " + txtUser.Text);
this.Hide();
principal.Show();
}
else
{
MessageBox.Show("usuario y/o contraseña incorrectos");
}
conectar.Close();
}
