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