private void ListViewMissingInformation_DoubleClick(object sender, MouseButtonEventArgs e)
{
if (this.ListViewMissingInformation.SelectedItem != null)
{
YellowstonePathology.Business.Monitor.Model.MissingInformation missingInformation = (YellowstonePathology.Business.Monitor.Model.MissingInformation) this.ListViewMissingInformation.SelectedItem;
YellowstonePathology.Business.Test.AccessionOrder accessionOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullAccessionOrder(missingInformation.MasterAccessionNo, Window.GetWindow(this));
YellowstonePathology.Business.User.SystemIdentity systemIdentity = Business.User.SystemIdentity.Instance;
this.m_LoginPageWindow = new Login.Receiving.LoginPageWindow();
this.m_LoginPageWindow.Show();
YellowstonePathology.Business.Test.MissingInformation.MissingInformationTestOrder missingInformationTestOrder = (YellowstonePathology.Business.Test.MissingInformation.MissingInformationTestOrder)accessionOrder.PanelSetOrderCollection.GetPanelSetOrder(missingInformation.ReportNo);
YellowstonePathology.UI.Test.ResultPathFactory resultPathFactory = new Test.ResultPathFactory();
resultPathFactory.Start(missingInformationTestOrder, accessionOrder, this.m_LoginPageWindow.PageNavigator, System.Windows.Window.GetWindow(this), Visibility.Collapsed);
resultPathFactory.Finished += ResultPathFactory_Finished;
}
}
public static YellowstonePathology.Business.Monitor.Model.MissingInformationCollection GetMissingInformationCollection()
{
YellowstonePathology.Business.Monitor.Model.MissingInformationCollection result = new YellowstonePathology.Business.Monitor.Model.MissingInformationCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select pso.MasterAccessionNo, pso.ReportNo, pso.PanelSetName [TestName], pso.ExpectedFinalTime, pso.OrderTime, mit.FirstCallComment, mit.SecondCallComment, ao.PhysicianName [ProviderName] " +
"from tblPanelSetOrder pso " +
"join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo " +
"join tblMissingInformationTestOrder mit on pso.ReportNo = mit.ReportNo " +
"join tblSystemUser su on pso.AssignedToId = su.UserId " +
"where pso.PanelSetId = 212 and pso.Final = 0" +
"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.MissingInformation missingInformation = new YellowstonePathology.Business.Monitor.Model.MissingInformation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(missingInformation, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(missingInformation);
}
}
}
return result;
}
