//------------------------------------------ AJOUT FILM --------------------------------------// public static void getajoutfilm(string Nom, string Categorie, float Prix, string Support, int Quantite) { try { _film unfilm = new _film(Nom, Categorie, Prix, Support, Quantite); connectDB(); MySqlCommand requete = new MySqlCommand(); int idFilm = 0 + 1; requete.CommandText = "INSERT INTO film (nomF,categorieF,prixF,supportF,quantiteF) Values('" + unfilm.getNomF() + "','" + unfilm.getCategorieF() + "'," + unfilm.getPrixF() + ",'" + unfilm.getSupportF() + "'," + unfilm.getQuantiteF() + ");"; requete.Connection = connect; connect.Open(); requete.Prepare(); try { requete.ExecuteNonQuery(); } catch (Exception error) { MessageBox.Show("erreur" + error); } } catch (MySqlException ajout) { MessageBox.Show("erreur lors de l'ajout du film. :" + ajout); } }
// ----------------------------------- MODOFICATION D'UN FILM ----------------------------------// public static void updateFilm(string Nom, string Categorie, float Prix, string Support, int Quantite) { try { connectDB(); connect.Open(); _film unfilm = new _film(Nom, Categorie, Prix, Support, Quantite); MySqlCommand modif = new MySqlCommand(); modif.Connection = connect; modif.CommandText = "UPDATE film SET nomF='" + unfilm.getNomF() + "', categorieF='" + unfilm.getCategorieF() + "' ,prixF=" + unfilm.getPrixF() + ", supportF='" + unfilm.getSupportF() + "' ,quantiteF='" + unfilm.getQuantiteF() + "' WHERE nomF='" + unfilm.getNomF() + "';"; modif.Prepare(); modif.ExecuteNonQuery(); } catch (Exception modiFilm) { MessageBox.Show("erreur lors de la modification du film" + modiFilm); } }