private void LogInClick(object sender)
{
// if fields valid
if (FieldsValid())
{
CustomerFinder lookupWin = new CustomerFinder(ref Employees, ref User); // pass users
lookupWin.ShowDialog();
}
}
public void QueryAndTheResultHasNotDistinct()
{
using (ISession s = OpenSession())
{
CustomerFinder finder = new CustomerFinder();
finder.AccountMoney = MoneyType.Dollar;
IList <Customer> list = finder.Find(s);
Assert.AreEqual(4, list.Count);
}
}
// Executes the expression tree that is passed to it.
internal static object Execute(Expression expression, bool IsEnumerable, VismaNetAuthorization auth)
{
// The expression must represent a query over the data source.
if (!IsQueryOverDataSource(expression))
{
throw new InvalidProgramException("No query over the data source was specified.");
}
// Find the call to Where() and get the lambda expression predicate.
InnermostWhereFinder whereFinder = new InnermostWhereFinder();
MethodCallExpression whereExpression = whereFinder.GetInnermostWhere(expression);
var orderBy = GetOrderByExpression(expression);
var numberToRead = GetTakeExpression(expression);
LambdaExpression lambdaExpression;
IEnumerable <Customer> customers;
if (whereExpression != null && whereExpression.Arguments.Count > 1)
{
lambdaExpression = (LambdaExpression)((UnaryExpression)(whereExpression.Arguments[1])).Operand;
// Send the lambda expression through the partial evaluator.
lambdaExpression = (LambdaExpression)Evaluator.PartialEval(lambdaExpression);
// Get the place name(s) to query the Web service with.
var cf = new CustomerFinder(lambdaExpression.Body);
if (whereExpression.Method.Name.StartsWith("First"))
{
numberToRead = 1;
}
// Call the Web service and get the results.
customers = VismaNetApiHelper.FindCustomers(cf.UrlParams, auth, orderBy: orderBy, numberToRead: numberToRead);
}
else
{
customers = VismaNetApiHelper.FindCustomers(null, auth, orderBy: orderBy, numberToRead: numberToRead); // Return all customers
}
// Copy the IEnumerable places to an IQueryable.
IQueryable <Customer> queryableCustomers = customers.AsQueryable <Customer>();
// Copy the expression tree that was passed in, changing only the first
// argument of the innermost MethodCallExpression.
var treeCopier = new ExpressionTreeModifier <Customer>(queryableCustomers);
Expression newExpressionTree = treeCopier.Visit(expression);
// // This step creates an IQueryable that executes by replacing Queryable methods with Enumerable methods.
// if (IsEnumerable)
return(queryableCustomers.Provider.CreateQuery(newExpressionTree));
// else
// return queryableCustomers.Provider.Execute(newExpressionTree);
}
public void FirstName()
{
using (ISession s = OpenSession())
{
CustomerFinder finder = new CustomerFinder();
finder.FirstName = "Jo";
finder.AccountMoney = MoneyType.Euro;
IList <Customer> list = finder.Find(s);
Assert.AreEqual(2, list.Count);
}
}
public void QueryUsingAccountInfo()
{
using (ISession s = OpenSession())
{
CustomerFinder finder = new CustomerFinder();
finder.AccountActive = true;
finder.AccountSizeMin = 10000d;
log.Debug("--- Run the query with IsActive and Size are taken into account ---");
IList <Customer> list = finder.Find(s);
Assert.AreEqual(2, list.Count);
log.Debug("--- Run the query with IsActive, Size and Opened are taken into account ---");
finder.AccountOpenedStart = DateTime.Parse("1/1/1983");
finder.AccountOpenedEnd = DateTime.Parse("1/1/1984");
IList <Customer> list2 = finder.Find(s);
Assert.AreEqual(1, list2.Count);
}
}
