public static YellowstonePathology.Business.Test.AliquotOrderCollection GetAliquotOrderCollectionByReportNo(string reportNo)
{
YellowstonePathology.Business.Test.AliquotOrderCollection result = new Test.AliquotOrderCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "gwGetAliquotOrderCollectionByReportNo";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@ReportNo", System.Data.SqlDbType.VarChar).Value = reportNo;
XElement collectionElement = YellowstonePathology.Business.Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData);
if (collectionElement != null)
{
List <XElement> aliquotElements = (from item in collectionElement.Elements("AliquotOrder") select item).ToList <XElement>();
foreach (XElement aliquotElement in aliquotElements)
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(aliquotElement, aliquotOrder);
xmlPropertyWriter.Write();
result.Add(aliquotOrder);
}
}
return(result);
}
public static YellowstonePathology.Business.Test.AliquotOrderCollection GetAliquotOrderCollectionByReportNo(string reportNo)
{
YellowstonePathology.Business.Test.AliquotOrderCollection result = new Test.AliquotOrderCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "gwGetAliquotOrderCollectionByReportNo";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@ReportNo", System.Data.SqlDbType.VarChar).Value = reportNo;
XElement collectionElement = YellowstonePathology.Business.Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData);
if (collectionElement != null)
{
List<XElement> aliquotElements = (from item in collectionElement.Elements("AliquotOrder") select item).ToList<XElement>();
foreach (XElement aliquotElement in aliquotElements)
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(aliquotElement, aliquotOrder);
xmlPropertyWriter.Write();
result.Add(aliquotOrder);
}
}
return result;
}
public static YellowstonePathology.Business.Test.AliquotOrderCollection GetAliquotOrderCollection(string specimenOrderId)
{
YellowstonePathology.Business.Test.AliquotOrderCollection result = new Test.AliquotOrderCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblAliquotOrder where SpecimenOrderId = '" + specimenOrderId + "'";
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.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(aliquotOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(aliquotOrder);
}
}
}
return result;
}
public static YellowstonePathology.Business.Test.AliquotOrderCollection GetEmbeddingCollection(DateTime embeddingVerifiedDate)
{
YellowstonePathology.Business.Test.AliquotOrderCollection result = new Test.AliquotOrderCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select a.*, null as [TestOrderId] " +
"from tblAccessionOrder ao " +
"join tblSpecimenOrder s on ao.MasterAccessionNo = s.masterAccessionNo " +
"join tblAliquotOrder a on s.SpecimenOrderId = a.SpecimenOrderId " +
"where a.EmbeddingVerifiedDate between @EmbeddingVerifiedDate and @EmbeddingVerifiedDatePlus1 " +
"order by a.EmbeddingVerifiedDate desc";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@EmbeddingVerifiedDate", SqlDbType.DateTime).Value = embeddingVerifiedDate;
cmd.Parameters.Add("@EmbeddingVerifiedDatePlus1", SqlDbType.DateTime).Value = embeddingVerifiedDate.AddDays(1);
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.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(aliquotOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(aliquotOrder);
}
}
}
return result;
}
