private static void CreateSqlTables(string connectionString) { SqlConnection connection; SqlTransaction transaction; using (connection = new SqlConnection(connectionString)) { connection.Open( ); transaction = connection.BeginTransaction( ); try { SqlCommand command; //Create Tables command = new SqlCommand(DatabaseScripts.StorageServerOptionsDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery( ); // version VersionSqlInstaller.CreateVersionTable(connection, transaction); #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Options, 1, 2); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Options, 1, 0); #endif // #if (LEADTOOLS_V19_OR_LATER) command.Dispose( ); transaction.Commit( ); } catch (Exception) { transaction.Rollback( ); throw; } finally { transaction.Dispose( ); } } }
public static void CreateMediaCreationTables(SqlConnection connection, SqlTransaction transaction) { SqlCommand command; {//Create Tables command = new SqlCommand(DatabaseScripts.MediaCreationDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); }//Create Tables VersionSqlInstaller.CreateVersionTable(connection, transaction); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Media, 1, 2); command.Dispose(); }
private static void CreateSqlTables(string connectionString) { SqlConnection connection; SqlTransaction transaction; using (connection = new SqlConnection(connectionString)) { connection.Open( ); transaction = connection.BeginTransaction( ); try { SqlCommand command; {//Create Tables command = new SqlCommand(DatabaseScripts.LoggingDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery( ); } VersionSqlInstaller.CreateVersionTable(connection, transaction); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Logging, 1, 6); command.Dispose( ); transaction.Commit( ); } catch (Exception) { transaction.Rollback( ); throw; } finally { transaction.Dispose( ); } } }
private static void CreateSqlTables(string connectionString) { SqlConnection connection; SqlTransaction transaction; using (connection = new SqlConnection(connectionString)) { connection.Open( ); transaction = connection.BeginTransaction( ); try { SqlCommand command; // Create Tables command = new SqlCommand(DatabaseScripts.StorageServerDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); // media creation -- only in LEAD Toolkit // command = new SqlCommand(MediaCreationSqlInstaller.DatabaseScripts.MediaCreationDatabase, connection); // command.Transaction = transaction; // command.ExecuteNonQuery(); // Worklist creation -- only in LEAD Toolkit // command = new SqlCommand(WorklistSqlInstaller.DatabaseScripts.WorklistDatabase, connection); // command.Transaction = transaction; // command.ExecuteNonQuery(); // version VersionSqlInstaller.CreateVersionTable(connection, transaction); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Logging, 1, 6); #if (LEADTOOLS_V20_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.AeManagement, 1, 4); #elif (LEADTOOLS_V19_OR_LATER_MEDICAL_CLIENT_FRIENDLY_NAME) || (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.AeManagement, 1, 1); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.AeManagement, 1, 0); #endif VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Forward, 1, 0); #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Options, 1, 2); #endif // #if (LEADTOOLS_V19_OR_LATER) #if (LEADTOOLS_V20_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.UserManagement, 1, 4); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.UserManagement, 1, 1); #endif #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 13); #elif (LEADTOOLS_V19_OR_LATER_MEDICAL_EXTERNAL_STORE) || (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 8); #elif (LEADTOOLS_V19_OR_LATER_STORE_AE_TITLE) || (LEADTOOLS_V18_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 7); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 6); #endif // #if (LEADTOOLS_V19_OR_LATER_MEDICAL_EXTERNAL_STORE) || (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Permissions, 1, 6); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.AePermissions, 1, 0); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.JobsDownload, 1, 1); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.PatientAccess, 1, 0); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.ExportLayout, 1, 1); command.Dispose( ); transaction.Commit( ); } catch (Exception) { transaction.Rollback( ); throw; } finally { transaction.Dispose( ); } } }
private static void CreateSqlTables(string connectionString) { SqlConnection connection; SqlTransaction transaction; using (connection = new SqlConnection(connectionString)) { connection.Open( ); transaction = connection.BeginTransaction( ); try { SqlCommand command; // logging command = new SqlCommand(DicomLoggingSqlInstaller.DatabaseScripts.LoggingDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); // storage command = new SqlCommand(DicomStorageSqlInstaller.DatabaseScripts.StorageDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); #if (LEADTOOLS_V19_OR_LATER) // options command = new SqlCommand(DicomStorageServerOptionsSqlInstaller.DatabaseScripts.StorageServerOptionsDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); #endif // #if (LEADTOOLS_V19_OR_LATER) // media creation command = new SqlCommand(MediaCreationSqlInstaller.DatabaseScripts.MediaCreationDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); // workstation creation command = new SqlCommand(WorkstationSqlInstaller.DatabaseScripts.WorkstationDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); // workstation users management creation command = new SqlCommand(WorkstationUsersManagementSqlInstaller.DatabaseScripts.WorkstationUsersDatabase, connection); command.Transaction = transaction; command.ExecuteNonQuery(); // version VersionSqlInstaller.CreateVersionTable(connection, transaction); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Logging, 1, 6); #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 13); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Storage, 1, 6); #endif // (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Media, 1, 2); VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Workstation, 1, 5); #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.UserManagement, 1, 4); #else VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.UserManagement, 1, 1); #endif VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.MedicalWorkstation, 1, 0); #if (LEADTOOLS_V19_OR_LATER) VersionSqlInstaller.InsertVersionTable(connection, transaction, ConfigurationData.DataAccessLayerVersionNames.Options, 1, 2); #endif // #if (LEADTOOLS_V19_OR_LATER) // Cleanup command.Dispose(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw; } finally { transaction.Dispose(); } } }