//------------------------------------------ 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);
}
}
// -------------------------------------- SUPRRESSION D'UN FILM ---------------------------------------------//
public static void deleteFilm(string Nom, string Categorie, float Prix, string Support, int Quantite)
{
try
{
connectDB();
connect.Open();
_film unfilm = new _film(Nom, Categorie, Prix, Support, Quantite);
MySqlCommand requete = new MySqlCommand();
requete.Connection = connect;
requete.CommandText = "DELETE FROM film WHERE nomF='" + unfilm.getNomF() + "'";
requete.Prepare();
requete.ExecuteNonQuery();
}
catch (MySqlException suppFilm)
{
MessageBox.Show("erreur suppression du film :" + suppFilm);
}
}
// ----------------------------------- 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);
}
}
// FONCTION RECHERCHE FILM
public static ArrayList getAllFilm()
{
ArrayList ListFilm = new ArrayList();
try
{
connectDB();
connect.Open();
string reqF = "SELECT * FROM film";
_film unfilm;
MySqlCommand command = new MySqlCommand(reqF, connect);
lecteur = command.ExecuteReader();
while (lecteur.Read())
{
unfilm = new _film(lecteur.GetString(1), lecteur.GetString(2), lecteur.GetFloat(3), lecteur.GetString(4), lecteur.GetInt32(5));
ListFilm.Add(unfilm); // on ajoute
}
}
catch (Exception e)
{
MessageBox.Show("Problème lors de l'affichage des film. " + e);
}
return(ListFilm);
}
