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

        public dbSignal getSignal(string signalName, string nameSpace )
        {
            dbSignal signal = null;
            if (signalName != null)
            {
                String sql = "SELECT * FROM signal_master WHERE signal_name = ?";
                List<OleDbParameter> dbParams = new List<OleDbParameter>();
                dbParams.Add(CreateParameter("@signal_name", signalName));
                if (!string.IsNullOrEmpty(nameSpace))
                {
                    sql += " AND xmlns = ? ";
                    dbParams.Add(CreateParameter("@xmlns", nameSpace));
                }

                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);
                        if (signal.parentSignalId != null)
                            signal.ParentSignal = getSignal(signal.parentSignalId);

                    }
                    reader.Close();
                    reader.Dispose();
                }
            }
            return signal;
        }

 private bool LoadSignalModel(dbSignal dbsignal)
 {
     bool loaded = false;
     if (dbsignal != null)
     {
         var dao = new SignalDAO();
         dbsignal = dao.getSignal(dbsignal.signalId);
         _currentSignalModel = SignalManager.GetSignalModel(dbsignal.xmlns, dbsignal.signalName);
         LoadSignalModel(_currentSignalModel);
         loaded = true;
     }
     return loaded;
 }