/// <summary> /// Sybase internal use only. /// <summary> public void RbsReplayInternal(YPF.Comercial.RRCC.SUP.Mail entity) { YPF.Comercial.RRCC.SUP.intrnl.OperationReplay _replay = new YPF.Comercial.RRCC.SUP.intrnl.OperationReplay(); _replay.RemoteId = ("."); _replay.Component = ("CRMMobileDesa.Mail_rs"); _replay.EntityKey = (entity.KeyToString()); _replay.Operation = (entity.LastOperation); bool _includeBig = !("delete").Equals(_replay.Operation); com.sybase.afx.json.JsonObject _parameters = new com.sybase.afx.json.JsonObject(); _parameters.Put("entity", YPF.Comercial.RRCC.SUP.Mail.__toJSON(entity, _includeBig)); //_replay.Parameters =(_parameters.ToString()); //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction _tran = null; try { _tran = _conn.BeginTransaction(); com.sybase.afx.json.JsonObject _json = new com.sybase.afx.json.JsonObject(); _replay.Attributes = (_json.ToString()); _replay.Save(); _replay.SaveParameter(_parameters); _tran.Commit(); } catch (Sybase.Persistence.PersistenceException pe) { _tran.Rollback(); throw pe; } catch (System.ApplicationException e) { _tran.Rollback(); throw e; } //} }
/// <summary> /// copy the MBO attributes to current MBO /// </summary> public void CopyAll(YPF.Comercial.RRCC.SUP.DireccionEntrega entity) { this._isNew = entity._isNew; this.__idDireccionEntrega = entity.__idDireccionEntrega; this.__razonSocial = entity.__razonSocial; this.__CUIT = entity.__CUIT; this.__agrupacion = entity.__agrupacion; this.__UN = entity.__UN; this.__contacto = entity.__contacto; this.__APIES = entity.__APIES; this.__cuentaSGC = entity.__cuentaSGC; this.__cuentaLPO = entity.__cuentaLPO; this.__cuentaLP2 = entity.__cuentaLP2; this.__cuentaQP1 = entity.__cuentaQP1; this.__operaYER = entity.__operaYER; this.__cantidadTarjetaYER = entity.__cantidadTarjetaYER; this.__direccion = entity.__direccion; this.__direccionValid = entity.__direccionValid; this.__mail = entity.__mail; this.__mailValid = entity.__mailValid; this.__telefono = entity.__telefono; this.__telefonoValid = entity.__telefonoValid; this.__pending = entity.__pending; this.__pendingChange = entity.__pendingChange; this.__replayPending = entity.__replayPending; this.__replayFailure = entity.__replayFailure; this.__direccionFK = entity.__direccionFK; this.__mailFK = entity.__mailFK; this.__telefonoFK = entity.__telefonoFK; this.__surrogateKey = entity.SurrogateKey; this.__replayCounter = entity.__replayCounter; this.__disableSubmit = entity.__disableSubmit; }
/// <summary> /// Clear the reference of relationships in memory. /// </summary> public void ClearRelationshipObjects() { __direccionValid = false; __direccion = null; __mailValid = false; __mail = null; __telefonoValid = false; __telefono = null; }
/// <summary> /// Find a mobile business object YPF.Comercial.RRCC.SUP.Mail /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static YPF.Comercial.RRCC.SUP.Mail FindByPrimaryKey(string idDireccionEntrega) { YPF.Comercial.RRCC.SUP.Mail result_2 = null; System.Data.IDataReader rs_4 = null; int count_5 = 0; Sybase.Persistence.ConnectionWrapper _conn = null; try { _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); string _selectSQL = "SELECT x.\"a\",x.\"b\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"c\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_mail\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"c\" from \"crmmobiledesa_1_0_mail_os\" x_os where x_os.\"c\" = x.\"c\")))) and ( x.\"a\" = ?)"; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "idDireccionEntrega", idDireccionEntrega); rs_4 = ps_3.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4)) { YPF.Comercial.RRCC.SUP.Mail entity_6 = new YPF.Comercial.RRCC.SUP.Mail(); entity_6.Bind(profile, rs_4); count_5++; result_2 = entity_6; } if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5); if (ps_3 != null) ps_3.Dispose(); _selectSQL = null; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } return result_2; }
/// <summary> /// Set current MBO attributes by specified MBO. /// </summary> public static YPF.Comercial.RRCC.SUP.Mail Merge(YPF.Comercial.RRCC.SUP.Mail entity) { YPF.Comercial.RRCC.SUP.Mail ent = Find(entity._pk()); if (ent == null) { ent = new YPF.Comercial.RRCC.SUP.Mail(); } ent.CopyAll(entity); ent.Save(); return ent; }
/// <summary> /// Sybase internal use only. /// <summary> public void SetOriginalState(YPF.Comercial.RRCC.SUP.Mail orig) { __originalStateValid = true; __originalState = orig; }
protected override void Bind(Sybase.Persistence.ConnectionProfile profile, System.Data.IDataReader rs) { this.__idDireccionEntrega = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"idDireccionEntrega",0); this.__correo = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"correo",1); this.__pending = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"pending",2); this.__pendingChange = com.sybase.afx.db.ReaderUtil.GetChar(profile,rs,"pendingChange",3); this.__replayPending = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayPending",4); this.__replayFailure = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayFailure",5); this.__surrogateKey = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"surrogateKey",6); this.__replayCounter = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayCounter",7); this.__disableSubmit = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"disableSubmit",8); _isNew = false; _isDirty = false; if (this.IsPending) { this.SetOriginalState(null); this.__originalStateValid = false; } else { YPF.Comercial.RRCC.SUP.Mail os_1 = new YPF.Comercial.RRCC.SUP.Mail(); os_1.CopyAll(this); this.SetOriginalState(os_1); } }
private static YPF.Comercial.RRCC.SUP.Mail _find(long id, String sql, bool findOs, bool findNonPending) { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); System.Data.IDataReader _rs = null; int count = 0; try { YPF.Comercial.RRCC.SUP.Mail _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", id); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.Mail(); _rt.Bind(profile, _rs); count++; if(findOs) { _rt.__isOsEntity = true; _rt.__pending = false; } if( !findNonPending ) { if(_rt.IsPending) { break; } } else { if( !_rt.IsPending ) { break; } else { _rt = null; } } } if (_rs != null) com.sybase.afx.db.ReaderUtil.Close(profile, _rs, count); if (ps != null) ps.Dispose(); return _rt; } catch(System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// Refresh the mobile business object from database. /// </summary> public void Refresh() { if (!_isNew && !__isOsEntity) { YPF.Comercial.RRCC.SUP.Mail ent = Load(_pk()); CopyAll(ent); if (this.IsPending) { this.SetOriginalState(null); this.__originalStateValid = false; } else { YPF.Comercial.RRCC.SUP.Mail os_1 = new YPF.Comercial.RRCC.SUP.Mail(); os_1.CopyAll(this); this.SetOriginalState(os_1); } _isNew = false; _isDirty = false; } }
internal static YPF.Comercial.RRCC.SUP.Mail FromJSON(object _json) { if (_json == null) { return null; } else { YPF.Comercial.RRCC.SUP.Mail _obj = new YPF.Comercial.RRCC.SUP.Mail(); _obj._fromJSON((com.sybase.afx.json.JsonObject)_json); return _obj; } }
/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.Mail /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Mail> GetPendingObjects(char pendingChange, int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Mail> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Mail>(); System.Data.IDataReader rs_4 = null; int count_5 = 0; Sybase.Persistence.ConnectionWrapper _conn = null; try { _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection(); string _selectSQL = " x.\"a\",x.\"b\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"c\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_mail\" x where x.\"_pc\" = ?"; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps_3, "pendingChange", pendingChange); rs_4 = ps_3.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_4)) { YPF.Comercial.RRCC.SUP.Mail entity_6 = new YPF.Comercial.RRCC.SUP.Mail(); entity_6.Bind(profile, rs_4); count_5++; result_2.Add(entity_6); } if (rs_4 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_4, count_5); if (ps_3 != null) ps_3.Dispose(); _selectSQL = null; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } return result_2; }