public List <Matricula> misAlumnos(Int64 pId)
{
List <Matricula> lista = new List <Matricula>();
using (SqlConnection con = ConexionBD.Conectar())
{
con.Open();
string ssql = "select a.*,b.Id, b.ProfesorId, c.Id from Matriculas as a inner join Grupos as b on a.GrupoId=b.Id inner join Profesores as c on b.ProfesorId=c.Id where c.Id={0}";
string sentencia = string.Format(ssql, pId);
SqlCommand comando = new SqlCommand(sentencia, con);
comando.CommandType = CommandType.Text;
IDataReader lector = comando.ExecuteReader();
while (lector.Read())
{
lista.Add(new Matricula(lector.GetInt64(0),
lector.GetString(1),
lector.GetString(2),
CarreraDAL.ObtenerPorId(lector.GetInt64(3)),
EstudianteDAL.ObtenerPorId(lector.GetInt64(4)),
GrupoDAL.ObtenerPorId(lector.GetInt64(5))));
}
con.Close();
}
return(lista);
}
public List <Matricula> CodigoAlumnos(string pBuscar)
{
List <Matricula> lista = new List <Matricula>();
using (SqlConnection con = ConexionBD.Conectar())
{
con.Open();
string ssql = " select a.*, b.* from Matriculas as a inner join Estudiantes as b on a.EstudianteId=b.Id where b.Codigo like '%{0}%'";
string sentencia = string.Format(ssql, pBuscar);
SqlCommand comando = new SqlCommand(sentencia, con);
comando.CommandType = CommandType.Text;
IDataReader lector = comando.ExecuteReader();
while (lector.Read())
{
lista.Add(new Matricula(lector.GetInt64(0),
lector.GetString(1),
lector.GetString(2),
CarreraDAL.ObtenerPorId(lector.GetInt64(3)),
EstudianteDAL.ObtenerPorId(lector.GetInt64(4)),
GrupoDAL.ObtenerPorId(lector.GetInt64(5))));
}
con.Close();
}
return(lista);
}
public static Matricula ObtenerPorId(Int64 pId)
{
Matricula matricula = new Matricula();
using (SqlConnection con = ConexionBD.Conectar())
{
con.Open();
string ssql = "select * from Matriculas where Id={0}";
string sentencia = string.Format(ssql, pId);
SqlCommand comando = new SqlCommand(sentencia, con);
comando.CommandType = CommandType.Text;
IDataReader lector = comando.ExecuteReader();
if (lector.Read())
{
matricula.Id = lector.GetInt64(0);
matricula.Año = lector.GetString(1);
matricula.Ciclo = lector.GetString(2);
matricula.CarreraId = CarreraDAL.ObtenerPorId(lector.GetInt64(3));
matricula.EstudianteId = EstudianteDAL.ObtenerPorId(lector.GetInt64(4));
matricula.GrupoId = GrupoDAL.ObtenerPorId(lector.GetInt64(5));
}
con.Close();
}
return(matricula);
}
public List <Matricula> ListarMatricula()
{
List <Matricula> lista = new List <Matricula>();
using (SqlConnection con = ConexionBD.Conectar())
{
con.Open();
string ssql = "select * from Matriculas";
SqlCommand comando = new SqlCommand(ssql, con);
comando.CommandType = CommandType.Text;
IDataReader lector = comando.ExecuteReader();
while (lector.Read())
{
lista.Add(new Matricula(lector.GetInt64(0),
lector.GetString(1),
lector.GetString(2),
CarreraDAL.ObtenerPorId(lector.GetInt64(3)),
EstudianteDAL.ObtenerPorId(lector.GetInt64(4)),
GrupoDAL.ObtenerPorId(lector.GetInt64(5))));
}
con.Close();
}
return(lista);
}