public override void Synchronize (Sybase.Persistence.ServerSyncData ssd)
{
object _userContext = new Sybase.Persistence.SynchronizationNotification();
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> _sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
_sgs.Add(CRMMobileDesaDB.GetSynchronizationGroup(ssd.Publication));
CRMMobileDesaDB.BeginSynchronize(_sgs, _userContext);
}
public void OnMessage(com.sybase.afx.json.JsonMessage msg)
{
string _notification = msg.GetHeaders().GetNullableString("SUPObjCmd");
bool _reregistered = (_notification != null && _notification.Equals("reregister"));
if(_reregistered)
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSubscriptionEnd();
return;
}
string method = msg.GetHeaders().GetString("method");
bool _isAsync = "asyncReplayCompleted".Equals(method);
string serverRemoteId = msg.GetHeaders().GetNullableString("remoteId");
string clientRemoteId = GetRemoteId();
if(serverRemoteId != null && clientRemoteId != null && !serverRemoteId.Equals(clientRemoteId))
{
return;
}
bool _isTcn = "tcn".Equals(method);
if(!_isAsync && !_isTcn)
{
return;
}
com.sybase.afx.json.JsonObject _content = (com.sybase.afx.json.JsonObject)(msg.GetContent());
string userContext = _content.GetString("userContext");
string synchronizationGroup = _content.GetString("synchronizationGroup");
Sybase.Persistence.SynchronizationContext syncContext = new Sybase.Persistence.SynchronizationContext();
syncContext.UserContext = userContext;
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
foreach(string sg in com.sybase.afx.util.StringUtil.GetCommaSeparatedList(synchronizationGroup))
{
sgs.Add(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetSynchronizationGroup(sg));
}
if(_isTcn)
{
syncContext.Status = Sybase.Persistence.SynchronizationStatus.STARTING_ON_NOTIFICATION;
}
else
{
syncContext.Status = Sybase.Persistence.SynchronizationStatus.ASYNC_REPLAY_COMPLETED;
}
if(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext) == Sybase.Persistence.SynchronizationAction.CANCEL)
{
return;
}
try
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.BeginSynchronize(sgs, userContext);
}
catch(Sybase.Persistence.SynchronizeException ex)
{
syncContext.Exception = ex;
syncContext.Status = Sybase.Persistence.SynchronizationStatus.ERROR;
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);
throw ex;
}
syncContext.Status = Sybase.Persistence.SynchronizationStatus.FINISHING;
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);
}
public override void Synchronize(Sybase.Persistence.ServerSyncData ssd)
{
object _userContext = new Sybase.Persistence.SynchronizationNotification();
Sybase.Collections.GenericList <Sybase.Persistence.ISynchronizationGroup> _sgs = new Sybase.Collections.GenericList <Sybase.Persistence.ISynchronizationGroup>();
_sgs.Add(CRMMobileDesaDB.GetSynchronizationGroup(ssd.Publication));
CRMMobileDesaDB.BeginSynchronize(_sgs, _userContext);
}
/// <summary>
/// Find a List of ChangeLogImpl
/// </summary>
/// <param name="query">The query to be filter.</param>
/// <exception cref="PersistenceException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ChangeLogImpl> FindWithQuery(Sybase.Persistence.Query query)
{
Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
try
{
query.SetEntity(META_DATA);
query.SetDatabaseMetaData(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.Metadata);
int count_2 = 0;
Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ChangeLogImpl> list_3 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ChangeLogImpl>();
if (query.Take == 0)
{
return(list_3);
}
com.sybase.afx.db.DynamicQuery query_4 = new com.sybase.afx.db.DynamicQuery();
System.Data.IDbCommand ps_5 = query_4.CreateCommand(_conn, query);
System.Data.IDataReader rs_6 = ps_5.ExecuteReader();
Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_6))
{
YPF.Comercial.RRCC.SUP.ChangeLogImpl entity_9 = new YPF.Comercial.RRCC.SUP.ChangeLogImpl();
entity_9.Bind(profile, rs_6);
list_3.Add(entity_9);
count_2++;
}
if (rs_6 != null)
{
com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
}
if (ps_5 != null)
{
ps_5.Dispose();
}
return(list_3);
}
catch (Sybase.Persistence.PersistenceException ex_10)
{
throw ex_10;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> FindByIdTipoInteraccion(int idTipoInteraccion, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> result_2 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal>();
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.\"d\",x.\"e\",x.\"a\",x.\"b\",x.\"c\",x.\"f\" FROM \"co_crmmobiledesa_1_0_calendariointeraccionlocal\" x WHERE x.\"f\" = ?";
_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.SetInt(_conn.GetConnectionProfile(), ps_3, "idTipoInteraccion", idTipoInteraccion);
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.CalendarioInteraccionLocal entity_6 = new YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal();
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.ClientPersonalization
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ClientPersonalization> FindByUser(string user, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ClientPersonalization> result_2 = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ClientPersonalization>();
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 = " p.\"key_name\",p.\"user\",p.\"value\",p.\"user_defined\",p.\"description\",p.\"id\" from \"co_crmmobiledesa_1_0_clientpersonalization\" p where p.\"user\" = ?";
_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.SetString(_conn.GetConnectionProfile(), ps_3, "user", user);
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.ClientPersonalization entity_6 = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
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);
}
internal static Sybase.Collections.GenericList <Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIAL> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIAL> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIAL>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIAL)(YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIAL.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList <RelevamientoProducto_rs> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <RelevamientoProducto_rs> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <RelevamientoProducto_rs>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProducto_rs)(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProducto_rs.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList <SISSubscriptionKey> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <SISSubscriptionKey> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <SISSubscriptionKey>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.intrnl.SISSubscriptionKey)(YPF.Comercial.RRCC.SUP.intrnl.SISSubscriptionKey.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList <ClientPersonalization> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <ClientPersonalization> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <ClientPersonalization>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ClientPersonalization)(YPF.Comercial.RRCC.SUP.ClientPersonalization.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
/// <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);
}
internal static Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA)(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
/// <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.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);
}
internal static Sybase.Collections.GenericList <ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR)(YPF.Comercial.RRCC.SUP.ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList <Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOS> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOS> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOS>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOS)(YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOS.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList <ZCRM_CONSULTA_CLI_INTERLOCUTORES> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <ZCRM_CONSULTA_CLI_INTERLOCUTORES> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <ZCRM_CONSULTA_CLI_INTERLOCUTORES>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZCRM_CONSULTA_CLI_INTERLOCUTORES)(YPF.Comercial.RRCC.SUP.ZCRM_CONSULTA_CLI_INTERLOCUTORES.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
internal static Sybase.Collections.GenericList<Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIAL> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIAL> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIAL>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIAL)(YPF.Comercial.RRCC.SUP.Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIAL.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.PreguntaFormulario
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> GetPreguntaFormularios_for_Pregunta(long? surrogateKey, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>();
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.\"c\",x.\"d\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"preguntaFK\",x.\"formulario1FK\",x.\"e\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_preguntaformulario\" x where (((x.\"pending\" = 1 or not exists (select x_os.\"e\" from \"crmmobiledesa_1_0_preguntaformulario_os\" x_os "
+ "where x_os.\"e\" = x.\"e\")))) and ( x.\"preguntaFK\"=?)";
_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.SetNullableLong(_conn.GetConnectionProfile(), ps_3, "surrogateKey", surrogateKey);
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.PreguntaFormulario entity_6 = new YPF.Comercial.RRCC.SUP.PreguntaFormulario();
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>
/// Returns all SynchronizationGroup instances.
/// </summary>
public static Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> GetAllSynchronizationGroups()
{
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> _sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
_sgs.Add(GetSynchronizationGroup("Deuda"));
_sgs.Add(GetSynchronizationGroup("Cliente"));
_sgs.Add(GetSynchronizationGroup("RepresentanteComercial"));
_sgs.Add(GetSynchronizationGroup("Interaccion"));
_sgs.Add(GetSynchronizationGroup("TablasMaestras"));
_sgs.Add(GetSynchronizationGroup("Parametro"));
_sgs.Add(GetSynchronizationGroup("CabeceraPedido"));
_sgs.Add(GetSynchronizationGroup("DetallePedido"));
_sgs.Add(GetSynchronizationGroup("Facturacion"));
return _sgs;
}
/// <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;
}
public void SaveParameter(com.sybase.afx.json.JsonObject parameters)
{
string sql = "select g from crmmobiledesa_1_0_operationreplay where b=?";
Sybase.Collections.GenericList<string> keyNames = new Sybase.Collections.GenericList<string>();
Sybase.Collections.GenericList<object> keyValues = new Sybase.Collections.GenericList<object>();
Sybase.Collections.GenericList<string> keyTypes = new Sybase.Collections.GenericList<string>();
keyNames.Add("requestId");
keyTypes.Add("long");
keyValues.Add(this.__requestId);
com.sybase.afx.db.ULBigStringImpl _parameters = new com.sybase.afx.db.ULBigStringImpl(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetLockManager(), null, sql, keyTypes, keyValues, keyNames,false);
com.sybase.afx.db.BigStringWriter writer = new com.sybase.afx.db.BigStringWriter(_parameters);
parameters.ToWriter(writer);
writer.Close();
}
internal static Sybase.Collections.GenericList<ZCRM_ACTRRCC_ABM_CABECERA> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<ZCRM_ACTRRCC_ABM_CABECERA> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<ZCRM_ACTRRCC_ABM_CABECERA>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA)(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
public void OnMessage(com.sybase.afx.json.JsonMessage msg)
{
string _notification = msg.GetHeaders().GetNullableString("SUPObjCmd");
bool _reregistered = (_notification != null && _notification.Equals("reregister"));
if (_reregistered)
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSubscriptionEnd();
return;
}
string method = msg.GetHeaders().GetString("method");
bool _isAsync = "asyncReplayCompleted".Equals(method);
string serverRemoteId = msg.GetHeaders().GetNullableString("remoteId");
string clientRemoteId = GetRemoteId();
if (serverRemoteId != null && clientRemoteId != null && !serverRemoteId.Equals(clientRemoteId))
{
return;
}
bool _isTcn = "tcn".Equals(method);
if (!_isAsync && !_isTcn)
{
return;
}
com.sybase.afx.json.JsonObject _content = (com.sybase.afx.json.JsonObject)(msg.GetContent());
string userContext = _content.GetString("userContext");
string synchronizationGroup = _content.GetString("synchronizationGroup");
Sybase.Persistence.SynchronizationContext syncContext = new Sybase.Persistence.SynchronizationContext();
syncContext.UserContext = userContext;
Sybase.Collections.GenericList <Sybase.Persistence.ISynchronizationGroup> sgs = new Sybase.Collections.GenericList <Sybase.Persistence.ISynchronizationGroup>();
foreach (string sg in com.sybase.afx.util.StringUtil.GetCommaSeparatedList(synchronizationGroup))
{
sgs.Add(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetSynchronizationGroup(sg));
}
if (_isTcn)
{
syncContext.Status = Sybase.Persistence.SynchronizationStatus.STARTING_ON_NOTIFICATION;
}
else
{
syncContext.Status = Sybase.Persistence.SynchronizationStatus.ASYNC_REPLAY_COMPLETED;
}
if (YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext) == Sybase.Persistence.SynchronizationAction.CANCEL)
{
return;
}
try
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.BeginSynchronize(sgs, userContext);
}
catch (Sybase.Persistence.SynchronizeException ex)
{
syncContext.Exception = ex;
syncContext.Status = Sybase.Persistence.SynchronizationStatus.ERROR;
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);
throw ex;
}
syncContext.Status = Sybase.Persistence.SynchronizationStatus.FINISHING;
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetCallbackHandler().OnSynchronize(sgs, syncContext);
}
private static void SynchronizeWithCallback (string synchronizationGroups,
object userContext,
Sybase.Persistence.SyncStatusListener listener,
com.sybase.afx.json.JsonObject syncContextEx)
{
Sybase.Persistence.SynchronizationContext syncContext = new Sybase.Persistence.SynchronizationContext();
syncContext.UserContext =(userContext);
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
foreach(string sg in com.sybase.afx.util.StringUtil.GetCommaSeparatedList(synchronizationGroups))
{
sgs.Add(GetSynchronizationGroup(sg));
}
syncContext.Status =(Sybase.Persistence.SynchronizationStatus.STARTING);
Sybase.Persistence.SynchronizationAction _action = onSynchronizeCallback(sgs, syncContext);
if(_action == Sybase.Persistence.SynchronizationAction.CANCEL)
{
return;
}
try
{
InternalSynchronize (synchronizationGroups, listener, syncContext, syncContextEx);
}
catch(Sybase.Persistence.SynchronizeException ex)
{
syncContext.Exception =(ex);
syncContext.Status =(Sybase.Persistence.SynchronizationStatus.ERROR);
onSynchronizeCallback(sgs, syncContext);
throw ex;
}
catch(Sybase.Persistence.PersistenceException ex)
{
syncContext.Exception =(ex);
syncContext.Status =(Sybase.Persistence.SynchronizationStatus.ERROR);
onSynchronizeCallback(sgs, syncContext);
throw ex;
}
if(GetSynchronizationProfile().AsyncReplay)
{
syncContext.Status =(Sybase.Persistence.SynchronizationStatus.ASYNC_REPLAY_UPLOADED);
}
else
{
syncContext.Status =(Sybase.Persistence.SynchronizationStatus.FINISHING);
}
onSynchronizeCallback(sgs, syncContext);
}
/// <summary>
/// Returns specified SynchronizationGroup instances.
/// </summary>
public static Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> GetSynchronizationGroups(Sybase.Collections.StringList synchronizationGroups)
{
if (synchronizationGroups == null)
{
return GetAllSynchronizationGroups();
}
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> _sgs = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
foreach(string sg in synchronizationGroups)
{
_sgs.Add(GetSynchronizationGroup(sg));
}
return _sgs;
}
public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ClientPersonalization> FindAll()
{
//
string who = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.GetSyncUsername();
Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.ClientPersonalization> list = FindByUser(who);
bool p1 = false;
bool p2 = false;
bool p3 = false;
bool p4 = false;
bool p5 = false;
bool p6 = false;
bool p7 = false;
bool p8 = false;
bool p9 = false;
bool p10 = false;
bool p11 = false;
foreach (YPF.Comercial.RRCC.SUP.ClientPersonalization __p in list)
{
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNRKey"))
{
p1 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "ZCRM_CONSULTA_CLI_INTERLOCUTORESKey"))
{
p2 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "ZCRM_ACTRRCC_CONSULTA_INTERLO_ACTIVIDADKey"))
{
p3 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "FECHA_SINCRONIZACIONKey"))
{
p4 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIALKey"))
{
p5 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOSKey"))
{
p6 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "REPRESENTANTE_COMERCIALKey"))
{
p7 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIALKey"))
{
p8 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "CUITsKey"))
{
p9 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "CUENTAS_SGCKey"))
{
p10 = true;
__p.Description = "\n \n ";
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "APIESsKey"))
{
p11 = true;
__p.Description = "\n \n ";
}
}
if (!p1)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNRKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p2)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "ZCRM_CONSULTA_CLI_INTERLOCUTORESKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p3)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "ZCRM_ACTRRCC_CONSULTA_INTERLO_ACTIVIDADKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p4)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "FECHA_SINCRONIZACIONKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p5)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "Z01CRM_RRCC_F_CABPEDIDOS_REPRESENTANTE_COMERCIALKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p6)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "Z01CRM_RRCC_F_DETPEDIDOS_PEDIDOSKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p7)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "REPRESENTANTE_COMERCIALKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p8)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "Z01CRM_RRCC_F_FACTURACION_REPRESENTANTE_COMERCIALKey";
__p.User = who;
__p.Value = null;
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p9)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "CUITsKey";
__p.User = who;
__p.Value = "";
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p10)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "CUENTAS_SGCKey";
__p.User = who;
__p.Value = "";
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
if (!p11)
{
YPF.Comercial.RRCC.SUP.ClientPersonalization __p = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
__p.Key_name = "APIESsKey";
__p.User = who;
__p.Value = "";
__p.User_defined = false;
__p.Description = "\n \n ";
list.Add(__p);
}
return(list);
}
//Returns list of available IP addresses on this device.
//One of the IPs can be set in ConnectionProfile object before synchronization.
//Ultralite will bind to the specified IP and use that network for synchronization.
////
//MyDatabase.GetSynchronizationProfile().SetString("client_ip", "1.23.456.789");
//MyDatabase.Synchronize();
//
public static Sybase.Collections.GenericList<string> GetAvailableIPAdresses()
{
Sybase.Collections.GenericList<string> _list = new Sybase.Collections.GenericList<string>();
string _strHostName = System.Net.Dns.GetHostName();
System.Net.IPHostEntry _ipEntry = System.Net.Dns.GetHostEntry(_strHostName);
System.Net.IPAddress[] _addr = _ipEntry.AddressList;
for (int i = 0; i < _addr.Length; i++)
{
_list.Add(_addr[i].ToString());
}
return _list;
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.Interaccion
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> FindVisitaRRCCByDate(System.DateTime fecha, string codigoInterlocutor, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.Interaccion>();
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.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"bb\",x.\"bc\",x.\"bd\",x.\"be\",x.\"bf\",x.\"bg\",x.\"bh\",x.\"bi\",x.\"bj\",x.\"bl\",x.\"bm\",x.\"bn\",x.\"bo\",x.\"bp\",x.\"bq\",x.\"br\","
+ "x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bs\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_interaccion\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"bs\" from \"crmmobiledesa_1_0_interaccion_os\" x_os where x_os.\"bs\" = x.\"bs\")))) and ( x.\"bd\" IS NOT NULL AND x.\"bd\" <> \'\' AND x.\"b\" = \'ZVRC\' AND x.\"d\" "
+ "= \'Z06\' AND DAY(x.\"v\") = DAY(?) AND MONTH(x.\"v\") = MONTH(?) And YEAR(x.\"v\") = YEAR(?) AND x.\"bf\" = ?)";
_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.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha);
com.sybase.afx.db.CommandUtil.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha);
com.sybase.afx.db.CommandUtil.SetDateTime(_conn.GetConnectionProfile(), ps_3, "fecha", fecha);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "codigoInterlocutor", codigoInterlocutor);
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.Interaccion entity_6 = new YPF.Comercial.RRCC.SUP.Interaccion();
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;
}
internal static Sybase.Collections.GenericList<ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR)(YPF.Comercial.RRCC.SUP.ZARFIAR_RFC_DEUDASCLIENTES_IM_KUNNR.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
/// <summary>
/// Find a List of CalendarioInteraccionLocal
/// </summary>
/// <param name="query">The query to be filter.</param>
/// <exception cref="PersistenceException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> FindWithQuery(Sybase.Persistence.Query query)
{
Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
try
{
query.SetEntity(META_DATA);
query.SetDatabaseMetaData(YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.Metadata);
int count_2 = 0;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> list_3 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal>();
if(query.Take == 0)
{
return list_3;
}
com.sybase.afx.db.DynamicQuery query_4 = new com.sybase.afx.db.DynamicQuery();
System.Data.IDbCommand ps_5 = query_4.CreateCommand(_conn, query);
System.Data.IDataReader rs_6 = ps_5.ExecuteReader();
Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
while (com.sybase.afx.db.ReaderUtil.Read(profile, rs_6))
{
YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal entity_9 = new YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal();
entity_9.Bind(profile, rs_6);
list_3.Add(entity_9);
count_2++;
}
if (rs_6 != null) com.sybase.afx.db.ReaderUtil.Close(profile, rs_6, count_2);
if (ps_5 != null) ps_5.Dispose();
return list_3;
}
catch (Sybase.Persistence.PersistenceException ex_10)
{
throw ex_10;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> FindByIdTipoInteraccion(int idTipoInteraccion, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal>();
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.\"d\",x.\"e\",x.\"a\",x.\"b\",x.\"c\",x.\"f\" FROM \"co_crmmobiledesa_1_0_calendariointeraccionlocal\" x WHERE x.\"f\" = ?";
_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.SetInt(_conn.GetConnectionProfile(), ps_3, "idTipoInteraccion", idTipoInteraccion);
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.CalendarioInteraccionLocal entity_6 = new YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal();
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.ClientPersonalization
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization> FindByUser(string user, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClientPersonalization>();
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 = " p.\"key_name\",p.\"user\",p.\"value\",p.\"user_defined\",p.\"description\",p.\"id\" from \"co_crmmobiledesa_1_0_clientpersonalization\" p where p.\"user\" = ?";
_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.SetString(_conn.GetConnectionProfile(), ps_3, "user", user);
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.ClientPersonalization entity_6 = new YPF.Comercial.RRCC.SUP.ClientPersonalization();
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.ClienteDetallePedido
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido> FindByCuenta(string cuenta, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido>();
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.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"h\",x.\"i\",x.\"j\",x.\"l\",x.\"m\",x.\"n\",x.\"o\",x.\"p\",x.\"q\",x.\"r\",x.\"s\",x.\"t\",x.\"u\",x.\"v\",x.\"w\",x.\"x\",x.\"y\",x.\"z\",x.\"ba\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"bb\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_clientedetallepedido\" x WHERE"
+ " (((x.\"pending\" = 1 or not exists (select x_os.\"bb\" from \"crmmobiledesa_1_0_clientedetallepedido_os\" x_os where x_os.\"bb\" = x.\"bb\")))) and ( x.\"b\" = ?)";
_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.SetString(_conn.GetConnectionProfile(), ps_3, "cuenta", cuenta);
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.ClienteDetallePedido entity_6 = new YPF.Comercial.RRCC.SUP.ClienteDetallePedido();
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.RespuestaInteraccionFormulario
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> GetPendingObjects(char pendingChange, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario>();
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.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"interaccionFK\",x.\"g\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_respuestainteraccionformulario\" 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.RespuestaInteraccionFormulario entity_6 = new YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario();
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;
}
internal static Sybase.Collections.GenericList<RelevamientoProveedor_rs> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<RelevamientoProveedor_rs> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<RelevamientoProveedor_rs>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProveedor_rs)(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProveedor_rs.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
internal static Sybase.Collections.GenericList<ZCRM_CONSULTA_CLI_INTERLOCUTORES> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<ZCRM_CONSULTA_CLI_INTERLOCUTORES> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<ZCRM_CONSULTA_CLI_INTERLOCUTORES>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ZCRM_CONSULTA_CLI_INTERLOCUTORES)(YPF.Comercial.RRCC.SUP.ZCRM_CONSULTA_CLI_INTERLOCUTORES.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.RelevamientoProveedor
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RelevamientoProveedor> FindByIdRelevamientoProveedor(string idRelevamientoProveedor, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RelevamientoProveedor> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RelevamientoProveedor>();
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.\"c\",x.\"d\",x.\"e\",x.\"f\",x.\"g\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"interaccionFK\",x.\"h\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_relevamientoproveedor\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"h\" from \"crmmobiledesa_1_0_relevamientoproveedor_"
+ "os\" x_os where x_os.\"h\" = x.\"h\")))) and ( x.\"c\" = ?)";
_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.SetString(_conn.GetConnectionProfile(), ps_3, "idRelevamientoProveedor", idRelevamientoProveedor);
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.RelevamientoProveedor entity_6 = new YPF.Comercial.RRCC.SUP.RelevamientoProveedor();
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.OperationReplay
/// </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.OperationReplay> FindReadyToFinish(int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.intrnl.OperationReplay> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.intrnl.OperationReplay>();
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 = " r.\"a\",r.\"c\",r.\"d\",r.\"e\",r.\"f\",r.\"g\",r.\"h\",r.\"i\",r.\"j\",r.\"b\" from \"crmmobiledesa_1_0_operationreplay\" r where r.\"j\" = 1 order by r.\"b\"";
_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.OperationReplay entity_6 = new YPF.Comercial.RRCC.SUP.intrnl.OperationReplay();
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;
}
internal static Sybase.Collections.GenericList<ClientPersonalization> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<ClientPersonalization> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<ClientPersonalization>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.ClientPersonalization)(YPF.Comercial.RRCC.SUP.ClientPersonalization.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
internal static Sybase.Collections.GenericList<SISSubscriptionKey> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<SISSubscriptionKey> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<SISSubscriptionKey>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.intrnl.SISSubscriptionKey)(YPF.Comercial.RRCC.SUP.intrnl.SISSubscriptionKey.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
internal static Sybase.Collections.GenericList<RespuestaInteraccionFormulario> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<RespuestaInteraccionFormulario> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<RespuestaInteraccionFormulario>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario)(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}
internal static Sybase.Collections.GenericList<RepresentanteComercialSynchronizationParameters> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList<RepresentanteComercialSynchronizationParameters> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList<RepresentanteComercialSynchronizationParameters>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.RepresentanteComercialSynchronizationParameters)(YPF.Comercial.RRCC.SUP.RepresentanteComercialSynchronizationParameters.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return _list;
}