private void salirToolStripMenuItem1_Click(object sender, EventArgs e)
{
principal frm = new principal();
frm.Show();
this.Hide();
}
private void Entrar_Click(object sender, EventArgs e)
{
if (password.Text == "")
{
MessageBox.Show("Favor de ingresar su password...");
password.Focus();
}
else
{
IPHostEntry host;
localIP = "";
host = Dns.GetHostEntry(Dns.GetHostName());
foreach (IPAddress ip in host.AddressList)
{
if (ip.AddressFamily.ToString() == "InterNetwork")
{
localIP = ip.ToString();
}
}
// MessageBox.Show("Tú IP Local Es: " + localIP);
}
try
{
dbcom obj = new dbcom();
// obj.sql("SET GLOBAL max_connections = 300;");
// MySqlDataReader reader = obj.Estructura("SELECT nombre, numero, password FROM usuarios where string.trim(numero) = 1150;");
MySqlDataReader reader = obj.Estructura("SELECT usuario, password, numero,clave FROM usuarios ;");
// String a = this.textBox1.Text.ToUpper();
// String b = this.textBox2.Text.ToUpper();
while (reader.Read())
{
usuario = reader[0].ToString().ToUpper();
passwordusuario = reader[1].ToString().ToUpper();
claveusuario = passwordusuario = reader[3].ToString().ToUpper();
if (numeroempleado == reader[2].ToString().ToUpper() && password.Text == reader[1].ToString().ToUpper())
{
obj.sql(" UPDATE usuarios SET usuarioip = '" +
localIP
+ "' WHERE clave = '" +
claveusuario
+ "';");
principal frm = new principal();
frm.Show();
this.Hide();
break;
// MainForm.ActiveForm.MainMenuStrip.Visible = true;
//MainForm.ActiveForm.MainMenuStrip.Items.RemoveAt(1);
//MainForm.indice_usuario = 0;
// MainForm.ActiveForm.Tag = reader[0];
// this.Close();
}
}
reader.Close();
// MessageBox.Show("El password no se encontro...");
}
catch (Exception)
{
MessageBox.Show("No existen usuarios...");
}
}
