Example #1
0
        protected void CreateDB()
        {
            DB_Toolbox environment_Tools_db = new DB_Toolbox();

            /* InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLE("Application")));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
             InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLE("Log")));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
             InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLE("Roles")));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
             InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLE("Priveleges")));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
             InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.SQL_KILL_SESSIONS(SystemName)));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
                InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLE("Users")));
             InstallerHolder.Controls.Add(new LiteralControl("<hr />"));*/
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_USER(constr, SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_TABLESPACE(constr, SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_PROFILE(constr, SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_DROP_ORACLE_ROLE(constr, SystemName + "_ROLE")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_ORACLE_PROFILE(constr, SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_ORACLE_TABLESPACE(SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_ORACLE_USER(constrSQLServer, SystemName, "ChangeYourPassWord")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_ORACLE_ROLE(constr, SystemName + "_ROLE")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_GRANT_ORACLE_PRIVILEGE(constr, "CREATE TABLE", SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_GRANT_ORACLE_PRIVILEGE(constr, "CREATE PROCEDURE", SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_GRANT_ORACLE_PRIVILEGE(constr, "CREATE SEQUENCE", SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_GRANT_ORACLE_PRIVILEGE(constr, "SELECT ANY DICTIONARY", SystemName)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Application")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Errors")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Log")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Roles")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Priveleges")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_TABLE("ORACLE", constr, "Users")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Users", "Name", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Errors", "Application_ID", "Number", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Roles", "Name", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Priveleges", "Name", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Application", "Name", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Application", "Version", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_COLUMN("ORACLE", constr, "Application", "CodeName", "varchar2(50)", "", false)));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
            InstallerHolder.Controls.Add(new LiteralControl(environment_Tools_db.EP_ADD_ORACLE_SEQUENCE("ORACLE", constr1, "APPLICATION")));
            InstallerHolder.Controls.Add(new LiteralControl("<hr />"));
        }