public static List <PaginaAprovacao> Listar(Boolean aprovados, Boolean reprovados, int aprovacaoId = 0) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_PAGINA_APROVACAO"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure if (aprovacaoId > 0) { objComando.Parameters.Add("@APROVACAOID", SqlDbType.Int).Value = aprovacaoId; } objComando.Parameters.Add("@APROVADOS", SqlDbType.Bit).Value = aprovados; objComando.Parameters.Add("@REPROVADOS", SqlDbType.Bit).Value = reprovados; try { objConexao.Open(); List <PaginaAprovacao> objList = new List <PaginaAprovacao>(); PaginaAprovacao obj = default(PaginaAprovacao); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj = new PaginaAprovacao(); obj.FromIDataReader(idrReader); objList.Add(obj); } return(objList); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
public static PaginaAprovacao Obter(int aprovacaoId) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_PAGINA_APROVACAO_OBTER"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; //Define parametros da procedure objComando.Parameters.Add("@APROVACAOID", SqlDbType.Int).Value = aprovacaoId; try { objConexao.Open(); PaginaAprovacao objPaginaAprovacao = new PaginaAprovacao(); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { objPaginaAprovacao.FromIDataReader(idrReader); } return(objPaginaAprovacao); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }