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