/// <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> GetPendingObjects(char pendingChange, 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.\"_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.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;
}
/// <summary>
/// Find a mobile business object YPF.Comercial.RRCC.SUP.Interaccion
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static YPF.Comercial.RRCC.SUP.Interaccion FindByPrimaryKey(string idInteraccion)
{
YPF.Comercial.RRCC.SUP.Interaccion result_2 = null;
System.Data.IDataReader rs_4 = null;
int count_5 = 0;
Sybase.Persistence.ConnectionWrapper _conn = null;
try
{
_conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
string _selectSQL = "SELECT x.\"a\",x.\"b\",x.\"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.\"a\" = ?)";
System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps_3, "idInteraccion", idInteraccion);
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 = 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.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;
}
private static YPF.Comercial.RRCC.SUP.Interaccion _find(long id, String sql, bool findOs, bool findNonPending)
{
Sybase.Persistence.ConnectionWrapper _conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
System.Data.IDataReader _rs = null;
int count = 0;
try
{
YPF.Comercial.RRCC.SUP.Interaccion _rt = null;
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", id);
_rs = ps.ExecuteReader();
Sybase.Persistence.ConnectionProfile profile = _conn.GetConnectionProfile();
while (com.sybase.afx.db.ReaderUtil.Read(profile, _rs))
{
_rt = new YPF.Comercial.RRCC.SUP.Interaccion();
_rt.Bind(profile, _rs);
count++;
if(findOs)
{
_rt.__isOsEntity = true;
_rt.__pending = false;
}
if( !findNonPending )
{
if(_rt.IsPending)
{
break;
}
}
else
{
if( !_rt.IsPending )
{
break;
}
else
{
_rt = null;
}
}
}
if (_rs != null) com.sybase.afx.db.ReaderUtil.Close(profile, _rs, count);
if (ps != null) ps.Dispose();
return _rt;
}
catch(System.Data.DataException ex)
{
throw new Sybase.Persistence.PersistenceException(ex.ToString(), ex);
}
finally
{
YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.ReleaseDBConnection();
}
}