//Added for CSharp Station Report Wizard CR13 internal static bool ExecuteSelect(string SqlStatement, bool ErrMsg, string table, string CallingClass, string CallingFunction, out SAConnection _conn, out SADataReader myDataReader, bool bLocalDB) { bool RetVal = true; myDataReader = null; _conn = null; try { _conn = bLocalDB ? MainClass.GetConnection() : MainClass.GetMasterConnection(); _conn.Open(); RetVal = (ConnectionState.Open == _conn.State); if (RetVal) { SACommand cmd = new SACommand(SqlStatement, _conn); myDataReader = cmd.ExecuteReader(); } } catch (Exception ex) { RetVal = false; if (ErrMsg) { string err = String.Format(StringTable.GetString("DatabaseError"), table, ex.Message.ToString() + "(" + SqlStatement + ")"); ServiceMessages.InsertRec(MainClass.AppName, CallingClass, CallingFunction, err); } } return(RetVal); }
//Added for CSharp Station Report Wizard CR13 public static bool TestDBConnection(bool bLocalDB) { SAConnection _conn = null; bool RetVal = false; try { _conn = bLocalDB ? MainClass.GetConnection() : MainClass.GetMasterConnection(); _conn.Open(); RetVal = (ConnectionState.Open == _conn.State); } catch (Exception ex) { RetVal = false; } finally { if (_conn != null) { _conn.Close(); } } return(RetVal); }