public DataTable searchByIdTipoAluno(AlunoTipoDTO dto)
{
try
{
return(_alunoTipoDAO.searchByIdTipoAluno(dto));
}
catch (Exception ex)
{
throw ex;
}
}
internal DataTable searchByIdTipoAluno(AlunoTipoDTO dto)
{
StringBuilder str = new StringBuilder();
str.Append(@"SELECT IdTipoAluno, DescricaoTipoAluno FROM AlunoTipo WHERE IdTipoAluno = @idTipo order by DescricaoTipoAluno");
SqlCommand dbCommand = new SqlCommand(str.ToString());
dbCommand.CommandType = CommandType.Text;
IDataParameter situacao = new SqlParameter();
situacao.ParameterName = "@idTipo";
situacao.Value = dto.idTipoAluno;
situacao.DbType = System.Data.DbType.Int32;//System.Data.DbType.Guid;
dbCommand.Parameters.Add(situacao);
database.GetSourceConnection();
return(database.ExecutaDataSetParameter(dbCommand).Tables[0]);
}
