private void buttonQuery_Click(object sender, EventArgs e)
{
EmployeesQuery q = new EmployeesQuery("emp");
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.HireDate, q.BirthDate);
q.Where(q.LastName.Like("%" + txtLastName.Text + "%"));
q.OrderBy(q.LastName.Ascending);
coll = svc.Employees_QueryForCollection(EmployeesQuery.SerializeHelper.ToXml(q));
coll.EnableHierarchicalBinding = false;
_bindingSource.DataSource = coll;
}
private void buttonQuery_Click(object sender, EventArgs e)
{
EmployeesQuery q = new EmployeesQuery("emp");
q.Where(q.LastName.Like("%" + txtLastName.Text + "%"));
q.OrderBy(q.LastName.Ascending);
EmployeesCollectionProxyStub proxyColl = svc.Employees_QueryForCollection(EmployeesQuery.SerializeHelper.ToXml(q));
if (proxyColl != null)
{
_bindingSource.DataSource = coll = proxyColl.GetCollection();
}
else
{
_bindingSource.DataSource = coll = new BusinessObjects.EmployeesCollection();
}
}
public jsResponse <EmployeesCollection, Employees> Employees_Pager(jsPagerRequest request)
{
jsResponse <EmployeesCollection, Employees> response = new jsResponse <EmployeesCollection, Employees>();
try
{
// We send the the same data they sent us back
response.pagerRequest = request;
EmployeesQuery q = null;
if (response.pagerRequest.getTotalRows == true)
{
// Get the total count of rows in the Employee table
q = new EmployeesQuery();
q.es.CountAll = true;
response.pagerRequest.totalRows = q.ExecuteScalar <int>();
}
q = new EmployeesQuery();
q.Select(q.EmployeeID, q.FirstName, q.LastName, q.Title);
if (request.sortCriteria != null && request.sortCriteria.Length > 0)
{
for (int i = 0; i < request.sortCriteria.Length; i++)
{
jsPagerSortCriteria sort = request.sortCriteria[i];
q.OrderBy(sort.column, sort.direction.ToUpper().StartsWith("A") ?
esOrderByDirection.Ascending : esOrderByDirection.Descending);
}
}
else
{
// Default sort if none is specified
q.OrderBy(q.EmployeeID.Ascending);
}
if (request.filterCriteria != null && request.filterCriteria.Length > 0)
{
esComparison comp = null;
for (int i = 0; i < request.filterCriteria.Length; i++)
{
jsPagerFilterCriteria filter = request.filterCriteria[i];
comp = q.ManualWhere(filter.column, filter.operation, filter.criteria1, filter.criteria2, filter.conjuction);
}
q.Where(comp);
}
// Set the paging indicators up
q.es.PageNumber = request.pageNumber;
q.es.PageSize = request.pageSize;
EmployeesCollection coll = new EmployeesCollection();
coll.Load(q);
response.pagerRequest.getTotalRows = false;
response.collection = coll;
}
catch (Exception ex)
{
response.exception = ex.Message;
}
return(response);
}