/// <summary>
/// Delete values from TitleAssociation_TitleIdentifier by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="connectionKeyName">Connection key name located in config file.</param>
/// <param name="titleAssociation_TitleIdentifierID"></param>
/// <returns>true if successful otherwise false.</returns>
public bool TitleAssociation_TitleIdentifierDeleteAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
int titleAssociation_TitleIdentifierID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("TitleAssociation_TitleIdentifierDeleteAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("TitleAssociation_TitleIdentifierID", SqlDbType.Int, null, false, titleAssociation_TitleIdentifierID),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, PageType pageType)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
new PageTypeDAL().PageTypeManageAuto(connection, transaction, pageType);
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
/// <summary>
/// Delete values from CreatorRoleType by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="creatorRoleTypeID">Unique identifier for each Creator Role Type.</param>
/// <returns>true if successful otherwise false.</returns>
public bool CreatorRoleTypeDeleteAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int creatorRoleTypeID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("CreatorRoleTypeDeleteAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("CreatorRoleTypeID", SqlDbType.Int, null, false, creatorRoleTypeID),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete values from IndicatedPage by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="pageID">Unique identifier for each Page record.</param>
/// <param name="sequence">A number to separately identify various series of Indicated Pages.</param>
/// <returns>true if successful otherwise false.</returns>
public bool IndicatedPageDeleteAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
int pageID,
short sequence)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageDeleteAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID),
CustomSqlHelper.CreateInputParameter("Sequence", SqlDbType.SmallInt, null, false, sequence),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete values from Institution by primary key(s).
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="connectionKeyName">Connection key name located in config file.</param>
/// <param name="institutionCode">Code for Institution providing assistance.</param>
/// <returns>true if successful otherwise false.</returns>
public bool InstitutionDeleteAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
string connectionKeyName,
string institutionCode)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings(connectionKeyName), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("InstitutionDeleteAuto", connection, transaction,
CustomSqlHelper.CreateInputParameter("InstitutionCode", SqlDbType.NVarChar, 10, false, institutionCode),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
public bool IndicatedPageInsertNext(SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID,
string pagePrefix, string pageNumber, bool implied, int userId)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(
CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
using (SqlCommand command = CustomSqlHelper.CreateCommand("IndicatedPageInsertNext", connection, transaction,
CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID),
CustomSqlHelper.CreateInputParameter("PagePrefix", SqlDbType.NVarChar, 20, true, pagePrefix),
CustomSqlHelper.CreateInputParameter("PageNumber", SqlDbType.NVarChar, 20, true, pageNumber),
CustomSqlHelper.CreateInputParameter("Implied", SqlDbType.Bit, null, false, implied),
CustomSqlHelper.CreateInputParameter("CreationUserID", SqlDbType.Int, null, false, userId),
CustomSqlHelper.CreateInputParameter("LastModifiedUserID", SqlDbType.Int, null, false, userId),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
public bool IndicatedPageDeleteAllForPage(SqlConnection sqlConnection, SqlTransaction sqlTransaction, int pageID)
{
SqlConnection connection = CustomSqlHelper.CreateConnection(
CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"), sqlConnection);
SqlTransaction transaction = sqlTransaction;
try
{
using (SqlCommand command =
CustomSqlHelper.CreateCommand("IndicatedPageDeleteAllForPage", connection, sqlTransaction,
CustomSqlHelper.CreateInputParameter("PageID", SqlDbType.Int, null, false, pageID),
CustomSqlHelper.CreateReturnValueParameter("ReturnCode", SqlDbType.Int, null, false)))
{
int returnCode = CustomSqlHelper.ExecuteNonQuery(command, "ReturnCode");
if (transaction == null)
{
CustomSqlHelper.CloseConnection(connection);
}
if (returnCode == 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
throw new Exception("Exception in IndicatedPageDeleteAllForPage", ex);
}
}
public void Dispose()
{
if (connection != null)
{
CustomSqlHelper.CloseConnection(connection);
}
}
public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Item item, int userId)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
new ItemDAL().ItemManageAuto(connection, transaction, item, userId);
if (item.Pages.Count > 0)
{
PageDAL pageDAL = new PageDAL();
foreach (Page page in item.Pages)
{
pageDAL.PageManageAuto(connection, transaction, page, userId);
}
}
if (item.TitleItems.Count > 0)
{
TitleItemDAL titleItemDAL = new TitleItemDAL();
foreach (TitleItem titleItem in item.TitleItems)
{
titleItemDAL.TitleItemManageAuto(connection, transaction, titleItem);
}
}
if (item.ItemLanguages.Count > 0)
{
ItemLanguageDAL itemLanguageDAL = new ItemLanguageDAL();
foreach (ItemLanguage itemLanguage in item.ItemLanguages)
{
itemLanguageDAL.ItemLanguageManageAuto(connection, transaction, itemLanguage);
}
}
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
public PDF AddNewPdf(SqlConnection sqlConnection, SqlTransaction sqlTransaction,
int itemID, String emailAddress, String shareWith, bool imagesOnly,
String articleTitle, String articleCreators, String articleTags, List <int> pageIDs)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection = CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
// Add the new pdf record
PDF newPdf = new PDF();
newPdf.ItemID = itemID;
newPdf.EmailAddress = emailAddress;
newPdf.ShareWithEmailAddresses = shareWith;
newPdf.ImagesOnly = imagesOnly;
newPdf.ArticleTitle = articleTitle;
newPdf.ArticleCreators = articleCreators;
newPdf.ArticleTags = articleTags;
newPdf.PdfStatusID = 10;
PDF savedpdf = new PDFDAL().PDFInsertAuto(connection, transaction, newPdf);
// Add records for the pdf pages
PDFPageDAL pdfPageDal = new PDFPageDAL();
foreach (int pageID in pageIDs)
{
PDFPage newPdfPage = new PDFPage();
newPdfPage.PdfID = savedpdf.PdfID;
newPdfPage.PageID = pageID;
pdfPageDal.PDFPageInsertAuto(connection, transaction, newPdfPage);
}
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
return(savedpdf);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in AddNewPdf", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction,
TitleAssociation titleAssociation)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
CustomDataAccessStatus <TitleAssociation> updatedTitleAssociation =
new TitleAssociationDAL().TitleAssociationManageAuto(connection, transaction, titleAssociation);
if (titleAssociation.TitleAssociationIdentifiers.Count > 0)
{
TitleAssociation_TitleIdentifierDAL titleAssociationTitleIdentifierDAL = new TitleAssociation_TitleIdentifierDAL();
foreach (TitleAssociation_TitleIdentifier titleAssociationTitleIdentifier in titleAssociation.TitleAssociationIdentifiers)
{
if (titleAssociationTitleIdentifier.TitleAssociationID == 0)
{
titleAssociationTitleIdentifier.TitleAssociationID = updatedTitleAssociation.ReturnObject.TitleAssociationID;
}
titleAssociationTitleIdentifierDAL.TitleAssociation_TitleIdentifierManageAuto(connection, transaction, titleAssociationTitleIdentifier);
}
}
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Vault vault)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
if (vault.VaultID == 0)
{
using (SqlCommand command = CustomSqlHelper.CreateCommand("VaultSelectMaxID", connection, transaction))
{
using (CustomSqlHelper <int> helper = new CustomSqlHelper <int>())
{
CustomGenericList <int> list = helper.ExecuteReader(command);
vault.VaultID = list[0] + 1;
}
}
}
new VaultDAL().VaultManageAuto(connection, transaction, vault);
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
public static void SaveList(SqlConnection sqlConnection, SqlTransaction sqlTransaction,
CustomGenericList <PageName> pageNames)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
if (pageNames.Count > 0)
{
PageNameDAL pageNameDAL = new PageNameDAL();
foreach (PageName pageName in pageNames)
{
pageNameDAL.PageNameManageAuto(connection, transaction, pageName);
}
}
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
public static void Save(SqlConnection sqlConnection, SqlTransaction sqlTransaction, Title title, int userId)
{
SqlConnection connection = sqlConnection;
SqlTransaction transaction = sqlTransaction;
if (connection == null)
{
connection =
CustomSqlHelper.CreateConnection(CustomSqlHelper.GetConnectionStringFromConnectionStrings("BHL"));
}
bool isTransactionCoordinator = CustomSqlHelper.IsTransactionCoordinator(transaction);
try
{
transaction = CustomSqlHelper.BeginTransaction(connection, transaction, isTransactionCoordinator);
CustomDataAccessStatus <Title> updatedTitle =
new TitleDAL().TitleManageAuto(connection, transaction, title, userId);
if (title.TitleCreators.Count > 0)
{
Title_CreatorDAL titleCreatorDAL = new Title_CreatorDAL();
foreach (Title_Creator titleCreator in title.TitleCreators)
{
if (titleCreator.TitleID == 0)
{
titleCreator.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleCreatorDAL.Title_CreatorManageAuto(connection, transaction, titleCreator, userId);
}
}
if (title.TitleTags.Count > 0)
{
TitleTagDAL titleTagDAL = new TitleTagDAL();
foreach (TitleTag titleTag in title.TitleTags)
{
if (titleTag.TitleID == 0)
{
titleTag.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleTagDAL.TitleTagManageAuto(connection, transaction, titleTag);
}
}
if (title.TitleIdentifiers.Count > 0)
{
Title_TitleIdentifierDAL titleTitleIdentifierDAL = new Title_TitleIdentifierDAL();
foreach (Title_TitleIdentifier titleTitleIdentifier in title.TitleIdentifiers)
{
if (titleTitleIdentifier.TitleID == 0)
{
titleTitleIdentifier.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleTitleIdentifierDAL.Title_TitleIdentifierManageAuto(connection, transaction, titleTitleIdentifier);
}
}
if (title.TitleAssociations.Count > 0)
{
TitleAssociationDAL titleAssociationDAL = new TitleAssociationDAL();
foreach (TitleAssociation titleAssociation in title.TitleAssociations)
{
if (titleAssociation.TitleID == 0)
{
titleAssociation.TitleID = updatedTitle.ReturnObject.TitleID;
}
TitleAssociationDAL.Save(connection, transaction, titleAssociation);
}
}
if (title.TitleLanguages.Count > 0)
{
TitleLanguageDAL titleLanguageDAL = new TitleLanguageDAL();
foreach (TitleLanguage titleLanguage in title.TitleLanguages)
{
if (titleLanguage.TitleID == 0)
{
titleLanguage.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleLanguageDAL.TitleLanguageManageAuto(connection, transaction, titleLanguage);
}
}
if (title.TitleTypes.Count > 0)
{
Title_TitleTypeDAL titleTypeDAL = new Title_TitleTypeDAL();
foreach (Title_TitleType titleType in title.TitleTypes)
{
if (titleType.TitleID == 0)
{
titleType.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleTypeDAL.Title_TitleTypeManageAuto(connection, transaction, titleType);
}
}
if (title.TitleItems.Count > 0)
{
ItemDAL itemDAL = new ItemDAL();
TitleItemDAL titleItemDAL = new TitleItemDAL();
foreach (TitleItem titleItem in title.TitleItems)
{
// Update the item
if (titleItem.TitleID == 0)
{
titleItem.TitleID = updatedTitle.ReturnObject.TitleID;
}
titleItemDAL.TitleItemManageAuto(connection, transaction, titleItem);
// Update the primary title id (stored on the Item table)
itemDAL.ItemUpdatePrimaryTitleID(connection, transaction, titleItem.ItemID, titleItem.PrimaryTitleID);
}
}
CustomSqlHelper.CommitTransaction(transaction, isTransactionCoordinator);
}
catch (Exception ex)
{
CustomSqlHelper.RollbackTransaction(transaction, isTransactionCoordinator);
throw new Exception("Exception in Save", ex);
}
finally
{
CustomSqlHelper.CloseConnection(connection, isTransactionCoordinator);
}
}
