public EmergenciaBEList GeallServiciosMedicamentosbyId(Int32 IdAtencion) { EmergenciaBEList oEmergenciaBEList = new EmergenciaBEList(); SqlDataReader SqlReader = null; try { using (SqlConnection Conex = new SqlConnection(Configuraciones.CadenaConexion)) { /*Propiedades del SqlCommand*/ SqlCommand = new SqlCommand(); SqlCommand.CommandText = "sgsnet_sps_servicios_medicamentos_by_id"; SqlCommand.Connection = Conex; SqlCommand.CommandType = CommandType.StoredProcedure; SqlPara = new SqlParameter("@vi_id_atencion", SqlDbType.Int); SqlPara.Direction = ParameterDirection.Input; SqlPara.Value = IdAtencion; SqlCommand.Parameters.Add(SqlPara); /*Abrir la Conexion del SqlReader*/ Conex.Open(); SqlReader = SqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (SqlReader.HasRows) // Si Contiene Filas { while (SqlReader.Read()) { BE_Emergencia oDesarmeUnidadesBE = CrearEntidadServiciosMedicamentoById(SqlReader); oEmergenciaBEList.Add(oDesarmeUnidadesBE); } } /*Cerrando las Conexion SqlReader*/ SqlReader.Close(); } } catch (Exception ex) { if (SqlReader != null && !SqlReader.IsClosed) { SqlReader.Close(); } throw ex; } return(oEmergenciaBEList); }
public EmergenciaBEList GeallMedicamento() { EmergenciaBEList oEmergenciaBEList = new EmergenciaBEList(); SqlDataReader SqlReader = null; try { using (SqlConnection Conex = new SqlConnection(Configuraciones.CadenaConexion)) { /*Propiedades del SqlCommand*/ SqlCommand = new SqlCommand(); SqlCommand.CommandText = "sgsnet_sps_medicamento"; SqlCommand.Connection = Conex; SqlCommand.CommandType = CommandType.StoredProcedure; /*Abrir la Conexion del SqlReader*/ Conex.Open(); SqlReader = SqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection); if (SqlReader.HasRows) // Si Contiene Filas { while (SqlReader.Read()) { BE_Emergencia oDesarmeUnidadesBE = CrearEntidadMedicamento(SqlReader); oEmergenciaBEList.Add(oDesarmeUnidadesBE); } } /*Cerrando las Conexion SqlReader*/ SqlReader.Close(); } } catch (Exception ex) { if (SqlReader != null && !SqlReader.IsClosed) { SqlReader.Close(); } throw ex; } return(oEmergenciaBEList); }