public static Title TitleSelectExtended(SqlConnection sqlConnection, SqlTransaction sqlTransaction, int titleId)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(
CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
Title title = new TitleDAL().TitleSelectAuto(connection, transaction, titleId);
if (title != null)
{
title.TitleCreators = Title_CreatorDAL.Title_CreatorSelectByTitle(connection, transaction, titleId);
if (title.TitleCreators != null && title.TitleCreators.Count > 0)
{
CreatorDAL creatorDAL = new CreatorDAL();
foreach (Title_Creator titleCreator in title.TitleCreators)
{
titleCreator.Creator = creatorDAL.CreatorSelectAuto(connection, transaction, titleCreator.CreatorID);
}
}
title.TitleIdentifiers = new Title_TitleIdentifierDAL().Title_TitleIdentifierSelectByTitleID(connection, transaction, titleId);
title.TitleTypes = Title_TitleTypeDAL.SelectByTitle(connection, transaction, titleId);
title.Items = ItemDAL.ItemSelectByTitleID(connection, transaction, titleId);
title.TitleItems = new TitleItemDAL().TitleItemSelectByTitle(connection, transaction, titleId);
title.TitleTags = TitleTagDAL.TitleTagSelectByTitle(connection, transaction, titleId);
title.TitleAssociations = new TitleAssociationDAL().TitleAssociationSelectExtendedForTitle(connection, transaction, titleId);
title.TitleLanguages = new TitleLanguageDAL().TitleLanguageSelectByTitleID(connection, transaction, titleId);
}
return(title);
}
