/// <summary>
/// Set current MBO attributes by specified MBO.
/// </summary>
public static YPF.Comercial.RRCC.SUP.CategoriaPregunta Merge(YPF.Comercial.RRCC.SUP.CategoriaPregunta entity)
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta ent = Find(entity._pk());
if (ent == null)
{
ent = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
}
ent.CopyAll(entity);
ent.Save();
return ent;
}
/// <summary>
/// Sybase internal use only.
/// <summary>
public void SetOriginalState(YPF.Comercial.RRCC.SUP.CategoriaPregunta orig)
{
__originalStateValid = true;
__originalState = orig;
}
private static YPF.Comercial.RRCC.SUP.CategoriaPregunta _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.CategoriaPregunta _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.CategoriaPregunta();
_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();
}
}
protected override void Bind(Sybase.Persistence.ConnectionProfile profile, System.Data.IDataReader rs)
{
this.__idCategoriaPregunta = com.sybase.afx.db.ReaderUtil.GetInt(profile,rs,"idCategoriaPregunta",0);
this.__descripcion = com.sybase.afx.db.ReaderUtil.GetString(profile,rs,"descripcion",1);
Preguntas =(null);
this.__pending = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"pending",2);
this.__pendingChange = com.sybase.afx.db.ReaderUtil.GetChar(profile,rs,"pendingChange",3);
this.__replayPending = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayPending",4);
this.__replayFailure = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayFailure",5);
this.__surrogateKey = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"surrogateKey",6);
this.__replayCounter = com.sybase.afx.db.ReaderUtil.GetLong(profile,rs,"replayCounter",7);
this.__disableSubmit = com.sybase.afx.db.ReaderUtil.GetBoolean(profile,rs,"disableSubmit",8);
_isNew = false;
_isDirty = false;
if (this.IsPending)
{
this.SetOriginalState(null);
this.__originalStateValid = false;
}
else
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta os_1 = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
os_1.CopyAll(this);
this.SetOriginalState(os_1);
}
}
/// <summary>
/// Refresh the mobile business object from database.
/// </summary>
public void Refresh()
{
if (!_isNew && !__isOsEntity)
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta ent = Load(_pk());
CopyAll(ent);
if (this.IsPending)
{
this.SetOriginalState(null);
this.__originalStateValid = false;
}
else
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta os_1 = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
os_1.CopyAll(this);
this.SetOriginalState(os_1);
}
_isNew = false;
_isDirty = false;
}
}
internal static YPF.Comercial.RRCC.SUP.CategoriaPregunta FromJSON(object _json)
{
if (_json == null)
{
return null;
}
else
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta _obj = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
_obj._fromJSON((com.sybase.afx.json.JsonObject)_json);
return _obj;
}
}
/// <summary>
/// Find a List of YPF.Comercial.RRCC.SUP.CategoriaPregunta
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CategoriaPregunta> GetPendingObjects(char pendingChange, int skip, int take)
{
skip = skip + 1;
Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CategoriaPregunta> result_2 = new Sybase.Collections.GenericList<YPF.Comercial.RRCC.SUP.CategoriaPregunta>();
System.Data.IDataReader rs_4 = null;
int count_5 = 0;
Sybase.Persistence.ConnectionWrapper _conn = null;
try
{
_conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
string _selectSQL = " x.\"a\",x.\"b\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"c\",x.\"_rc\",x.\"_ds\" from \"crmmobiledesa_1_0_categoriapregunta\" 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.CategoriaPregunta entity_6 = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
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.CategoriaPregunta
/// </summary>
/// <exception cref="PersistentException">Thrown if unable to retrieve mobile business object.</exception>
/// <remarks> </remarks>
public static YPF.Comercial.RRCC.SUP.CategoriaPregunta FindByPrimaryKey(int idCategoriaPregunta)
{
YPF.Comercial.RRCC.SUP.CategoriaPregunta result_2 = null;
System.Data.IDataReader rs_4 = null;
int count_5 = 0;
Sybase.Persistence.ConnectionWrapper _conn = null;
try
{
_conn = YPF.Comercial.RRCC.SUP.CRMMobileDesaDB.AcquireDBReadConnection();
string _selectSQL = "SELECT x.\"a\",x.\"b\",x.\"pending\",x.\"_pc\",x.\"_rp\",x.\"_rf\",x.\"c\",x.\"_rc\",x.\"_ds\" FROM \"crmmobiledesa_1_0_categoriapregunta\" x WHERE (((x.\"pending\" = 1 or not exists (select x_os.\"c\" from \"crmmobiledesa_1_0_categoriapregunta_os\" x_os where x_os.\"c\" = x.\"c\")))) and ( x.\"a\" = "
+ "?)";
System.Data.IDbCommand ps_3 = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, _selectSQL);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps_3, "idCategoriaPregunta", idCategoriaPregunta);
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.CategoriaPregunta entity_6 = new YPF.Comercial.RRCC.SUP.CategoriaPregunta();
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>
/// copy the MBO attributes to current MBO
/// </summary>
public void CopyAll(YPF.Comercial.RRCC.SUP.Pregunta entity)
{
this._isNew = entity._isNew;
this.__idPregunta = entity.__idPregunta;
this.__descripcion = entity.__descripcion;
this.__codigoSAP = entity.__codigoSAP;
this.__idCategoriaPregunta = entity.__idCategoriaPregunta;
this.__categoriaPregunta = entity.__categoriaPregunta;
this.__categoriaPreguntaValid = entity.__categoriaPreguntaValid;
this.__opcionRespuestas = entity.__opcionRespuestas;
this.__preguntaFormularios = entity.__preguntaFormularios;
this.__pending = entity.__pending;
this.__pendingChange = entity.__pendingChange;
this.__replayPending = entity.__replayPending;
this.__replayFailure = entity.__replayFailure;
this.__categoriaPreguntaFK = entity.__categoriaPreguntaFK;
this.__surrogateKey = entity.SurrogateKey;
this.__replayCounter = entity.__replayCounter;
this.__disableSubmit = entity.__disableSubmit;
}
