public override void Visit(Test.AliquotOrder aliquotOrder)
{
if (aliquotOrder.TestOrderCollection.Exists(this.m_TestOrderId) == true)
{
aliquotOrder.TestOrderCollection.Remove(this.m_TestOrderId);
}
}
private void HandleTestOrderAliquotOrder(DataTable dataTable)
{
DataTableReader dataTableReader = new DataTableReader(dataTable);
while (dataTableReader.Read())
{
string aliquotOrderId = dataTableReader["AliquotOrderId"].ToString();
YellowstonePathology.Business.Test.AliquotOrder_Base aliquotOrder = null;
foreach (Business.Test.PanelSetOrder panelSetOrder in this.m_AccessionOrder.PanelSetOrderCollection)
{
foreach (Business.Test.PanelOrder panelOrder in panelSetOrder.PanelOrderCollection)
{
foreach (Business.Test.Model.TestOrder testOrder in panelOrder.TestOrderCollection)
{
if (testOrder.AliquotOrderId == aliquotOrderId)
{
if (testOrder.AliquotOrder == null)
{
aliquotOrder = new Test.AliquotOrder();
testOrder.AliquotOrder = aliquotOrder;
}
else
{
aliquotOrder = testOrder.AliquotOrder;
}
YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(aliquotOrder, dataTableReader);
sqlDataTableReaderPropertyWriter.WriteProperties();
}
}
}
}
}
}
public override void Visit(Test.AliquotOrder aliquotOrder)
{
if (aliquotOrder.TestOrderCollection.Exists(this.m_TestOrder.TestOrderId) == true)
{
this.m_TestOrderLeftSideIsRemoved = false;
}
}
private void BuildAliquotOrderTestOrder(Test.AliquotOrder aliquotOrder, XElement aliquotOrderElement)
{
List <XElement> aliquotOrderElements = (from item in aliquotOrderElement.Elements("TestOrderCollection")
select item).ToList <XElement>();
foreach (XElement testOrderElement in aliquotOrderElements.Elements("TestOrder"))
{
YellowstonePathology.Business.Test.Model.TestOrder testOrder = new YellowstonePathology.Business.Test.Model.TestOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(testOrderElement, testOrder);
xmlPropertyWriter.Write();
aliquotOrder.TestOrderCollection.Add(testOrder);
}
}
private void BuildAliquotOrderLeftSide(Specimen.Model.SpecimenOrder specimenOrder, XElement specimenOrderElement)
{
List <XElement> aliquotOrderElements = (from item in specimenOrderElement.Elements("AliquotOrderCollection")
select item).ToList <XElement>();
foreach (XElement aliquotOrderElement in aliquotOrderElements.Elements("AliquotOrder"))
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(aliquotOrderElement, aliquotOrder);
xmlPropertyWriter.Write();
BuildAliquotOrderTestOrder(aliquotOrder, aliquotOrderElement);
BuildAliquotOrderSlideOrderCollection(aliquotOrder, aliquotOrderElement);
specimenOrder.AliquotOrderCollection.Add(aliquotOrder);
}
}
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);
}
private void Build(YellowstonePathology.Business.Specimen.Model.SpecimenOrder specimenOrder)
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (MySqlDataReader dr = this.m_SQLCommand.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(specimenOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(aliquotOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
specimenOrder.AliquotOrderCollection.Add(aliquotOrder);
}
}
}
}
private void BuildAliquotOrderLeftSide(Specimen.Model.SpecimenOrder specimenOrder, XElement specimenOrderElement)
{
List<XElement> aliquotOrderElements = (from item in specimenOrderElement.Elements("AliquotOrderCollection")
select item).ToList<XElement>();
foreach (XElement aliquotOrderElement in aliquotOrderElements.Elements("AliquotOrder"))
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(aliquotOrderElement, aliquotOrder);
xmlPropertyWriter.Write();
BuildAliquotOrderTestOrder(aliquotOrder, aliquotOrderElement);
BuildAliquotOrderSlideOrderCollection(aliquotOrder, aliquotOrderElement);
specimenOrder.AliquotOrderCollection.Add(aliquotOrder);
}
}
public override object BuildNew()
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
this.Build(aliquotOrder);
return aliquotOrder;
}
private void BuildAliquotOrderLeftSide(Specimen.Model.SpecimenOrder specimenOrder, XElement specimenOrderElement)
{
List<XElement> aliquotOrderElements = (from item in specimenOrderElement.Elements("AliquotOrderCollection")
select item).ToList<XElement>();
specimenOrder.AliquotOrderCollection.RemoveDeleted(aliquotOrderElements.Elements("AliquotOrder"));
foreach (XElement aliquotOrderElement in aliquotOrderElements.Elements("AliquotOrder"))
{
string aliquotOrderId = aliquotOrderElement.Element("AliquotOrderId").Value;
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = null;
if (specimenOrder.AliquotOrderCollection.Exists(aliquotOrderId) == true)
{
aliquotOrder = specimenOrder.AliquotOrderCollection.Get(aliquotOrderId);
}
else
{
aliquotOrder = new Test.AliquotOrder();
specimenOrder.AliquotOrderCollection.Add(aliquotOrder);
}
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(aliquotOrderElement, aliquotOrder);
xmlPropertyWriter.Write();
BuildAliquotOrderTestOrder(aliquotOrder, aliquotOrderElement);
BuildAliquotOrderSlideOrderCollection(aliquotOrder, aliquotOrderElement);
}
}
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;
}
private void HandleTestOrderAliquotOrder(DataTable dataTable)
{
DataTableReader dataTableReader = new DataTableReader(dataTable);
while (dataTableReader.Read())
{
string aliquotOrderId = dataTableReader["AliquotOrderId"].ToString();
YellowstonePathology.Business.Test.AliquotOrder_Base aliquotOrder = null;
foreach(Business.Test.PanelSetOrder panelSetOrder in this.m_AccessionOrder.PanelSetOrderCollection)
{
foreach(Business.Test.PanelOrder panelOrder in panelSetOrder.PanelOrderCollection)
{
foreach(Business.Test.Model.TestOrder testOrder in panelOrder.TestOrderCollection)
{
if (testOrder.AliquotOrderId == aliquotOrderId)
{
if (testOrder.AliquotOrder == null)
{
aliquotOrder = new Test.AliquotOrder();
testOrder.AliquotOrder = aliquotOrder;
}
else
{
aliquotOrder = testOrder.AliquotOrder;
}
YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(aliquotOrder, dataTableReader);
sqlDataTableReaderPropertyWriter.WriteProperties();
}
}
}
}
}
}
public override object BuildNew()
{
YellowstonePathology.Business.Test.AliquotOrder aliquotOrder = new Test.AliquotOrder();
this.Build(aliquotOrder);
return(aliquotOrder);
}
