/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq> FindAll(int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq> result_2 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq>(); 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 = " s.\"username\",s.\"remoteId\",s.\"UsuarioParam\",s.\"id\" from \"crmmobiledesa_1_0_representantecomercial_pull_pq\" s"; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); 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.intrnl.RepresentanteComercial_pull_pq entity_6 = new YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq(); 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); }
/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.LocalKeyGenerator /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.LocalKeyGenerator> FindAll(int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.LocalKeyGenerator> result_2 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.LocalKeyGenerator>(); 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.\"first_id\",x.\"last_id\",x.\"next_id\",x.\"remote_id\",x.\"batch_id\" from \"co_crmmobiledesa_1_0_localkeygenerator\" x order by x.\"first_id\""; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); 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.LocalKeyGenerator entity_6 = new YPF.Comercial.RRCC.SUP.LocalKeyGenerator(); 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); }
/// <summary> /// Find a List of YPF.Comercial.RRCC.SUP.intrnl.SISSubscription /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.SISSubscription> FindAll(int skip, int take) { skip = skip + 1; Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.SISSubscription> result_2 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.intrnl.SISSubscription>(); 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 = " ss.\"device_id\",ss.\"user_name\",ss.\"h\",ss.\"i\",ss.\"admin_lock\",ss.\"l\",ss.\"m\",ss.\"n\",ss.\"domain\",ss.\"pkg\",ss.\"sync_group\",ss.\"cid\" FROM \"sup_sis_subscription\" ss"; _selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL; System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL); 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.intrnl.SISSubscription entity_6 = new YPF.Comercial.RRCC.SUP.intrnl.SISSubscription(); 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); }
/// <summary> /// Find a mobile business object YPF.Comercial.RRCC.SUP.CustomLocalData /// </summary> /// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception> /// <remarks> </remarks> public static YPF.Comercial.RRCC.SUP.CustomLocalData FindByPrimaryKey(string idCustomLocalData) { YPF.Comercial.RRCC.SUP.CustomLocalData 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.\"b\",x.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"a\" FROM \"co_crmmobiledesa_1_0_customlocaldata\" x WHERE 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, "idCustomLocalData", idCustomLocalData); 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.CustomLocalData entity_6 = new YPF.Comercial.RRCC.SUP.CustomLocalData(); 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); }
private static YPF.Comercial.RRCC.SUP.intrnl.SISSubscription _find(YPF.Comercial.RRCC.SUP.intrnl.SISSubscriptionKey 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.intrnl.SISSubscription _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "domain", id.Domain); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "package", id.Package); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "syncGroup", id.SyncGroup); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "clientId", id.ClientId); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.intrnl.SISSubscription(); _rt.Bind(profile, _rs); count++; } 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(); } }
private static YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal _find(YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocalKey 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.CalendarioInteraccionLocal _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "diaInteraccion", id.DiaInteraccion); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "mesInteraccion", id.MesInteraccion); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "anioInteraccion", id.AnioInteraccion); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idTipoInteraccion", id.IdTipoInteraccion); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal(); _rt.Bind(profile, _rs); count++; } 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> /// Delete the mobile business object. /// </summary> public void Delete() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { int count = 1; System.Data.IDbCommand ps1 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, "delete co_crmmobiledesa_1_0_clientpersonalization where \"id\"=?"); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps1, "id", this.Id); count = ps1.ExecuteNonQuery(); ps1.Dispose();; _isNew = false; _isDeleted = true; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
private static YPF.Comercial.RRCC.SUP.ChangeLogImpl _find(YPF.Comercial.RRCC.SUP.ChangeLogKey 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.ChangeLogImpl _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "entityType", id.EntityType); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", id.SurrogateKey); _rs = ps.ExecuteReader(); Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile(); while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs)) { _rt = new YPF.Comercial.RRCC.SUP.ChangeLogImpl(); _rt.Bind(profile, _rs); count++; } 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> /// Sybase internal use only. /// <summary> public void NextBatch() { //lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) //{ Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); Sybase.Persistence.LocalTransaction _tran_1 = _conn.BeginTransaction(); YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK _pk_2 = new YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK(); _pk_2.RemoteId = ("*"); _pk_2.BatchId = (1); YPF.Comercial.RRCC.SUP.LocalKeyGenerator _batch_3 = YPF.Comercial.RRCC.SUP.LocalKeyGenerator.Find(_pk_2); if (_batch_3 == null) { _batch_3 = new YPF.Comercial.RRCC.SUP.LocalKeyGenerator(); _batch_3.RemoteId = (_pk_2.RemoteId); _batch_3.BatchId = (_pk_2.BatchId); _batch_3.FirstId = (1); _batch_3.NextId = (1 + 100000); // _batch_3.LastId =(9223372036854775807); _batch_3.LastId = (2147483647); _batch_3.Save(); this.RemoteId = ("*"); this.BatchId = (1); this.FirstId = (1); this.NextId = (1); this.LastId = (100000); } else { long _next_4 = _batch_3.NextId; long _next_5 = _next_4 + 100000; _batch_3.NextId = (_next_5); _batch_3.Save(); this.FirstId = (_next_4); this.NextId = (_next_4); this.LastId = (_next_5 - 1); } _tran_1.Commit(); //} }
/// <summary> /// Sybase internal use only. /// <summary> public void RbsReplayInternal(YPF.Comercial.RRCC.SUP.RelevamientoProducto entity) { YPF.Comercial.RRCC.SUP.intrnl.OperationReplay _replay = new YPF.Comercial.RRCC.SUP.intrnl.OperationReplay(); _replay.RemoteId = ("."); _replay.Component = ("CRMMobileDesa.RelevamientoProducto_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.RelevamientoProducto.__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; } //} }
private static YPF.Comercial.RRCC.SUP.RepresentanteComercialSynchronizationParameters _find(string 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.RepresentanteComercialSynchronizationParameters _rt = null; System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "user_sp", 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.RepresentanteComercialSynchronizationParameters(); _rt.Bind(profile, _rs); count++; } 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> /// create an MBO instance /// </summary> public void Create() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { CreateBySQL(_conn, "insert sup_sis_subscription (\"device_id\",\"user_name\",\"h\",\"i\",\"admin_lock\",\"l\",\"m\",\"n\",\"domain\",\"pkg\",\"sync_group\",\"cid\") values (?,?,?,?,?,?,?,?,?,?,?,?)", this); _isNew = false; _isDeleted = false; _isDirty = false; } catch (Sybase.Persistence.PersistenceException pe) { throw pe; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// Delete the mobile business object. /// </summary> public void Delete() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { int count = 1; System.Data.IDbCommand ps1 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, "delete crmmobiledesa_1_0_changelogimpl where \"a\"=? and \"b\"=?"); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps1, "entityType", this.EntityType); com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps1, "surrogateKey", this.SurrogateKey); count = ps1.ExecuteNonQuery(); ps1.Dispose();; _isNew = false; _isDeleted = true; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// create an MBO instance /// </summary> public void Create() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { CreateBySQL(_conn, "insert co_crmmobiledesa_1_0_localkeygenerator (\"first_id\",\"last_id\",\"next_id\",\"remote_id\",\"batch_id\") values (?,?,?,?,?)", this); _isNew = false; _isDeleted = false; _isDirty = false; } catch (Sybase.Persistence.PersistenceException pe) { throw pe; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// create an MBO instance /// </summary> public void Create() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { CreateBySQL(_conn, "insert crmmobiledesa_1_0_changelogimpl (\"c\",\"d\",\"e\",\"a\",\"b\") values (?,?,?,?,?)", this); _isNew = false; _isDeleted = false; _isDirty = false; } catch (Sybase.Persistence.PersistenceException pe) { throw pe; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
/// <summary> /// Update the mobile business object /// </summary> public void Update() { Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBWriteConnection(); try { int count = 1; System.Data.IDbCommand cmd = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, "update co_crmmobiledesa_1_0_offlineauthentication set \"b\"=? where \"a\"=?"); com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), cmd, "passwordHash", this.PasswordHash); com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), cmd, "user", this.User); count = cmd.ExecuteNonQuery(); cmd.Dispose();; _isNew = false; _isDirty = false; _isDeleted = false; } catch (System.Data.DataException ex) { throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex); } finally { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection(); } }
public void Finish_rbsReplayInternal(Sybase.Persistence.IOperationReplay _call_tmp) { YPF.Comercial.RRCC.SUP.intrnl.OperationReplay _call = (YPF.Comercial.RRCC.SUP.intrnl.OperationReplay)_call_tmp; com.sybase.afx.json.JsonObject parameters = (com.sybase.afx.json.JsonObject)(com.sybase.afx.json.JsonReader .Parse(_call.Parameters)); string exception = _call.Exception; YPF.Comercial.RRCC.SUP.RelevamientoProducto entity = (YPF.Comercial.RRCC.SUP.RelevamientoProducto)(YPF.Comercial.RRCC.SUP.RelevamientoProducto.__fromJSON(parameters.Get("entity"))); //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(); long ____id = entity.ReplayCounter; YPF.Comercial.RRCC.SUP.RelevamientoProducto _client = YPF.Comercial.RRCC.SUP.RelevamientoProducto.Find(entity._pk()); YPF.Comercial.RRCC.SUP.RelevamientoProducto _downloadState = null; if (_client != null) { _downloadState = _client.DownloadState; } if (exception == null) { YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnReplaySuccess(_client == null ? entity : _client); YPF.Comercial.RRCC.SUP.RelevamientoProducto.GetCallbackHandler().OnReplaySuccess(_client == null ? entity : _client); if ((_client != null) && _client.IsPending) { long _rc = _client.ReplayPending; if (_rc == ____id) { if (_rc == _client.ReplayCounter) { _client._cancelPending2(false); } else { _client.ReplayPending = 0; _client.ReplayFailure = 0; _client.__update(true); } } } } else { _client.ReplayFailure = (_client.ReplayPending); _client._cascadeUpdateReplayCounterPending(false); if (_client != null && _client.ReplayPending == ____id) { _client.ReplayPending = (0); _client.ReplayCounter = (YPF.Comercial.RRCC.SUP.KeyGenerator.GenerateId()); _client.ReplayFailure = (____id); _client.__update(true); if (_downloadState != null) { _downloadState._update_os(); } } YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnReplayFailure(_client); YPF.Comercial.RRCC.SUP.RelevamientoProducto.GetCallbackHandler().OnReplayFailure(_client); } _call.Delete(); tran.Commit(); } catch (Sybase.Persistence.PersistenceException pe) { tran.Rollback(); throw pe; } catch (System.ApplicationException e) { tran.Rollback(); throw e; } //} }
/// <summary> /// Closes all the free connections and clears the connection pool. /// </summary> public static void CloseDBConnection() { lock(typeof(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB)) { if (_synchronizeConn!= null) { _synchronizeConn.Close(); _synchronizeConn = null; } if(_lockManager != null) { _lockManager.ClearPayload(); _lockManager = null; } } }