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);
}
