//----------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------
/// <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));
}
