protected void saveAsNewButton_Click( object sender, EventArgs e )
{
if ( validate( true ) )
{
int id = 0;
if ( idTextBox.Text.Trim().Length > 0 )
{
id = int.Parse( idTextBox.Text );
}
Vault vault = new Vault( id, serverTextBox.Text.Trim(), folderShareTextBox.Text.Trim(),
webVirtualFolderTextBox.Text.Trim(), OCRFolderShareTextBox.Text.Trim() );
vault.IsNew = true;
BHLProvider bp = new BHLProvider();
bp.SaveVault( vault );
}
else
{
return;
}
Response.Redirect( "/Admin/Dashboard.aspx" );
}
protected void Page_Load( object sender, EventArgs e )
{
if ( !IsPostBack )
{
BHLProvider bp = new BHLProvider();
CustomGenericList<Vault> vaults = bp.VaultSelectAll();
Vault emptyVault = new Vault();
vaults.Insert( 0, emptyVault );
ddlVaults.DataSource = vaults;
ddlVaults.DataTextField = "Description";
ddlVaults.DataValueField = "VaultID";
ddlVaults.DataBind();
}
errorControl.Visible = false;
}
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 );
}
}
/// <summary>
/// Update values in Vault. Returns an object of type Vault.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Vault.</param>
/// <returns>Object of type Vault.</returns>
public Vault VaultUpdateAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Vault value)
{
return VaultUpdateAuto(sqlConnection, sqlTransaction,
value.VaultID,
value.Server,
value.FolderShare,
value.WebVirtualDirectory,
value.OCRFolderShare);
}
/// <summary>
/// Manage Vault object.
/// If the object is of type CustomObjectBase,
/// then either insert values into, delete values from, or update values in Vault.
/// </summary>
/// <param name="sqlConnection">Sql connection or null.</param>
/// <param name="sqlTransaction">Sql transaction or null.</param>
/// <param name="value">Object of type Vault.</param>
/// <returns>Object of type CustomDataAccessStatus<Vault>.</returns>
public CustomDataAccessStatus<Vault> VaultManageAuto(
SqlConnection sqlConnection,
SqlTransaction sqlTransaction,
Vault value)
{
if (value.IsNew && !value.IsDeleted)
{
Vault returnValue = VaultInsertAuto(sqlConnection, sqlTransaction,
value.VaultID,
value.Server,
value.FolderShare,
value.WebVirtualDirectory,
value.OCRFolderShare);
return new CustomDataAccessStatus<Vault>(
CustomDataAccessContext.Insert,
true, returnValue);
}
else if (!value.IsNew && value.IsDeleted)
{
if (VaultDeleteAuto(sqlConnection, sqlTransaction,
value.VaultID))
{
return new CustomDataAccessStatus<Vault>(
CustomDataAccessContext.Delete,
true, value);
}
else
{
return new CustomDataAccessStatus<Vault>(
CustomDataAccessContext.Delete,
false, value);
}
}
else if (value.IsDirty && !value.IsDeleted)
{
Vault returnValue = VaultUpdateAuto(sqlConnection, sqlTransaction,
value.VaultID,
value.Server,
value.FolderShare,
value.WebVirtualDirectory,
value.OCRFolderShare);
return new CustomDataAccessStatus<Vault>(
CustomDataAccessContext.Update,
true, returnValue);
}
else
{
return new CustomDataAccessStatus<Vault>(
CustomDataAccessContext.NA,
false, value);
}
}
public void SaveVault( Vault vault )
{
VaultDAL.Save( null, null, vault );
}
private void fillCombos()
{
BHLProvider bp = new BHLProvider();
CustomGenericList<Institution> institutions = bp.InstituationSelectAll();
Institution emptyInstitution = new Institution();
emptyInstitution.InstitutionCode = "";
emptyInstitution.InstitutionName = "";
institutions.Insert(0, emptyInstitution);
ddlInst.DataSource = institutions;
ddlInst.DataTextField = "InstitutionName";
ddlInst.DataValueField = "InstitutionCode";
ddlInst.DataBind();
CustomGenericList<Language> languages = bp.LanguageSelectAll();
Language emptyLanguage = new Language();
emptyLanguage.LanguageCode = "";
emptyLanguage.LanguageName = "";
languages.Insert( 0, emptyLanguage );
ddlLang.DataSource = languages;
ddlLang.DataTextField = "LanguageName";
ddlLang.DataValueField = "LanguageCode";
ddlLang.DataBind();
CustomGenericList<Vault> vaults = bp.VaultSelectAll();
Vault emptyVault = new Vault();
emptyVault.VaultID = 0;
emptyVault.Description = "";
vaults.Insert( 0, emptyVault );
ddlVault.DataSource = vaults;
ddlVault.DataTextField = "Description";
ddlVault.DataValueField = "VaultID";
ddlVault.DataBind();
CustomGenericList<ItemStatus> itemStatuses = bp.ItemStatusSelectAll();
ddlItemStatus.DataSource = itemStatuses;
ddlItemStatus.DataTextField = "ItemStatusName";
ddlItemStatus.DataValueField = "ItemStatusID";
ddlItemStatus.DataBind();
}
protected void saveButton_Click( object sender, EventArgs e )
{
if ( validate( false ) )
{
if ( idHid.Value == null || idHid.Value == "" )
{
errorControl.AddErrorText( "Please select a vault before saving" );
errorControl.Visible = true;
return;
}
Vault vault = new Vault( int.Parse( idHid.Value ), serverTextBox.Text.Trim(), folderShareTextBox.Text.Trim(),
webVirtualFolderTextBox.Text.Trim(), OCRFolderShareTextBox.Text.Trim() );
vault.IsNew = false;
BHLProvider bp = new BHLProvider();
bp.SaveVault( vault );
}
else
{
return;
}
Response.Redirect( "/Admin/Dashboard.aspx" );
}
