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 />")); }