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);
}
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);
}
internal static Sybase.Collections.GenericList <RelevamientoPreciosProducto_rs> FromJSONList(object __array)
{
com.sybase.afx.json.JsonArray _array = (com.sybase.afx.json.JsonArray)__array;
Sybase.Collections.GenericList <RelevamientoPreciosProducto_rs> _list;
if (_array == null)
{
_list = null;
}
else
{
int _size = _array.Count;
_list = new Sybase.Collections.GenericList <RelevamientoPreciosProducto_rs>(_size);
foreach (object __o in _array)
{
_list.Add((YPF.Comercial.RRCC.SUP.intrnl.RelevamientoPreciosProducto_rs)(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoPreciosProducto_rs.FromJSON((com.sybase.afx.json.JsonObject)(__o))));
}
}
return(_list);
}
public static Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.SessionPersonalization> FindAll()
{
//
if ((ListSessionPK == null))
{
ListSessionPK = new Sybase.Collections.GenericList <YPF.Comercial.RRCC.SUP.SessionPersonalization>();
}
bool p1 = false;
bool p2 = false;
foreach (YPF.Comercial.RRCC.SUP.SessionPersonalization __p in ListSessionPK)
{
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "username"))
{
p1 = true;
}
if (com.sybase.afx.util.StringUtil.Equal(__p.Key_name, "password"))
{
p2 = true;
}
}
if (!p1)
{
YPF.Comercial.RRCC.SUP.SessionPersonalization __p = new YPF.Comercial.RRCC.SUP.SessionPersonalization();
__p.Key_name = "username";
__p.Value = null;
__p.User_defined = false;
ListSessionPK.Add(__p);
}
if (!p2)
{
YPF.Comercial.RRCC.SUP.SessionPersonalization __p = new YPF.Comercial.RRCC.SUP.SessionPersonalization();
__p.Key_name = "password";
__p.Value = null;
__p.User_defined = false;
ListSessionPK.Add(__p);
}
return(ListSessionPK);
}
/// <summary>
/// Find a List of RespuestaInteraccionFormulario
/// </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.RespuestaInteraccionFormulario> 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);
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> list_3 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario>();
Sybase.Persistence.AbstractEntity.FindWithQuery(_conn, query, list_3, typeof(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario));
return list_3;
}
catch (Sybase.Persistence.PersistenceException ex_10)
{
throw ex_10;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
internal static com.sybase.afx.json.JsonArray ToJSONListWithoutBigAttribute(Sybase.Collections.GenericList <RelevamientoProducto_rs> _list)
{
return(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProducto_rs.ToJSONList(_list, false, false));
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <FormularioPrecios_rs> __array)
{
return(YPF.Comercial.RRCC.SUP.intrnl.FormularioPrecios_rs.ToJSONList(__array));
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <SISSubscription> _list)
{
return(YPF.Comercial.RRCC.SUP.intrnl.SISSubscription.ToJSONList(_list, false));
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.TablaRelevamiento
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento> FindAll(int skip, int take)
{
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_tablarelevamiento\" x where (((x.\"pending\" = 1 or not exists (select x_os.\"c\" from \"crmmobiledesa_1_0_tablarelevamiento_os\" x_os where x_os.\"c\" = x.\"c\"))))";
skip = skip + 1;
_selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.TablaRelevamiento>();
Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take,
_outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.TablaRelevamiento));
return _outList;
}
catch (Sybase.Persistence.PersistenceException pe)
{
throw pe;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <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> GetReplayPendingObjects(int skip, int take)
{
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.\"_rp\" != 0)";
skip = skip + 1;
_selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ClienteDetallePedido>();
Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take,
_outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.ClienteDetallePedido));
return _outList;
}
catch (Sybase.Persistence.PersistenceException pe)
{
throw pe;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <summary>
/// Set the value of seleccionTablasRelevamiento
/// </summary>
private void SetSeleccionTablasRelevamiento(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento> x)
{
__seleccionTablasRelevamiento = x;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
private Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> GetPreguntasFormulario(bool ignoreNonPending,bool ignoreDisableSubmit)
{
if (__preguntasFormulario == null)
{
__preguntasFormulario = YPF.Comercial.RRCC.SUP.PreguntaFormulario.GetPreguntasFormulario_for_Formulario(__surrogateKey);
}
return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>)FilterChildren(__preguntasFormulario, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>());
}
/// <summary>
/// Set the value of preguntasFormulario
/// </summary>
private void SetPreguntasFormulario(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> x)
{
__preguntasFormulario = x;
}
/// <summary>
/// Clear the reference of relationships in memory.
/// </summary>
public void ClearRelationshipObjects()
{
__preguntasFormulario = null;
__seleccionTablasRelevamiento = null;
__seleccionFormularios = null;
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA.ToJSONList(_list, __buildGraph, true));
}
public new void OnSynchronizeSuccess(Sybase.Collections.GenericList <ISynchronizationGroup> groups)
{
base.OnSynchronizeSuccess(groups);
}
/// <summary>
/// Sybase internal use only.
/// <summary>
private Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento> GetSeleccionTablasRelevamiento(bool ignoreNonPending,bool ignoreDisableSubmit)
{
if (__seleccionTablasRelevamiento == null)
{
__seleccionTablasRelevamiento = YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento.GetSeleccionTablasRelevamiento_for_Formulario(__surrogateKey);
}
return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento>)FilterChildren(__seleccionTablasRelevamiento, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionTablaRelevamiento>());
}
/// <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>
/// Set the value of seleccionFormularios
/// </summary>
internal void SetSeleccionFormularios(Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario> x)
{
__seleccionFormularios = x;
}
/// <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>
/// Sybase internal use only.
/// <summary>
internal Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario> GetSeleccionFormularios(bool ignoreNonPending,bool ignoreDisableSubmit)
{
if (__seleccionFormularios == null)
{
__seleccionFormularios = YPF.Comercial.RRCC.SUP.SeleccionFormulario.GetSeleccionFormularios_for_Formulario(__surrogateKey);
}
return (Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario>)FilterChildren(__seleccionFormularios, ignoreNonPending, ignoreDisableSubmit, new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.SeleccionFormulario>());
}
internal static com.sybase.afx.json.JsonArray ToJSONListWithoutBigAttribute(Sybase.Collections.GenericList <PackageProperties_rs> _list)
{
return(YPF.Comercial.RRCC.SUP.intrnl.PackageProperties_rs.ToJSONList(_list, false, false));
}
/// <summary>
/// copy the MBO attributes to current MBO
/// </summary>
public void CopyAll(YPF.Comercial.RRCC.SUP.Formulario entity)
{
this._isNew = entity._isNew;
this.__idFormulario = entity.__idFormulario;
this.__descripcion = entity.__descripcion;
this.__calculaPuntuacion = entity.__calculaPuntuacion;
this.__codigoSAP = entity.__codigoSAP;
this.__preguntasFormulario = entity.__preguntasFormulario;
this.__seleccionTablasRelevamiento = entity.__seleccionTablasRelevamiento;
this.__seleccionFormularios = entity.__seleccionFormularios;
this.__pending = entity.__pending;
this.__pendingChange = entity.__pendingChange;
this.__replayPending = entity.__replayPending;
this.__replayFailure = entity.__replayFailure;
this.__surrogateKey = entity.SurrogateKey;
this.__replayCounter = entity.__replayCounter;
this.__disableSubmit = entity.__disableSubmit;
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <FormularioPrecios_rs> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.intrnl.FormularioPrecios_rs.ToJSONList(_list, __buildGraph, true));
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <LocalKeyGeneratorPK> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.LocalKeyGeneratorPK.ToJSONList(_list, __buildGraph, true));
}
/// <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 com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_DATOS_PROVEEDOR> _list)
{
return(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_DATOS_PROVEEDOR.ToJSONList(_list, false));
}
/// <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> GetReplayPendingObjects(int skip, int take)
{
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.\"pending\" = 1 or not exists (select x_os.\"g\" from \"crmmobiledesa_1_0_respuestainteraccio"
+ "nformulario_os\" x_os where x_os.\"g\" = x.\"g\")))) and ( x.\"_rp\" != 0)";
skip = skip + 1;
_selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario>();
Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take,
_outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario));
return _outList;
}
catch (Sybase.Persistence.PersistenceException pe)
{
throw pe;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <LogRecordImpl_rs> __array)
{
return(YPF.Comercial.RRCC.SUP.intrnl.LogRecordImpl_rs.ToJSONList(__array));
}
internal static com.sybase.afx.json.JsonArray ToJSONListWithoutBigAttribute(Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA> _list)
{
return(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA.ToJSONList(_list, false, false));
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <PersonalizationParameters> _list)
{
return(YPF.Comercial.RRCC.SUP.PersonalizationParameters.ToJSONList(_list, false));
}
public new void OnSynchronizeFailure(Sybase.Collections.GenericList <ISynchronizationGroup> groups)
{
base.OnSynchronizeFailure(groups);
}
/// <summary>
/// Returns the log record list.
/// </summary>
public static Sybase.Collections.GenericList<Sybase.Persistence.ILogRecord> FindByEntity(string entityName, string keyValue)
{
Sybase.Persistence.Query _query = Sybase.Persistence.AbstractEntity.GetLogRecordQuery(entityName, keyValue);
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.LogRecordImpl> _logList = YPF.Comercial.RRCC.SUP.LogRecordImpl.FindWithQuery(_query);
Sybase.Collections.GenericList<Sybase.Persistence.ILogRecord> _logs = new Sybase.Collections.GenericList<Sybase.Persistence.ILogRecord>();
for (int i = 0; i < _logList.Size(); i++)
{
_logs.AddThis((Sybase.Persistence.ILogRecord)_logList[i]);
}
return _logs;
}
/// <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>
/// 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;
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <Negocio_rs> _list)
{
return(YPF.Comercial.RRCC.SUP.intrnl.Negocio_rs.ToJSONList(_list, false));
}
/// <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.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> GetPendingObjects(int skip, int take)
{
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.\"_pc\" <> \'N\'";
skip = skip + 1;
_selectSQL = "select top " + take + " start at " + skip + " " + _selectSQL;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario> _outList = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.PreguntaFormulario>();
Sybase.Persistence.AbstractEntity.FindWithoutParameters(_conn, skip, take,
_outList, _selectSQL, typeof(YPF.Comercial.RRCC.SUP.PreguntaFormulario));
return _outList;
}
catch (Sybase.Persistence.PersistenceException pe)
{
throw pe;
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}
/// <summary>
/// Begin synchronize of the specified synchronization groups at a background thread.
/// </summary>
/// <param name="sgs">The list of synchronization groups.</param>
/// <param name="context">The user provided context.</param>
/// <param name="uploadOnly">If true, the synchronization is to send data from client to server only for non-DOE. This parameter is ignored for DOE applications.</param>
/// <remarks> </remarks>
public static void BeginSynchronize(Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> sgs,object context, bool uploadOnly)
{
if(!GetSynchronizationProfile().AsyncReplay && uploadOnly)
{
throw new Sybase.Persistence.SynchronizeException("uploadOnly can only be true if it is async replay");
}
// Create a synchronization request
Sybase.Persistence.SynchronizationRequest req = new Sybase.Persistence.SynchronizationRequest();
// make a clone to avoid caller tempering with the list.
if (sgs == null) sgs = GetAllSynchronizationGroups();
Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup> groups = new Sybase.Collections.GenericList<Sybase.Persistence.ISynchronizationGroup>();
groups.AddRange(sgs);
req.SyncReqGroups = groups;
req.Context = context;
if (uploadOnly)
{
req.SyncReqMode = Sybase.Persistence.SynchronizationRequest.UPLOADONLYSYNC;
}
else
{
req.SyncReqMode = Sybase.Persistence.SynchronizationRequest.FULLSYNC;
}
req.SyncReqStatus = Sybase.Persistence.SynchronizationRequest.QUEUED;
_SRQ.Enqueue(req);
}
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;
}
/// <summary>
/// Gets the list of background synchronization requests.
/// </summary>
/// <returns>The list of background synchronization requests.</returns>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<Sybase.Persistence.SynchronizationRequest> GetBackgroundSyncRequests()
{
Sybase.Collections.GenericList<Sybase.Persistence.SynchronizationRequest> requests =
new Sybase.Collections.GenericList<Sybase.Persistence.SynchronizationRequest>();
_IMQ.CopyRequestsTo(requests);
_SRQ.CopyRequestsTo(requests);
return requests;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <SISSubscription> __array)
{
return(YPF.Comercial.RRCC.SUP.intrnl.SISSubscription.ToJSONList(__array));
}
/// <summary>
/// Gets the change logs based on the query filtering.
/// </summary>
/// <param name="query">Query object.</param>
/// <returns>Change logs.</returns>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<Sybase.Persistence.IChangeLog> GetChangeLogs(Sybase.Persistence.Query query)
{
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.ChangeLogImpl> _list = YPF.Comercial.RRCC.SUP.ChangeLogImpl.FindWithQuery(query);
Sybase.Collections.GenericList<Sybase.Persistence.IChangeLog> _logs = new Sybase.Collections.GenericList<Sybase.Persistence.IChangeLog>();
for (int i = 0; i < _list.Size(); i++)
{
_logs.AddThis((Sybase.Persistence.IChangeLog)(_list[i]));
}
return _logs;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <PackageProperties_rs> __array)
{
return(YPF.Comercial.RRCC.SUP.intrnl.PackageProperties_rs.ToJSONList(__array));
}
//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;
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <PackageProperties_rs> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.intrnl.PackageProperties_rs.ToJSONList(_list, __buildGraph, true));
}
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);
}
internal static com.sybase.afx.json.JsonArray ToJSONListWithoutBigAttribute(Sybase.Collections.GenericList <FormularioPrecios_rs> _list)
{
return(YPF.Comercial.RRCC.SUP.intrnl.FormularioPrecios_rs.ToJSONList(_list, false, false));
}
internal static com.sybase.afx.json.JsonArray ToJSONListWithoutBigAttribute(Sybase.Collections.GenericList <ClientPersonalization> _list)
{
return(YPF.Comercial.RRCC.SUP.ClientPersonalization.ToJSONList(_list, false, false));
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <RelevamientoProducto_rs> __array)
{
return(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProducto_rs.ToJSONList(__array));
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <ClientPersonalization> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.ClientPersonalization.ToJSONList(_list, __buildGraph, true));
}
internal static com.sybase.afx.json.JsonArray ToJSONList(Sybase.Collections.GenericList <RelevamientoProducto_rs> _list, bool __buildGraph)
{
return(YPF.Comercial.RRCC.SUP.intrnl.RelevamientoProducto_rs.ToJSONList(_list, __buildGraph, true));
}
/// <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<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;
}
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);
}
/// <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;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <ClientPersonalization> __array)
{
return(YPF.Comercial.RRCC.SUP.ClientPersonalization.ToJSONList(__array));
}
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;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public static com.sybase.afx.json.JsonArray __toJSONList(Sybase.Collections.GenericList <ZCRM_ACTRRCC_ABM_CABECERA> __array)
{
return(YPF.Comercial.RRCC.SUP.ZCRM_ACTRRCC_ABM_CABECERA.ToJSONList(__array));
}
