public ActionResult VerAlunos(InfoTurma infoturma)
{
string cs = ConfigurationManager.ConnectionStrings["EscolaTECNUN"].ConnectionString;
SqlConnection conn = new SqlConnection(cs);
//definição do comando sql
string sql = "";
if (infoturma.NumTurma == null)
{
sql = "SELECT * " +
" FROM dbo.Aluno ";
}
else
{
sql = "SELECT a.* " +
" FROM dbo.Aluno a " +
" INNER JOIN dbo.Matricula m ON m.alunoid = a.id" +
" INNER JOIN dbo.Turma t ON t.id = m.turmaid" +
" WHERE t.numturma = @numturma";
}
try
{
infoturma.Aluno = new List <Aluno>();
SqlCommand comando = new SqlCommand(sql, conn);
if (infoturma.NumTurma != null)
{
comando.Parameters.Add(new SqlParameter("@numturma", infoturma.NumTurma));
}
conn.Open();
using (SqlDataReader reader = comando.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Aluno a = new Aluno();
a.Id = reader.GetInt32(reader.GetOrdinal("id"));
a.Nome = reader.GetString(reader.GetOrdinal("nome"));
a.CPF = reader.GetString(reader.GetOrdinal("cpf"));
a.DataNasc = reader.GetDateTime(reader.GetOrdinal("datanasc"));
a.Telefone = reader.GetString(reader.GetOrdinal("telefone"));
a.Email = reader.GetString(reader.GetOrdinal("email"));
a.InfoAdic = reader.GetString(reader.GetOrdinal("infoadic"));
infoturma.Aluno.Add(a);
}
}
}
conn.Close();
}
catch (Exception ex)
{
return(Content("Erro ao visualizar os alunos"));
}
finally
{
conn.Close();
}
if (infoturma.NumTurma == null)
{
return(View("Alunos", infoturma));
}
else
{
return(View("VerAlunos", infoturma));
}
}
public ActionResult Index()
{
InfoTurma infoturma = new InfoTurma();
return(VerAlunos(infoturma));
}
