public void insereCliente(Cliente cliente)
{
try
{
this.con.Open();
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO cliente (Nome,CPF,Telefone,Email) VALUES(@Nome,@CPF,@Telefone,@Email)";
cmd.Parameters.AddWithValue("@Nome", cliente.Nome);
cmd.Parameters.AddWithValue("@CPF", cliente.CPF);
cmd.Parameters.AddWithValue("@Telefone", cliente.Telefone);
cmd.Parameters.AddWithValue("@Email", cliente.Email);
cmd.ExecuteNonQuery();
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
finally{
this.con.Close();
}
}