private void Button_Ingresar_Click(object sender, EventArgs e) { String Usuario = TextBox_Usuario.Text; String Password = TextBox_Password.Text; try { Connection.Open(); String Query = "select * from Usuarios where Usuario = @Usuario and Passwrd = @Passwrd;"; SqlParameter[] Data = new SqlParameter[2]; Data[0] = new SqlParameter("@Usuario", Usuario); Data[1] = new SqlParameter("@Passwrd", Password); SqlCommand Command = new SqlCommand(Query, Connection); Command.Parameters.AddRange(Data); using (var DataReader = Command.ExecuteReader()) { if (DataReader.Read()) { Int32 Rango = Convert.ToInt32(DataReader["Rango"]); Delegado.Cargar_Principal(Rango, Usuario, Password); } else { DataReader.Close(); String Query2 = "select * from Alumnos where Nombre = @Usuario and NumeroDeControl = @Passwrd;"; SqlParameter[] Data2 = new SqlParameter[2]; Data2[0] = new SqlParameter("@Usuario", Usuario); Data2[1] = new SqlParameter("@Passwrd", Password); SqlCommand Command2 = new SqlCommand(Query2, Connection); Command2.Parameters.AddRange(Data2); using (var DataReader2 = Command2.ExecuteReader()) { if (DataReader2.Read()) { Int32 IDAlumno = Convert.ToInt32(DataReader2["IDAlumno"]); Delegado.Cargar_Alumnos(IDAlumno); } else { Label_Alerta.Text = "Mejor suerte para la próxima!"; } } } } Connection.Close(); } catch (Exception ex) { Label_Alerta.Text = ex.Message; Connection.Close(); } }
private void Button_Regresar_Login_Click(object sender, EventArgs e) { Delegado.Cargar_Principal(4, "u", "u"); }