public List <TB_ResponsablePilarBE> ListarTB_ResponsablePilarO_Act() { string conexion = MiConexion.GetCnx(); List <TB_ResponsablePilarBE> lTB_ResponsablePilarBE = null; SqlConnection con = new SqlConnection(conexion); con.Open(); SqlCommand cmd = new SqlCommand("sp_ListarTB_ResponsablePilar_Act", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader drd = cmd.ExecuteReader(CommandBehavior.SingleResult); if (drd != null) { lTB_ResponsablePilarBE = new List <TB_ResponsablePilarBE>(); int posPilar_id = drd.GetOrdinal("Pilar_id"); int posFuncionario_id = drd.GetOrdinal("Funcionario_id"); TB_ResponsablePilarBE obeResponsablePilarBE = null; while (drd.Read()) { obeResponsablePilarBE = new TB_ResponsablePilarBE(); obeResponsablePilarBE.Pilar_id = drd.GetInt16(posPilar_id); obeResponsablePilarBE.Funcionario_id = drd.GetInt16(posFuncionario_id); lTB_ResponsablePilarBE.Add(obeResponsablePilarBE); } drd.Close(); } con.Close(); return(lTB_ResponsablePilarBE); }
public TB_ResponsablePilarBE TraerTB_ResponsablePilarByPilar(int _Pilar_id) { TB_ResponsablePilarBE _TB_ResponsablePilarBE = new TB_ResponsablePilarBE(); SqlDataReader dtr = default(SqlDataReader); DataSet dts = new DataSet(); try { cnx.ConnectionString = MiConexion.GetCnx(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_TraerTB_ResponsablePilarByPilar"; cmd.Parameters.Add(new SqlParameter("@Pilar_id", SqlDbType.SmallInt)); cmd.Parameters["@Pilar_id"].Value = _Pilar_id; cnx.Open(); dtr = cmd.ExecuteReader(); if (dtr.HasRows == true) { dtr.Read(); var _with1 = _TB_ResponsablePilarBE; _with1.Pilar_id = Convert.ToInt32(dtr.GetValue(dtr.GetOrdinal("Pilar_id"))); _with1.Funcionario_id = Convert.ToInt16(dtr.GetValue(dtr.GetOrdinal("Funcionario_id"))); _with1.Funcionario_nome = dtr.GetValue(dtr.GetOrdinal("Funcionario_nome")).ToString(); } } catch (SqlException ex) { throw new Exception(ex.Message); } catch (Exception ex) { throw new Exception(ex.Message); } finally { if (cnx.State == ConnectionState.Open) { cnx.Close(); } cmd.Parameters.Clear(); } return(_TB_ResponsablePilarBE); }