public List<Carro> listarDestaques()
{
var lista = new List<Carro>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = conexao;
conn.Open();
String sql = "Select top 5 * from dbo.carro order by preco desc";
SqlCommand cmd = new SqlCommand(sql, conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Carro c = new Carro();
c.codigo = (reader["id"]).ToString();
c.categoria = (reader["categoria"]).ToString();
c.marca = (reader["marca"]).ToString();
c.tipo = (reader["tipo"]).ToString();
c.modelo = (reader["modelo"]).ToString();
c.ano = (reader["ano"]).ToString();
c.preco = (reader["preco"]).ToString();
c.proprietario = (reader["proprietario"]).ToString();
c.placa = (reader["placa"]).ToString();
c.cor = (reader["cor"]).ToString();
c.obs = (reader["obs"]) != null ? (reader["obs"]).ToString() : "";
c.dataAquisicao = (reader["data_aquisicao"]).ToString();
lista.Add(c);
}
}
}
return lista;
}
bool ICarroRepository.adicionarCarro(Carro car)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = conexao;
conn.Open();
String sql = "insert into dbo.carro (categoria, marca, tipo, modelo, ano, preco, proprietario, placa, cor, obs, data_aquisicao) values ("
+ car.categoria + ","
+ car.marca + ","
+ car.tipo + ","
+ "'" + car.modelo + "',"
+ car.ano + ","
+ car.preco.Replace(',', '.') + ","
+ "'" + car.proprietario + "',"
+"'" + car.placa + "',"
+"'" + car.cor + "',"
+"'" + car.obs + "',"
+"'" + car.dataAquisicao + "'" +
")";
SqlCommand cmd = new SqlCommand(sql, conn);
return cmd.ExecuteNonQuery() == 1;
}
}