private void frmJobSearch_Load(object sender, EventArgs e) { collJobs = new Jobs(Jobs.ContactView.Current); querybySurname = collJobs.Where(s => (s.StatusID == 1 && chkJobCancelled.Checked) || (s.StatusID == 2 && chkJobClosed.Checked) || (s.StatusID == 3 && chkJobNeedsDriver.Checked) || (s.StatusID == 4 && chkJobOpen.Checked)).Where(s => s.ClientSurname.ToString().ToUpper().StartsWith(txtSearchSurname.Text.ToUpper())).OrderBy(id => id.ClientSurname); queryCurrent = querybySurname; LoadListView(queryCurrent); }
private void txtPostCode_TextChanged(object sender, EventArgs e) { querybyPostCode = collJobs.Where(s => (s.StatusID == 1 && chkJobCancelled.Checked) || (s.StatusID == 2 && chkJobClosed.Checked) || (s.StatusID == 3 && chkJobNeedsDriver.Checked) || (s.StatusID == 4 && chkJobOpen.Checked)).Where(s => s.ClientPostCode.ToString().ToUpper().StartsWith(txtPostCode.Text.ToUpper())).OrderBy(id => id.ClientSurname); queryCurrent = querybyPostCode; LoadListView(queryCurrent); }