/// <summary> /// Builds a AmpliacionList /// </summary> /// <param name="list"></param> /// <returns>AmpliacionList</returns> public static AmpliacionList GetList(bool childs) { CriteriaEx criteria = Ampliacion.GetCriteria(Ampliacion.OpenSession()); criteria.Childs = childs; criteria.Query = AmpliacionList.SELECT(); AmpliacionList list = DataPortal.Fetch <AmpliacionList>(criteria); CloseSession(criteria.SessionCode); return(list); }
private void Fetch(Discrepancia source) { try { SessionCode = source.SessionCode; _base.CopyValues(source); CriteriaEx criteria = Ampliacion.GetCriteria(Session()); criteria.AddEq("OidDiscrepancia", this.Oid); _ampliaciones = Ampliaciones.GetChildList(criteria.List <Ampliacion>()); criteria = AccionCorrectora.GetCriteria(Session()); criteria.AddEq("OidDiscrepancia", this.Oid); _correctoras = AccionesCorrectoras.GetChildList(criteria.List <AccionCorrectora>()); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
private void Fetch(InformeAmpliacion source) { try { SessionCode = source.SessionCode; _base.CopyValues(source); CriteriaEx criteria = Ampliacion.GetCriteria(Session()); criteria.AddEq("OidInformeAmpliacion", this.Oid); _ampliaciones = Ampliaciones.GetChildList(criteria.List <Ampliacion>()); criteria = NotificacionInterna.GetCriteria(Session()); criteria.AddEq("OidAsociado", this.Oid); criteria.AddEq("TipoAsociado", (long)TipoNotificacionAsociado.SOLICITUD_AMPLIACION); _notificaciones = NotificacionesInternas.GetChildList(criteria.List <NotificacionInterna>()); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
// called to retrieve data from the database private void DataPortal_Fetch(CriteriaEx criteria) { try { SessionCode = criteria.SessionCode; Childs = criteria.Childs; if (nHMng.UseDirectSQL) { InformeAmpliacion.LOCK(AppContext.ActiveSchema.Code); IDataReader reader = InformeAmpliacion.DoSELECT(AppContext.ActiveSchema.Code, Session(), criteria.Oid); if (reader.Read()) { _base.CopyValues(reader); } if (Childs) { Ampliacion.LOCK(AppContext.ActiveSchema.Code); string query = Ampliaciones.SELECT_BY_INFORME_AMPLIACION(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _ampliaciones = Ampliaciones.GetChildList(reader); NotificacionInterna.LOCK(AppContext.ActiveSchema.Code); query = NotificacionesInternas.SELECT_BY_INFORME_AMPLIACION(this.Oid, TipoNotificacionAsociado.SOLICITUD_AMPLIACION); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _notificaciones = NotificacionesInternas.GetChildList(reader); } } else { _base.Record.CopyValues((InformeAmpliacionRecord)(criteria.UniqueResult())); Session().Lock(Session().Get <InformeAmpliacionRecord>(Oid), LockMode.UpgradeNoWait); if (Childs) { criteria = Ampliacion.GetCriteria(Session()); criteria.AddEq("OidInformeAmpliacion", this.Oid); _ampliaciones = Quality.Ampliaciones.GetChildList(criteria.List <Ampliacion>()); criteria = NotificacionInterna.GetCriteria(Session()); criteria.AddEq("OidAsociado", this.Oid); criteria.AddEq("TipoAsociado", (long)TipoNotificacionAsociado.SOLICITUD_AMPLIACION); _notificaciones = Quality.NotificacionesInternas.GetChildList(criteria.List <NotificacionInterna>()); } } } 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); } }
// called to retrieve data from the database private void DataPortal_Fetch(CriteriaEx criteria) { try { SessionCode = criteria.SessionCode; Childs = criteria.Childs; if (nHMng.UseDirectSQL) { Discrepancia.LOCK(AppContext.ActiveSchema.Code); IDataReader reader = Discrepancia.DoSELECT(AppContext.ActiveSchema.Code, Session(), criteria.Oid); if (reader.Read()) { _base.CopyValues(reader); } if (Childs) { Ampliacion.LOCK(AppContext.ActiveSchema.Code); string query = Ampliaciones.SELECT_BY_DISCREPANCIA(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _ampliaciones = Ampliaciones.GetChildList(reader); AccionCorrectora.LOCK(AppContext.ActiveSchema.Code); query = AccionesCorrectoras.SELECT_BY_DISCREPANCIA(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _correctoras = AccionesCorrectoras.GetChildList(reader); } } else { _base.Record.CopyValues((DiscrepanciaRecord)(criteria.UniqueResult())); Session().Lock(Session().Get <DiscrepanciaRecord>(Oid), LockMode.UpgradeNoWait); if (Childs) { criteria = Ampliacion.GetCriteria(Session()); criteria.AddEq("OidDiscrepancia", this.Oid); _ampliaciones = Ampliaciones.GetChildList(criteria.List <Ampliacion>()); } } } 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); } }