private void LoadData() { YellowstonePathology.Business.Monitor.Model.CytologyScreeningCollection cytologyScreeningCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPendingCytologyScreening(); cytologyScreeningCollection.SetState(); cytologyScreeningCollection = cytologyScreeningCollection.SortByState(); this.m_CytologyScreeningCollection = cytologyScreeningCollection; this.NotifyPropertyChanged(""); }
private void LoadData() { YellowstonePathology.Business.Monitor.Model.CytologyScreeningCollection cytologyScreeningCollection = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPendingCytologyScreening(); cytologyScreeningCollection.SetState(); cytologyScreeningCollection = cytologyScreeningCollection.SortByState(); this.m_CytologyScreeningCollection = cytologyScreeningCollection; this.NotifyPropertyChanged(""); }
public static YellowstonePathology.Business.Monitor.Model.CytologyScreeningCollection GetPendingCytologyScreening() { YellowstonePathology.Business.Monitor.Model.CytologyScreeningCollection result = new YellowstonePathology.Business.Monitor.Model.CytologyScreeningCollection(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select pso.ReportNo, ao.AccessionTime, cpo.ScreeningType, cpo.ScreenedByName, su1.DisplayName [AssignedToName], po.AcceptedTime [ScreeningFinalTime], pso.FinalTime [CaseFinalTime], ao.ClientName, ao.PhysicianName [ProviderName], pso.Final, " + "(Select count(*) from tblPanelOrder where Reportno = pso.ReportNo) as [ScreeningCount] " + "from tblAccessionOrder ao join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo " + "join tblPanelOrder po on pso.ReportNo = po.ReportNo " + "join tblPanelOrderCytology cpo on po.PanelOrderId = cpo.PanelORderId " + "left outer join tblSystemUser su on po.OrderedById = su.UserId " + "left outer join tblSystemUser su1 on po.AssignedToId = su1.UserId " + "Where pso.PanelSetId = 15 And po.Accepted = 0 and pso.Final = 0 " + "Order By ao.AccessionTime"; 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.CytologyScreening cytologyScreening = new YellowstonePathology.Business.Monitor.Model.CytologyScreening(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(cytologyScreening, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(cytologyScreening); } } } return result; }