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