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 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;
}
public Film()
{
mType = new TypeMedia();
}
public void SetType(TypeMedia type)
{
mType = type;
}
