public List <Carro> buscarPorModelo(string modelo) { System.Data.SqlClient.SqlConnection connection; connection = new System.Data.SqlClient.SqlConnection(); connection = DBConnectionFactory.GetInstance(); connection.Open(); SqlCommand command = new SqlCommand(); command.CommandText = "SELECT * FROM CARRO WHERE MODELO = @modelo"; command.Connection = connection; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@modelo", modelo); SqlDataReader reader = command.ExecuteReader(); List <Carro> lista = new List <Carro>(); while (reader.Read()) { Carro carro = new Carro() { marca = Convert.ToString(reader["marca"]), modelo = Convert.ToString(reader["modelo"]), ano = Convert.ToInt32(reader["ano"]), cor = Convert.ToString(reader["cor"]) }; lista.Add(carro); } reader.Close(); connection.Close(); return(lista); }
public void cadastrar(Carro carro) { System.Data.SqlClient.SqlConnection connection; connection = new System.Data.SqlClient.SqlConnection(); connection = DBConnectionFactory.GetInstance(); connection.Open(); SqlCommand command = new SqlCommand(); command.CommandText = "INSERT INTO CARRO (MARCA, MODELO, ANO, COR) VALUES (@marca, @modelo, @ano, @cor)"; command.Connection = connection; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@marca", carro.marca); command.Parameters.AddWithValue("@modelo", carro.modelo); command.Parameters.AddWithValue("@ano", carro.ano); command.Parameters.AddWithValue("@cor", carro.cor); command.ExecuteNonQuery(); connection.Close(); }