//---------------------------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------------------------- /// <summary> /// Recupere DataRow d'un lecteur /// </summary> /// <returns></returns> private static DataRow GetDRAuteur(Int32 idAuteur) { String sqlQuery = "SELECT " + "* " + "FROM " + "auteur " + "WHERE " + "id_auteur = " + idAuteur; return(SQLClient.GetUniqueDataRow(_connectionString, sqlQuery)); }
//---------------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------------------- /// <summary> /// Recupere DataRow avec un ID Genre /// </summary> /// <param name="idGenre">ID du genre</param> /// <returns></returns> private static DataRow GetDRGenre(Int32 idGenre) { String sqlQuery = "SELECT " + "* " + "FROM " + "genre " + "WHERE " + "id_genre = " + idGenre; return(SQLClient.GetUniqueDataRow(_connectionSring, sqlQuery)); }
//----------------------------------------------------------------------------------------------------------------------------------------------- //----------------------------------------------------------------------------------------------------------------------------------------------- //----------------------------------------------------------------------------------------------------------------------------------------------- /// <summary> /// Recuperation d'une DataRow avec les données d'une relance /// </summary> /// <param name="idRelance">ID de la relance</param> /// <returns></returns> private static DataRow GetDRRelance(Int32 idRelance) { String sqlQuery = "SELECT " + "* " + "FROM " + "relance " + "WHERE " + "idRelance = " + idRelance; return(SQLClient.GetUniqueDataRow(_connectionString, sqlQuery)); }
//------------------------------------------------------------------------------------------------------------------------ //------------------------------------------------------------------------------------------------------------------------ //------------------------------------------------------------------------------------------------------------------------ /// <summary> /// Recupere un lecteur (OBJET) /// </summary> /// <param name="idLecteur">ID du lecteur</param> /// <returns></returns> private static DataRow GetDRLecteur(Int32 idLecteur) { String sqlQuery = "SELECT * FROM lecteur WHERE idLecteur = " + idLecteur; return(SQLClient.GetUniqueDataRow(_connectionString, sqlQuery)); }