The first way I tried is:
Code: Select all
var os = ss.GetService<IOrderStore>();
var orders = os.Orders.Where(x => x.EscrowStatus == SoftPro.OrderTracking.Client.Orders.EscrowStatus.InProcess)
foreach (var order in orders)
{
var fullOrder = os.OpenOrder(order, OrderEditMode.ReadOnly);
.. etc
The second way that I tried is:
Code: Select all
var qm = ss.GetService<IQueryManager>();
var source = qm.Sources.Where(x => x.Name == "Orders").First();
var q = qm.NewQuery(source);
IQueryExpression expression = q.Factory.MakeBinary(
QueryExpressionType.Equal,
q.Factory.FieldRef(OrderSearchFields.EscrowStatus),
q.Factory.Value(SoftPro.OrderTracking.Client.Orders.EscrowStatus.InProcess)
);
q.Expression = expression;
var orders = qm.Execute(q);
My question is.. how should I be performing this search?