public void Load() { JobCollection.Clear(); DAL dal = new DAL(); DataTable dt = dal.Read("select JobRequest_Id,bit_job_type.Job_Type,bit_job_type.Job_Type_Id,RequestDate,Priority,Comments,Status,bit_client_location.Location_Name,bit_client_location.Location_Id from bit_job_request, bit_job_type, bit_client_location where bit_job_request.Job_Type_Id = bit_job_type.Job_Type_Id and bit_job_request.Location_Id = bit_client_location.Location_Id and Status in('Requested','Acknowledged') order by JobRequest_Id"); foreach (DataRow dr in dt.Rows) { JobAssignment job = new JobAssignment(dr); JobCollection.Add(job); } }
public void RefreshJobList() { try { List <Job> jobList = DataController.GetInstance.GetJobs(); jc = Application.Current.Resources["JobCollection"] as JobCollection; jc.Clear(); foreach (Job job in jobList) { jc.Add(job); } Application.Current.Resources["JobCollection"] = jc; } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
public void ClearList() { JobCollection.Clear(); NotifyOfPropertyChange(() => JobCollection); }