public void CadastrarManutencao(Manutencao manutencao) { MySqlConnection conn = new SqlConnection().Criar(); MySqlCommand command = new MySqlCommand("INSERT INTO Manutencao (Veiculo_Id, Descricao, Data, Situacao, DataPrevista) values (@Veiculo_Id, @Descricao, @Data, @Situacao, @DataPrevista)", conn); command.Parameters.Add(new MySqlParameter("Veiculo_Id", manutencao.Veiculo.Id)); command.Parameters.Add(new MySqlParameter("Descricao", manutencao.Descricao)); command.Parameters.Add(new MySqlParameter("Data", manutencao.Data)); command.Parameters.Add(new MySqlParameter("DataPrevista", manutencao.DataPrevista)); command.Parameters.Add(new MySqlParameter("Situacao", "Em manutencao")); command.Prepare(); try { command.ExecuteNonQuery(); } finally { conn.Close(); } }
private List <Manutencao> convertDataReaderToList(MySqlDataReader dr) { List <Manutencao> manutencaos = new List <Manutencao>(); while (dr.Read()) { Manutencao m = new Manutencao() { Data = Convert.ToDateTime(dr["Data"]), DataPrevista = Convert.ToDateTime(dr["DataPrevista"]), Descricao = dr["Descricao"].ToString(), Situacao = dr["Situacao"].ToString() }; m.Veiculo = new ClassVeiculos(); m.Veiculo.Nome = dr["Nome"].ToString(); m.Veiculo.Placa = dr["Placa"].ToString(); manutencaos.Add(m); } return(manutencaos); }