Exemplos de MedicalWorkstationConfigurationDemo VersionSqlInstaller em C# (CSharp)

Exemplo n.º 1

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

Exemplo n.º 2

Arquivo: MediaCreationSqlInstaller.cs Projeto: muhamadramandani095/pacs-workstation-demo-dotnet

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

Exemplo n.º 3

Arquivo: DicomLoggingtDbInstaller.cs Projeto: muhamadramandani095/pacs-workstation-demo-dotnet

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

Exemplo n.º 4

Arquivo: DicomStorageServerDbInstaller.cs Projeto: muhamadramandani095/pacs-workstation-demo-dotnet

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

Exemplo n.º 5

Arquivo: MedicalWorkstationServerDbInstaller.cs Projeto: muhamadramandani095/pacs-workstation-demo-dotnet

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