internal void Insert(InformeDiscrepancia parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } OidAsociado = parent.Oid; GetNewCode(); try { ValidationRules.CheckRules(); if (!IsValid) { throw new iQValidationException(moleQule.Library.Resources.Messages.GENERIC_VALIDATION_ERROR); } parent.Session().Save(this.Base.Record); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
/// <summary> /// Devuelve el siguiente Serial de PlanAnual /// </summary> /// <returns></returns> private static Int64 GetNewSerial(InformeDiscrepancia parent) { // Obtenemos la lista de clientes ordenados por serial SortedBindingList <DiscrepanciaInfo> Discrepancias = DiscrepanciaList.GetSortedList("Serial", ListSortDirection.Ascending); // Obtenemos el último serial de servicio Int64 lastcode; if (Discrepancias.Count > 0) { lastcode = Discrepancias[Discrepancias.Count - 1].Serial; } else { lastcode = Convert.ToInt64(Resources.Defaults.DISCREPANCIA_CODE_FORMAT); } foreach (Discrepancia item in parent.Discrepancias) { if (item.Serial > lastcode) { lastcode = item.Serial; } } lastcode++; return(lastcode); }
/// <summary> /// Devuelve el siguiente código de PlanAnual. /// </summary> /// <returns></returns> public static string GetNewCode(InformeDiscrepancia parent) { Int64 lastcode = Discrepancia.GetNewSerial(parent); // Devolvemos el siguiente codigo de PlanAnual return(lastcode.ToString(Resources.Defaults.DISCREPANCIA_CODE_FORMAT)); }
internal void Update(InformeDiscrepancia parent) { this.RaiseListChangedEvents = false; // update (thus deleting) any deleted child objects foreach (InformeAmpliacion obj in DeletedList) { obj.DeleteSelf(parent); } // now that they are deleted, remove them from memory too DeletedList.Clear(); // AddItem/update any current child objects foreach (InformeAmpliacion obj in this) { if (obj.IsNew) { obj.Insert(parent); } else { obj.Update(parent); } } this.RaiseListChangedEvents = true; }
private void Fetch(Auditoria source) { try { SessionCode = source.SessionCode; _base.CopyValues(source); CriteriaEx criteria = CuestionAuditoria.GetCriteria(Session()); criteria.AddEq("OidAuditoria", this.Oid); _cuestiones = CuestionesAuditoria.GetChildList(criteria.List <CuestionAuditoria>()); criteria = InformeDiscrepancia.GetCriteria(Session()); criteria.AddEq("OidAuditoria", this.Oid); _informes = InformesDiscrepancias.GetChildList(criteria.List <InformeDiscrepancia>()); criteria = HistoriaAuditoria.GetCriteria(Session()); criteria.AddEq("OidAuditoria", this.Oid); _historial = HistoriaAuditorias.GetChildList(criteria.List <HistoriaAuditoria>()); criteria = NotificacionInterna.GetCriteria(Session()); criteria.AddEq("OidAsociado", this.Oid); criteria.AddEq("TipoAsociado", (long)TipoNotificacionAsociado.COMUNICADO_AUDITORIA); _notificaciones = NotificacionesInternas.GetChildList(criteria.List <NotificacionInterna>()); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
internal void DeleteSelf(InformeDiscrepancia parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } // if we're new then don't update the database if (this.IsNew) { return; } try { SessionCode = parent.SessionCode; Session().Delete(Session().Get <InformeAmpliacionRecord>(Oid)); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkNew(); }
internal void Update(InformeDiscrepancia parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } OidAsociado = parent.Oid; try { ValidationRules.CheckRules(); if (!IsValid) { throw new iQValidationException(moleQule.Library.Resources.Messages.GENERIC_VALIDATION_ERROR); } NotificacionInternaRecord obj = parent.Session().Get <NotificacionInternaRecord>(Oid); obj.CopyValues(this.Base.Record); parent.Session().Update(obj); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
internal void Insert(InformeDiscrepancia parent) { // if we're not dirty then don't update the database if (!this.IsDirty) { return; } //Debe obtener la sesion del padre pq el objeto es padre a su vez SessionCode = parent.SessionCode; OidInformeDiscrepancia = parent.Oid; GetNewCode(parent.Oid); try { ValidationRules.CheckRules(); if (!IsValid) { throw new iQValidationException(moleQule.Library.Resources.Messages.GENERIC_VALIDATION_ERROR); } parent.Session().Save(this.Base.Record); _ampliaciones.Update(this); _notificaciones.Update(this); } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
public void CopyValues(InformeDiscrepancia source) { if (source == null) { return; } _record.CopyValues(source.Base.Record); }
// called to retrieve data from the database private void DataPortal_Fetch(CriteriaEx criteria) { try { SessionCode = criteria.SessionCode; Childs = criteria.Childs; if (nHMng.UseDirectSQL) { Auditoria.DoLOCK(Session()); IDataReader reader = nHMng.SQLNativeSelect(criteria.Query); if (reader.Read()) { _base.CopyValues(reader); } if (Childs) { CuestionAuditoria.LOCK(AppContext.ActiveSchema.Code); string query = CuestionesAuditoria.SELECT_BY_AUDITORIA(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _cuestiones = CuestionesAuditoria.GetChildList(reader); InformeDiscrepancia.LOCK(AppContext.ActiveSchema.Code); query = InformesDiscrepancias.SELECT_BY_AUDITORIA(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _informes = InformesDiscrepancias.GetChildList(criteria.SessionCode, reader); HistoriaAuditoria.LOCK(AppContext.ActiveSchema.Code); query = HistoriaAuditorias.SELECT_BY_AUDITORIA(Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _historial = HistoriaAuditorias.GetChildList(reader); NotificacionInterna.LOCK(AppContext.ActiveSchema.Code); query = NotificacionesInternas.SELECT_BY_AUDITORIA(this.Oid, TipoNotificacionAsociado.COMUNICADO_AUDITORIA); reader = nHManager.Instance.SQLNativeSelect(query, Session()); _notificaciones = NotificacionesInternas.GetChildList(reader); } } } catch (Exception ex) { if (Transaction() != null) { Transaction().Rollback(); } iQExceptionHandler.TreatException(ex); } }
// private InformeDiscrepanciaList() { } /// <summary> /// Retrieve the complete list from db /// </summary> /// <returns>InformeDiscrepanciaList</returns> public static InformeDiscrepanciaList GetList(bool childs) { CriteriaEx criteria = InformeDiscrepancia.GetCriteria(InformeDiscrepancia.OpenSession()); criteria.Childs = childs; //No criteria. Retrieve all de List InformeDiscrepanciaList list = DataPortal.Fetch <InformeDiscrepanciaList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static Discrepancia NewChild(InformeDiscrepancia parent) { if (!CanAddObject()) { throw new System.Security.SecurityException( moleQule.Library.Resources.Messages.USER_NOT_ALLOWED); } Discrepancia obj = new Discrepancia(); obj.OidInforme = parent.Oid; return(obj); }
public static NotificacionInterna NewChild(InformeDiscrepancia parent) { if (!CanAddObject()) { throw new System.Security.SecurityException( moleQule.Library.Resources.Messages.USER_NOT_ALLOWED); } NotificacionInterna obj = new NotificacionInterna(); obj.OidAsociado = parent.Oid; return(obj); }
// called to retrieve data from db protected override void Fetch(CriteriaEx criteria) { this.RaiseListChangedEvents = false; Childs = criteria.Childs; SessionCode = criteria.SessionCode; try { if (nHMng.UseDirectSQL) { InformeDiscrepancia.LOCK(AppContext.ActiveSchema.Code); IDataReader reader = nHManager.Instance.SQLNativeSelect(InformeDiscrepanciaList.SELECT(), Session()); IsReadOnly = false; while (reader.Read()) { this.AddItem(InformeDiscrepanciaInfo.Get(reader, Childs)); } IsReadOnly = true; } else { IList <InformeDiscrepancia> list = criteria.List <InformeDiscrepancia>(); if (list.Count > 0) { IsReadOnly = false; foreach (InformeDiscrepancia item in list) { this.AddItem(item.GetInfo()); } IsReadOnly = true; } } } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } this.RaiseListChangedEvents = true; }
public static InformeAmpliacion NewChild(InformeDiscrepancia parent) { if (!CanAddObject()) { throw new System.Security.SecurityException( moleQule.Library.Resources.Messages.USER_NOT_ALLOWED); } InformeAmpliacion obj = new InformeAmpliacion(); obj.MarkAsChild(); obj.GetNewCode(parent.Oid); obj.OidInformeDiscrepancia = parent.Oid; obj.Numero = parent.Numero; return(obj); }
private void Fetch(int session_code, IDataReader source) { try { _base.CopyValues(source); if (Childs) { CuestionAuditoria.LOCK(AppContext.ActiveSchema.Code); string query = CuestionesAuditoria.SELECT_BY_AUDITORIA(this.Oid); IDataReader reader = nHManager.Instance.SQLNativeSelect(query, Session(session_code)); _cuestiones = CuestionesAuditoria.GetChildList(reader); InformeDiscrepancia.LOCK(AppContext.ActiveSchema.Code); query = InformesDiscrepancias.SELECT_BY_AUDITORIA(this.Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session(session_code)); _informes = InformesDiscrepancias.GetChildList(session_code, reader); HistoriaAuditoria.LOCK(AppContext.ActiveSchema.Code); query = HistoriaAuditorias.SELECT_BY_AUDITORIA(Oid); reader = nHManager.Instance.SQLNativeSelect(query, Session(session_code)); _historial = HistoriaAuditorias.GetChildList(reader); NotificacionInterna.LOCK(AppContext.ActiveSchema.Code); query = NotificacionesInternas.SELECT_BY_AUDITORIA(this.Oid, TipoNotificacionAsociado.COMUNICADO_AUDITORIA); reader = nHManager.Instance.SQLNativeSelect(query, Session(session_code)); _notificaciones = NotificacionesInternas.GetChildList(reader); } } catch (Exception ex) { iQExceptionHandler.TreatException(ex); } MarkOld(); }
public InformeCorrector NewItem(InformeDiscrepancia parent) { this.AddItem(InformeCorrector.NewChild(parent)); return(this[Count - 1]); }
public InformeAmpliacion NewItem(InformeDiscrepancia parent) { this.AddItem(InformeAmpliacion.NewChild(parent)); return(this[Count - 1]); }
public void CopyFrom(InformeDiscrepancia source) { _base.CopyValues(source); }
public Discrepancia NewItem(InformeDiscrepancia parent) { this.AddItem(Discrepancia.NewChild(parent)); return(this[Count - 1]); }
public NotificacionInterna NewItem(InformeDiscrepancia parent) { this.AddItem(NotificacionInterna.NewChild(parent)); return(this[Count - 1]); }
public static string SELECT() { return(InformeDiscrepancia.SELECT(new QueryConditions(), false)); }