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