public List <ModeloNegocio.Docente> getAllDocenteSchool(int idShool)
{
List <ModeloNegocio.Docente> lista = new List <ModeloNegocio.Docente>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_GET_DOCENTE_SCHOOL";
Cmd.Parameters.Add("@idschool", SqlDbType.Int).Value = idShool;
//Cmd.Parameters.Add("@tipoUser", SqlDbType.Int).Value = 7;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.Docente docente = new ModeloNegocio.Docente();
docente.id = Convert.ToInt32(Dtr["id"].ToString());
docente.Codigo = Dtr["codigo"].ToString();
docente.FullName = Dtr["name"].ToString();
lista.Add(docente);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return(lista);
}
public List<ModeloNegocio.Docente> getAllDocenteSchool(int idShool)
{
List<ModeloNegocio.Docente> lista = new List<ModeloNegocio.Docente>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_GET_DOCENTE_SCHOOL";
Cmd.Parameters.Add("@idschool", SqlDbType.Int).Value = idShool;
//Cmd.Parameters.Add("@tipoUser", SqlDbType.Int).Value = 7;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.Docente docente = new ModeloNegocio.Docente();
docente.id = Convert.ToInt32(Dtr["id"].ToString());
docente.Codigo = Dtr["codigo"].ToString();
docente.FullName = Dtr["name"].ToString();
lista.Add(docente);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return lista;
}