private void buttonQuery_Click(object sender, EventArgs e)
{
Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname"));
q.Where(q.LastName.Like("%" + txtLastName.Text + "%"));
q.OrderBy(q.LastName.Ascending);
coll = svc.Employees_QueryForCollection(Proxies.EmployeesQueryProxyStub.SerializeHelper.ToXml(q));
if (coll == null)
{
coll = new EmployeesCollectionProxyStub();
}
this.dataGrid.DataSource = coll.Collection;
}
private void buttonQuery_Click(object sender, EventArgs e)
{
Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname"));
q.Where(q.LastName.Like("%" + txtLastName.Text + "%"));
q.OrderBy(q.LastName.Ascending);
coll = svc.Employees_QueryForCollection(Proxies.EmployeesQueryProxyStub.SerializeHelper.ToXml(q));
if (coll == null)
{
coll = new EmployeesCollectionProxyStub();
}
this.dataGrid.DataSource = coll.Collection;
}
private void SearchButton_Click(object sender, RoutedEventArgs e)
{
try
{
Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname"));
q.Where
(
q.FirstName.Like("%" + SearchTextBox.Text + "%") | q.LastName.Like("%" + SearchTextBox.Text + "%")
);
service.Employees_QueryForCollectionAsync(q);
WorkingBar.Value = 0;
Timer.Begin();
}
catch (Exception exc)
{
Console.WriteLine(exc.StackTrace);
}
}
private void SearchButton_Click(object sender, RoutedEventArgs e)
{
try
{
Proxies.EmployeesQueryProxyStub q = new Proxies.EmployeesQueryProxyStub("emp");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate, (q.LastName + ", " + q.FirstName).As("Fullname"));
q.Where
(
q.FirstName.Like("%" + SearchTextBox.Text + "%") | q.LastName.Like("%" + SearchTextBox.Text + "%")
);
service.Employees_QueryForCollectionAsync(q);
WorkingBar.Value = 0;
Timer.Begin();
}
catch (Exception exc)
{
Console.WriteLine(exc.StackTrace);
}
}