public static YellowstonePathology.Business.Test.PantherOrderList GetPantherOrdersNotFinalNGCT()
{
YellowstonePathology.Business.Test.PantherOrderList result = new Test.PantherOrderList();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select pso.MasterAccessionNo, pso.ReportNo, pso.OrderTime, pso.PanelSetName, a.PLastName, a.PFirstName, pso.AcceptedTime, pso.FinalTime, null as Result, ngct.NeisseriaGonorrhoeaeResult, ngct.ChlamydiaTrachomatisResult, pso.HoldDistribution " +
"from tblPanelSetOrder pso " +
"join tblNGCTTestOrder ngct on pso.ReportNo = ngct.ReportNo " +
"join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo " +
"where TechnicalComponentInstrumentId = 'PNTHR' and pso.Accepted = 1 and pso.Final = 0 order by pso.FinalTime desc";
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Test.PantherOrderListItemNGCT pantherOrderListItem = new Test.PantherOrderListItemNGCT();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pantherOrderListItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(pantherOrderListItem);
}
}
}
return result;
}
public static YellowstonePathology.Business.Test.PantherOrderList GetPantherOrdersNotFinalWHP()
{
YellowstonePathology.Business.Test.PantherOrderList result = new Test.PantherOrderList();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select pso.MasterAccessionNo, pso.MasterAccessionNo, pso.ReportNo, pso.OrderTime, pso.PanelSetName, a.PLastName, a.PFirstName, pso.ResultCode, pso.AcceptedTime, pso.FinalTime, null as Result, pso.HoldDistribution " +
"from tblPanelSetOrder pso " +
"join tblWomensHealthProfileTestOrder psowhp on pso.ReportNo = psowhp.ReportNo " +
"join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo " +
"where pso.Final = 0 order by pso.OrderTime";
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Test.PantherOrderListItem pantherOrderListItem = new Test.PantherOrderListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pantherOrderListItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(pantherOrderListItem);
}
}
}
return result;
}
public static YellowstonePathology.Business.Test.PantherOrderList GetPantherOrdersFinalHPV()
{
YellowstonePathology.Business.Test.PantherOrderList result = new Test.PantherOrderList();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select pso.MasterAccessionNo, pso.ReportNo, pso.OrderTime, pso.PanelSetName, a.PLastName, a.PFirstName, pso.ResultCode, pso.AcceptedTime, pso.FinalTime, psoh.Result, pso.HoldDistribution " +
"from tblPanelSetOrder pso " +
"join tblHPVTestOrder psoh on pso.ReportNo = psoh.ReportNo " +
"join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo " +
"where TechnicalComponentInstrumentId = 'PNTHR' and pso.Final = 1 and pso.FinalDate >= dateAdd(mm, -3, pso.FinalDate) order by pso.FinalTime desc";
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Test.PantherOrderListItem pantherOrderListItem = new Test.PantherOrderListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pantherOrderListItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(pantherOrderListItem);
}
}
}
return result;
}