C# Class mojoPortal.Business.DatabaseHelper

Show file Open project: joeaudette/mojoportal

Public Methods

Method	Description
AddSchemaScriptHistory ( System.Guid applicationId, string scriptFile, System.DateTime runTime, bool errorOccurred, string errorMessage, string scriptBody ) : int
CanAccessDatabase ( ) : bool
CanAlterSchema ( String overrideConnectionInfo ) : bool
DBCodeVersion ( ) : System.Version
DBPlatform ( ) : String
DBSchemaVersion ( ) : System.Version
DeleteSchemaScriptHistory ( int id ) : bool
DeleteSchemaVersion ( System.Guid applicationId ) : bool
DoForumVersion2202PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoForumVersion2203PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2230PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2234PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2247PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2253PostUpgradeTasks ( String overrideConnectionInfo ) : void
DoVersion2320PostUpgradeTasks ( String overrideConnectionInfo ) : void
EnsureDatabase ( ) : void
ExecteNonQuery ( string query ) : int
ExecteNonQuery ( string connectionString, string query ) : int
ExistingSiteCount ( ) : int
GetApplicationId ( ) : System.Guid
GetApplicationId ( string applicationName ) : System.Guid
GetApplicationName ( ) : String
GetApplicationName ( System.Guid applicationId ) : String
GetConnectionError ( String overrideConnectionInfo ) : DbException
GetReader ( String connectionString, String tableName, String whereClause ) : IDataReader
GetReader ( string query ) : IDataReader
GetReader ( string connectionString, string query ) : IDataReader
GetSchemaScriptErrorHistory ( System.Guid applicationId ) : IDataReader
GetSchemaScriptHistory ( System.Guid applicationId ) : IDataReader
GetSchemaScriptHistory ( int id ) : IDataReader
GetSchemaVersion ( System.Guid applicationId ) : System.Version
GetSchemaVersion ( string applicationName ) : System.Version
GetTable ( String connectionString, String tableName, String whereClause ) : DataTable
GetTableFromDataReader ( IDataReader reader ) : DataTable
ParseVersionFromFileName ( String fileName ) : System.Version
RunScript ( System.Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo ) : string
SchemaHasBeenCreated ( ) : bool
SchemaScriptHasBeenRun ( System.Guid applicationId, String scriptFile ) : bool
SchemaVersionGetNonCore ( ) : IDataReader
UpdateSchemaVersion ( System.Guid applicationId, string applicationName, int major, int minor, int build, int revision ) : bool
UpdateTableField ( String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
UpdateTableField ( String connectionString, String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool

Method Details

AddSchemaScriptHistory() public static method

public static AddSchemaScriptHistory ( System.Guid applicationId, string scriptFile, System.DateTime runTime, bool errorOccurred, string errorMessage, string scriptBody ) : int
applicationId	System.Guid
scriptFile	string
runTime	System.DateTime
errorOccurred	bool
errorMessage	string
scriptBody	string
return	int

CanAccessDatabase() public static method

public static CanAccessDatabase ( ) : bool
return	bool

CanAlterSchema() public static method

public static CanAlterSchema ( String overrideConnectionInfo ) : bool
overrideConnectionInfo	String
return	bool

DBCodeVersion() public static method

public static DBCodeVersion ( ) : System.Version
return	System.Version

DBPlatform() public static method

public static DBPlatform ( ) : String
return	String

DBSchemaVersion() public static method

public static DBSchemaVersion ( ) : System.Version
return	System.Version

DeleteSchemaScriptHistory() public static method

public static DeleteSchemaScriptHistory ( int id ) : bool
id	int
return	bool

DeleteSchemaVersion() public static method

public static DeleteSchemaVersion ( System.Guid applicationId ) : bool
applicationId	System.Guid
return	bool

DoForumVersion2202PostUpgradeTasks() public static method

public static DoForumVersion2202PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoForumVersion2203PostUpgradeTasks() public static method

public static DoForumVersion2203PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoVersion2230PostUpgradeTasks() public static method

public static DoVersion2230PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoVersion2234PostUpgradeTasks() public static method

public static DoVersion2234PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoVersion2247PostUpgradeTasks() public static method

public static DoVersion2247PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoVersion2253PostUpgradeTasks() public static method

public static DoVersion2253PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

DoVersion2320PostUpgradeTasks() public static method

public static DoVersion2320PostUpgradeTasks ( String overrideConnectionInfo ) : void
overrideConnectionInfo	String
return	void

EnsureDatabase() public static method

public static EnsureDatabase ( ) : void
return	void

ExecteNonQuery() public static method

public static ExecteNonQuery ( string query ) : int
query	string
return	int

ExecteNonQuery() public static method

public static ExecteNonQuery ( string connectionString, string query ) : int
connectionString	string
query	string
return	int

ExistingSiteCount() public static method

public static ExistingSiteCount ( ) : int
return	int

GetApplicationId() public static method

public static GetApplicationId ( ) : System.Guid
return	System.Guid

GetApplicationId() public static method

public static GetApplicationId ( string applicationName ) : System.Guid
applicationName	string
return	System.Guid

GetApplicationName() public static method

public static GetApplicationName ( ) : String
return	String

GetApplicationName() public static method

public static GetApplicationName ( System.Guid applicationId ) : String
applicationId	System.Guid
return	String

GetConnectionError() public static method

public static GetConnectionError ( String overrideConnectionInfo ) : DbException
overrideConnectionInfo	String
return	DbException

GetReader() public static method

public static GetReader ( String connectionString, String tableName, String whereClause ) : IDataReader
connectionString	String
tableName	String
whereClause	String
return	IDataReader

GetReader() public static method

public static GetReader ( string query ) : IDataReader
query	string
return	IDataReader

GetReader() public static method

public static GetReader ( string connectionString, string query ) : IDataReader
connectionString	string
query	string
return	IDataReader

GetSchemaScriptErrorHistory() public static method

public static GetSchemaScriptErrorHistory ( System.Guid applicationId ) : IDataReader
applicationId	System.Guid
return	IDataReader

GetSchemaScriptHistory() public static method

public static GetSchemaScriptHistory ( System.Guid applicationId ) : IDataReader
applicationId	System.Guid
return	IDataReader

GetSchemaScriptHistory() public static method

public static GetSchemaScriptHistory ( int id ) : IDataReader
id	int
return	IDataReader

GetSchemaVersion() public static method

public static GetSchemaVersion ( System.Guid applicationId ) : System.Version
applicationId	System.Guid
return	System.Version

GetSchemaVersion() public static method

public static GetSchemaVersion ( string applicationName ) : System.Version
applicationName	string
return	System.Version

GetTable() public static method

public static GetTable ( String connectionString, String tableName, String whereClause ) : DataTable
connectionString	String
tableName	String
whereClause	String
return	System.Data.DataTable

GetTableFromDataReader() public static method

public static GetTableFromDataReader ( IDataReader reader ) : DataTable
reader	IDataReader
return	System.Data.DataTable

ParseVersionFromFileName() public static method

public static ParseVersionFromFileName ( String fileName ) : System.Version
fileName	String
return	System.Version

RunScript() public static method

public static RunScript ( System.Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo ) : string
applicationId	System.Guid
scriptFile	System.IO.FileInfo
overrideConnectionInfo	String
return	string

SchemaHasBeenCreated() public static method

public static SchemaHasBeenCreated ( ) : bool
return	bool

SchemaScriptHasBeenRun() public static method

public static SchemaScriptHasBeenRun ( System.Guid applicationId, String scriptFile ) : bool
applicationId	System.Guid
scriptFile	String
return	bool

SchemaVersionGetNonCore() public static method

public static SchemaVersionGetNonCore ( ) : IDataReader
return	IDataReader

UpdateSchemaVersion() public static method

public static UpdateSchemaVersion ( System.Guid applicationId, string applicationName, int major, int minor, int build, int revision ) : bool
applicationId	System.Guid
applicationName	string
major	int
minor	int
build	int
revision	int
return	bool

UpdateTableField() public static method

public static UpdateTableField ( String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
tableName	String
keyFieldName	String
keyFieldValue	String
dataFieldName	String
dataFieldValue	String
additionalWhere	String
return	bool

UpdateTableField() public static method

public static UpdateTableField ( String connectionString, String tableName, String keyFieldName, String keyFieldValue, String dataFieldName, String dataFieldValue, String additionalWhere ) : bool
connectionString	String
tableName	String
keyFieldName	String
keyFieldValue	String
dataFieldName	String
dataFieldValue	String
additionalWhere	String
return	bool