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