public List <AutoMarca> ObtenerAutosOfertados() { List <AutoMarca> lista = new List <AutoMarca>(); SqlConnection conn = new SqlConnection(@"Data Source=PABLITO\SQLDESARROLLO;Initial Catalog=Concesionaria;Integrated Security=True;"); conn.Open(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "select idAuto,patente,nombre,km,promocion,precio from Autos a join Marcas m on a.idMarca=m.idMarca where promocion=1"; SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { int idAuto = dr.GetInt32(0); string patente = dr.GetString(1); string marca = dr.GetString(2); int km = dr.GetInt32(3); bool promocion = dr.GetBoolean(4); float precio = dr.GetFloat(5); AutoMarca autoM = new AutoMarca(idAuto, patente, marca, km, promocion, precio); lista.Add(autoM); } dr.Close(); conn.Close(); return(lista); }
public AutoMarca ObtenerAutoUsado() { AutoMarca a = null; SqlConnection conn = new SqlConnection(@"Data Source=PABLITO\SQLDESARROLLO;Initial Catalog=Concesionaria;Integrated Security=True;"); conn.Open(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "select idAuto,patente,nombre,km,promocion,precio from Autos a join Marcas m on a.idMarca=m.idMarca where km=(select min(km) from Autos);"; SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { int idAuto = dr.GetInt32(0); string patente = dr.GetString(1); string marca = dr.GetString(2); int km = dr.GetInt32(3); bool promocion = dr.GetBoolean(4); float precio = dr.GetFloat(5); a = new AutoMarca(idAuto, patente, marca, km, promocion, precio); } dr.Close(); conn.Close(); return(a); }