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