internal static SqlConnection OpenDBConnection(string connectionString)
{
try
{
//if (EjsConnectionHandler.ConnectionObject == null
// || EjsConnectionHandler.ConnectionObject.State == System.Data.ConnectionState.Broken
// || EjsConnectionHandler.ConnectionObject.State == System.Data.ConnectionState.Closed
//)
//{
// EjsConnectionHandler.ConnectionObject = new SqlConnection(connectionString);
// EjsConnectionHandler.ConnectionObject.Open();
//}
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
return(connection);
}
catch (Exception ex)
{
//TODO: Add Logging code to event log
ejsFailureReport r = new ejsFailureReport((int)FAILURE_CODES.OpenDatabaseConnectionFailed,
"Open Database Connection Failed",
"The service cannot connect to the E Journal Server database at this moment.",
ex, false);
throw new FaultException <ejsFailureReport>(r, r.Header);
}
}
internal static void CloseDBConnection(SqlConnection connection)
{
try
{
connection.Close();
connection.Dispose();
}
catch (Exception ex)
{
//TODO: Add Logging code to event log
ejsFailureReport r = new ejsFailureReport((int)FAILURE_CODES.CloseDatabaseConnectionFailed,
"Close Database Connection Failed",
"The service cannot disconnect from the E Journal Server database at this moment.",
ex, false);
throw new FaultException <ejsFailureReport>(r, r.Header);
}
}
