// called to retrieve data from the database private void DataPortal_Fetch(CriteriaEx criteria) { try { SessionCode = criteria.SessionCode; Childs = criteria.Childs; if (nHMng.UseDirectSQL) { Cuestion.LOCK(AppContext.ActiveSchema.Code); IDataReader reader = Cuestion.DoSELECT(AppContext.ActiveSchema.Code, Session(), criteria.Oid); if (reader.Read()) { _base.CopyValues(reader); } if (Childs) { CuestionAuditoria.LOCK(AppContext.ActiveSchema.Code); string query = CuestionesAuditoria.SELECT_BY_CUESTION(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _cuestiones = CuestionesAuditoria.GetChildList(reader); } } else { _base.Record.CopyValues((CuestionRecord)(criteria.UniqueResult())); Session().Lock(Session().Get <CuestionRecord>(Oid), LockMode.UpgradeNoWait); if (Childs) { criteria = CuestionAuditoria.GetCriteria(Session()); criteria.AddEq("OidCuestion", this.Oid); _cuestiones = CuestionesAuditoria.GetChildList(criteria.List <CuestionAuditoria>()); } } } catch (NHibernate.ADOException) { if (Transaction() != null) { Transaction().Rollback(); } throw new iQLockException(moleQule.Library.Resources.Messages.LOCK_ERROR); } catch (Exception ex) { if (Transaction() != null) { Transaction().Rollback(); } iQExceptionHandler.TreatException(ex); } }
private void Fetch(int session_code, IDataReader source) { try { _base.CopyValues(source); if (Childs) { CuestionAuditoria.LOCK(AppContext.ActiveSchema.Code); string query = CuestionesAuditoria.SELECT_BY_CUESTION(this.Oid); IDataReader reader = nHManager.Instance.SQLNativeSelect(query, Session(session_code)); _cuestiones = CuestionesAuditoria.GetChildList(reader); } } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }