public List <VacunasBO> ObtenerVacuna(int id)
{
var vacuna = new List <VacunasBO>();
SqlCommand cmd = new SqlCommand("SELECT * FROM Vacuna WHERE id=@id");
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Connection = con.establecerConexion();
con.AbrirConexion();
var query = cmd;
using (var dr = query.ExecuteReader())
{
while (dr.Read())
{
var v = new BO.VacunasBO
{
id = Convert.ToInt32(dr["id"].ToString()),
nombre = dr["nombre"].ToString()
};
vacuna.Add(v);
}
}
con.CerrarConexion();
return(vacuna);
}
public List <VacunasBO> ObtenerListaVacunas()
{
var vacunas = new List <VacunasBO>();
SqlCommand cmd = new SqlCommand("SELECT * FROM Vacuna");
cmd.Connection = con.establecerConexion();
con.AbrirConexion();
var query = cmd;
using (var dr = query.ExecuteReader())
{
while (dr.Read())
{
var v = new BO.VacunasBO
{
id = Convert.ToInt32(dr["id"].ToString()),
nombre = dr["nombre"].ToString()
};
vacunas.Add(v);
}
}
con.CerrarConexion();
return(vacunas);
}
