public static String GetApplicationName(Guid applicationId) { String appName = null; using (IDataReader reader = DBPortal.SchemaVersionGetSchemaVersion(applicationId)) { if (reader.Read()) { appName = reader["ApplicationName"].ToString(); } } return(appName); }
public static bool UpdateTableField( String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere) { return(DBPortal.DatabaseHelperUpdateTableField( tableName, keyFieldName, keyFieldValue, dataFieldName, dataFieldValue, additionalWhere)); }
public static int AddSchemaScriptHistory( Guid applicationId, string scriptFile, DateTime runTime, bool errorOccurred, string errorMessage, string scriptBody) { return(DBPortal.SchemaScriptHistoryAddSchemaScriptHistory( applicationId, scriptFile, runTime, errorOccurred, errorMessage, scriptBody)); }
public static Version DBSchemaVersion() { // this should never change // its the last version before auto upgrades int major = 2; int minor = 2; int build = 1; int revision = 4; bool found = false; try { using (IDataReader reader = DBPortal.SchemaVersionGetSchemaVersion(GetApplicationId())) { if (reader.Read()) { major = Convert.ToInt32(reader["Major"]); minor = Convert.ToInt32(reader["Minor"]); build = Convert.ToInt32(reader["Build"]); revision = Convert.ToInt32(reader["Revision"]); found = true; } } if (!found) { DBPortal.SchemaVersionAddSchemaVersion( GetApplicationId(), GetApplicationName(), major, minor, build, revision); } } catch (DbException) { } catch (InvalidOperationException) { } return(new Version(major, minor, build, revision)); }
public static Guid GetApplicationId(string applicationName) { if (string.Equals(applicationName, "mojoportal-core", StringComparison.InvariantCultureIgnoreCase)) { return(new Guid("077e4857-f583-488e-836e-34a4b04be855")); } var appID = Guid.NewGuid(); using (IDataReader reader = DBPortal.DatabaseHelperGetApplicationId(applicationName)) { if (reader.Read()) { appID = new Guid(reader["ApplicationID"].ToString()); } } return(appID); }
public static Version GetSchemaVersion(Guid applicationId) { //Guid mojoappID = new Guid("077e4857-f583-488e-836e-34a4b04be855"); //if (applicationID == mojoappID) //{ // return dbSchemaVersion(); //} int major = 0; int minor = 0; int build = 0; int revision = 0; try { using (IDataReader reader = DBPortal.SchemaVersionGetSchemaVersion(applicationId)) { if (reader.Read()) { major = Convert.ToInt32(reader["Major"]); minor = Convert.ToInt32(reader["Minor"]); build = Convert.ToInt32(reader["Build"]); revision = Convert.ToInt32(reader["Revision"]); } } } catch (DbException) { } catch (InvalidOperationException) { } catch (Exception ex) { // hate to trap System.Exception but SqlCeException doe snot inherit from DbException as it should if (DatabaseHelper.DBPlatform() != "SqlCe") { throw; } log.Error(ex); } return(new Version(major, minor, build, revision)); }
public static int ExecteNonQuery(string connectionString, string query) { return(DBPortal.DatabaseHelperExecteNonQuery(connectionString, query)); }
public static IDataReader GetReader(string connectionString, string query) { return(DBPortal.DatabaseHelperGetReader(connectionString, query)); }
public static String DBPlatform() { return(DBPortal.DBPlatform()); }
public static bool SchemaHasBeenCreated() { return(DBPortal.DatabaseHelperSitesTableExists()); }
public static DbException GetConnectionError(String overrideConnectionInfo) { return(DBPortal.DatabaseHelperGetConnectionError(overrideConnectionInfo)); }
public static bool CanAccessDatabase() { return(DBPortal.DatabaseHelperCanAccessDatabase()); }
private static String GetConnectionString() { return(DBPortal.GetConnectionString()); }
public static void DoForumVersion2203PostUpgradeTasks( String overrideConnectionInfo) { DBPortal.DatabaseHelperDoForumVersion2203PostUpgradeTasks(overrideConnectionInfo); }
public static bool DeleteSchemaScriptHistory(int id) { return(DBPortal.SchemaScriptHistoryDeleteSchemaScriptHistory(id)); }
public static DataTable GetTable(string connectionString, string tableName, string whereClause) { return(DBPortal.DatabaseHelperGetTable(connectionString, tableName, whereClause)); }
public static bool DeleteSchemaVersion(Guid applicationId) { return(DBPortal.SchemaVersionDeleteSchemaVersion(applicationId)); }
public static IDataReader GetReader(string connectionString, string tableName, string whereClause) { return(DBPortal.DatabaseHelperGetReader(connectionString, tableName, whereClause)); }
public static IDataReader GetSchemaScriptErrorHistory(Guid applicationId) { return(DBPortal.SchemaScriptHistoryGetSchemaScriptErrorHistory(applicationId)); }
public static IDataReader SchemaVersionGetNonCore() { return(DBPortal.SchemaVersionGetNonCore()); }
public static void DoVersion2320PostUpgradeTasks(string overrideConnectionInfo) { DBPortal.DatabaseHelperDoVersion2320PostUpgradeTasks(overrideConnectionInfo); }
public static void EnsureDatabase() { DBPortal.EnsureDatabase(); }
public static IDataReader GetSchemaScriptHistory(int id) { return(DBPortal.SchemaScriptHistoryGetSchemaScriptHistory(id)); }