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