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; }
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; }
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(); } }