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