ATMLDataAccessLibrary.db.daos.SignalDAO.GetBaseBSCSignal C# (CSharp) Method

        public dbSignal GetBaseBSCSignal()
        {
            dbSignal signal = null;
            String sql = "SELECT * FROM signal_master WHERE parent_signal_id = 1 AND xmlns LIKE '%STDBSC'";
            List<OleDbParameter> dbParams = new List<OleDbParameter>();
            OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams.ToArray());
            if (reader != null)
            {
                if (reader.Read())
                {
                    signal = new dbSignal();
                    signal.load(reader);
                    signal.ChildSignals = getChildSignals(signal.signalId);
                    signal.Attributes = getSignalAttributes(signal.signalId);
                }
                reader.Close();
                reader.Dispose();
            }
            return signal;
        }