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