private void Access()
{
PrincipalMenu Menu = new PrincipalMenu();
Menu.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
if (TxtPass.Text != "" && TxtUser.Text != "")
{
Config Sql = new Config();
Sql.SQL.Open();
log.Info($"Conexión a base de datos: {Sql.SQL.State}");
//Sql.SQL.Close();
Sql.Command.Connection = Sql.SQL;
Sql.Command.CommandText = "stpLogin";
Sql.Command.CommandType = System.Data.CommandType.StoredProcedure;
Sql.Command.Parameters.AddWithValue("@Username", TxtUser.Text.ToLower());
Sql.Command.Parameters.AddWithValue("@Password", TxtPass.Text);
Sql.dr = Sql.Command.ExecuteReader();
if (Sql.dr.Read())
{
log.Info($"Acceso al sistema. {TxtUser.Text}");
PrincipalMenu Menu = new PrincipalMenu();
Menu.Show();
this.Hide();
MessageBox.Show("Bienvenido/a");
}
else
{
Reset();
log.Fatal($"Intento fallido de acceso al sistema. {TxtUser.Text}");
LoginError LoginE = new LoginError();
LoginE.Show();
LblErrorMessage.Visible = false;
LblErrorMessage2.Visible = false;
}
Sql.dr.Close();
}
else
{
if (TxtUser.Text == "")
{
MsgError("UserName not found");
}
else
{
LblErrorMessage.Visible = false;
}
if (TxtPass.Text == "")
{
MsgError2("Password not found");
}
else
{
LblErrorMessage2.Visible = false;
}
}
}
