/// <summary>Solves the filters defined in this class</summary>
/// <param name="linkedTo">This parameter has the related instance to retrieve the requested instances</param>
/// <param name="filters">This parameter has all the filters defined with this class</param>
/// <param name="orderCriteria">This parameter has the name of the order criteria to add to SQL statement</param>
/// <param name="startRowOID">This parameter has the OID necessary to start the search</param>
/// <param name="blockSize">This parameter represents the number of instances to be returned</param>
public override ONCollection QueryByFilter(ONLinkedToList linkedTo, ONFilterList filters, ONDisplaySet displaySet, string orderCriteria, ONOid startRowOID, int blockSize)
{
// OrderCriteria
ONOrderCriteria lComparer = GetOrderCriteria(orderCriteria);
// Horizontal visibility
if (filters == null)
filters = new ONFilterList();
filters.Add("HorizontalVisibility", new RevisionPasajeroHorizontalVisibility());
// Linked To List
if (linkedTo == null)
linkedTo = new ONLinkedToList();
// Call Data
try
{
RevisionPasajeroData lData = new RevisionPasajeroData(OnContext);
ONCollection lCollection = lData.ExecuteQuery(linkedTo, filters, displaySet, lComparer, startRowOID, blockSize);
// OrderCriteria
if (lComparer != null)
lCollection.Sort(lComparer);
return lCollection;
}
catch (Exception e)
{
if (e is ONException)
{
throw e;
}
else
{
string ltraceItem = "Error in query, Method: ExecuteQuery, Component: RevisionPasajeroQuery";
if (e is ONSystemException)
{
ONSystemException lException = e as ONSystemException;
lException.addTraceInformation(ltraceItem);
throw lException;
}
throw new ONSystemException(e, ltraceItem);
}
}
}
public RevisionPasajeroCollection RevisionPasajeroRoleHV()
{
RevisionPasajeroData ldata = new RevisionPasajeroData(OnContext);
//Fix related instance
ONLinkedToList lLinkedTo = new ONLinkedToList();
lLinkedTo["Revision"] = Oid;
ONFilterList lFilterList = new ONFilterList();
lFilterList.Add("HorizontalVisibility", new RevisionPasajeroHorizontalVisibility());
//Execute
return ldata.ExecuteQuery(lLinkedTo, lFilterList, null, null, null, 1) as RevisionPasajeroCollection;
}