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