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; } } }