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