private void LoadData() { YellowstonePathology.Business.Monitor.Model.PendingTestCollection pendingTestCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPendingTestCollection(); pendingTestCollection.SetState(); pendingTestCollection = pendingTestCollection.SortByDifference(); this.m_PendingTestCollection = pendingTestCollection; this.NotifyPropertyChanged(""); }
private void LoadData() { YellowstonePathology.Business.Monitor.Model.PendingTestCollection pendingTestCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPendingTestCollection(); pendingTestCollection.SetState(); pendingTestCollection = pendingTestCollection.SortByDifference(); this.m_PendingTestCollection = pendingTestCollection; this.NotifyPropertyChanged(""); }
private void LoadData() { YellowstonePathology.Business.Monitor.Model.PendingTestCollection pendingTestCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPendingTestCollection(); pendingTestCollection.SetState(); this.m_CriticalTestCollection = pendingTestCollection.GetCriticalTestsForMonitorPriority(); this.m_NormalTestCollection = pendingTestCollection.GetNonCriticalTestsForMonitorPriority(); this.NotifyPropertyChanged(""); }
public static YellowstonePathology.Business.Monitor.Model.PendingTestCollection GetPendingTestCollection() { YellowstonePathology.Business.Monitor.Model.PendingTestCollection result = new YellowstonePathology.Business.Monitor.Model.PendingTestCollection(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select pso.ReportNo, pso.PanelSetName [TestName], pso.ExpectedFinalTime, pso.OrderTime, ao.ClientName, ao.PhysicianName [ProviderName], su.DisplayName [AssignedTo], pso.IsDelayed " + "from tblPanelSetOrder pso " + "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo " + "join tblSystemUser su on pso.AssignedToId = su.UserId " + "where final = 0 and panelSetId <> 212 " + //Will not show Missing Information Tests! "order by ExpectedFinalTime"; cmd.CommandType = CommandType.Text; using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.Monitor.Model.PendingTest pendingTest = new YellowstonePathology.Business.Monitor.Model.PendingTest(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pendingTest, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(pendingTest); } } } return result; }