static public bool RafraichirListeTypeMedias() { MySqlConnection mConnexion = new MySqlConnection(Program.ConnectionString); try { mConnexion.Open(); } catch { return(false); } using (MySqlCommand mCommande = mConnexion.CreateCommand()) { string requete; requete = "SELECT CODE_TYPE "; requete += "FROM TYPEMEDIA "; mCommande.CommandText = requete; using (MySqlDataReader mReader = mCommande.ExecuteReader()) { while (mReader.Read()) { TypeMedia typeMedia = new TypeMedia((int)mReader["CODE_TYPE"]); mListeTypeMedias.Add(typeMedia); } } } mConnexion.Close(); return(true); }
public Film(int code) { MySqlConnection mConnexion = new MySqlConnection(); mConnexion.ConnectionString = Program.ConnectionString; try { mConnexion.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Erreur de connexion", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } using (MySqlCommand mCommande = mConnexion.CreateCommand()) { string requete; requete = "SELECT CODE_ELEMENT, CODE_TYPE, ANNEE_SORTIE, LANGUE, NOM_ELEMENT, DATE_AJOUT "; requete += "FROM FILM "; requete += "WHERE CODE_ELEMENT = @CODE"; mCommande.CommandText = requete; mCommande.Parameters.AddWithValue("@CODE", code); using (MySqlDataReader mReader = mCommande.ExecuteReader()) { if (mReader.Read()) { mCode = (int)mReader["CODE_ELEMENT"]; mType = new TypeMedia((int)mReader["CODE_TYPE"]); mAnneeSortie = (int)mReader["ANNEE_SORTIE"]; mLangue = mReader["LANGUE"].ToString(); mNom = mReader["NOM_ELEMENT"].ToString(); mDateAjout = mReader["DATE_AJOUT"].ToString(); } } } mConnexion.Close(); }
public void SetType(TypeMedia type) { mType = type; }
public Film() { mType = new TypeMedia(); }
public static bool RafraichirListeTypeMedias() { MySqlConnection mConnexion = new MySqlConnection(Program.ConnectionString); try { mConnexion.Open(); } catch { return false; } using (MySqlCommand mCommande = mConnexion.CreateCommand()) { string requete; requete = "SELECT CODE_TYPE "; requete += "FROM TYPEMEDIA "; mCommande.CommandText = requete; using (MySqlDataReader mReader = mCommande.ExecuteReader()) { while (mReader.Read()) { TypeMedia typeMedia = new TypeMedia((int)mReader["CODE_TYPE"]); mListeTypeMedias.Add(typeMedia); } } } mConnexion.Close(); return true; }