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 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);
}
}
private PageNameDAL GetPageNameDalInstance()
{
if ( pageNameDal == null )
pageNameDal = new PageNameDAL();
return pageNameDal;
}
/// <summary>
/// Update the Name Bank ID and Active flag for the specified Page Name.
/// </summary>
/// <param name="pageNameID">Identifier of the Page Name to update</param>
/// <param name="nameBankID">Name Bank ID to assign to the Page Name</param>
/// <param name="active">Active flag value to assign to the Page Name</param>
/// <returns>The updated Page Name</returns>
public PageName PageNameUpdateNameBankID( int pageNameID, int nameBankID, bool active )
{
PageNameDAL dal = new PageNameDAL();
PageName storedPageName = dal.PageNameSelectAuto( null, null, pageNameID );
if ( storedPageName != null )
{
storedPageName.NameBankID = nameBankID;
storedPageName.Active = active;
storedPageName.LastUpdateDate = System.DateTime.Now;
storedPageName = dal.PageNameUpdateAuto( null, null, storedPageName );
}
else
{
throw new Exception( "Could not find existing page name record" );
}
return storedPageName;
}