public static XElement GetOrderComments(string masterAccessionNo)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * from tblOrderCommentLog where MasterAccessionNo = @MasterAccessionNo;";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@MasterAccessionNo", masterAccessionNo);
XElement result = new XElement("OrderComments");
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.OrderCommentLog orderCommentLog = new Domain.OrderCommentLog();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(orderCommentLog, dr);
propertyWriter.WriteProperties();
XElement comment = new XElement("OrderComment");
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new Persistence.XmlPropertyReader(orderCommentLog, comment);
xmlPropertyReader.Write();
result.Add(comment);
}
}
}
return(result);
}
public static XElement GetSpecimenOrder(string masterAccessionNo)
{
XElement result = new XElement("SpecimenOrders");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblSpecimenOrder where MasterAccessionno = '" + masterAccessionNo + "' order by SpecimenNumber";
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Specimen.Model.SpecimenOrder specimenOrder = new Specimen.Model.SpecimenOrder();
XElement specimenOrderElement = new XElement("SpecimenOrder");
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(specimenOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new Persistence.XmlPropertyReader(specimenOrder, specimenOrderElement);
xmlPropertyReader.Write();
result.Add(specimenOrderElement);
}
}
}
return result;
}
public XElement AsXML()
{
XElement clientOrderDetailAliquotElement = new XElement("ClientOrderDetailAliquot");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailAliquotPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderDetailAliquotElement);
clientOrderDetailAliquotPropertyWriter.Write();
return(clientOrderDetailAliquotElement);
}
public XElement AsXML()
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailAliquot clientOrderDetailAliquot in this.ClientOrderDetailAliquotCollection)
{
XElement clientOrderDetailAliquotElement = clientOrderDetailAliquot.AsXML();
clientOrderDetailElement.Add(clientOrderDetailAliquotElement);
}
return(clientOrderDetailElement);
}
public virtual XElement ToXML(bool includeChildren)
{
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderElement);
clientOrderPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in this.ClientOrderDetailCollection)
{
XElement clientOrderDetailElement = clientOrderDetail.AsXML();
clientOrderElement.Add(clientOrderDetailElement);
}
return(clientOrderElement);
}
public static YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData GetPlacentalPathologyQuestionnaire(string clientOrderId, object writer)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullClientOrderByClientOrderId(clientOrderId, writer);
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(clientOrder, clientOrderElement);
clientOrderPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in clientOrder.ClientOrderDetailCollection)
{
if (clientOrderDetail.OrderTypeCode == "PLCNT")
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData result = new YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData(clientOrderElement);
return result;
}
public static XElement GetClientOrders(string masterAccessionNo)
{
XElement result = new XElement("ClientOrders");
YellowstonePathology.Business.ClientOrder.Model.ClientOrderCollection clientOrderCollection = YellowstonePathology.Business.Gateway.ClientOrderGateway.GetClientOrdersByMasterAccessionNo(masterAccessionNo);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder in clientOrderCollection)
{
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(clientOrder, clientOrderElement);
clientOrderPropertyWriter.Write();
result.Add(clientOrderElement);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in clientOrder.ClientOrderDetailCollection)
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
return result;
}
public virtual XElement ToXML(bool includeChildren)
{
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderElement);
clientOrderPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in this.ClientOrderDetailCollection)
{
XElement clientOrderDetailElement = clientOrderDetail.AsXML();
clientOrderElement.Add(clientOrderDetailElement);
}
return clientOrderElement;
}
public XElement AsXML()
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailAliquot clientOrderDetailAliquot in this.ClientOrderDetailAliquotCollection)
{
XElement clientOrderDetailAliquotElement = clientOrderDetailAliquot.AsXML();
clientOrderDetailElement.Add(clientOrderDetailAliquotElement);
}
return clientOrderDetailElement;
}
public XElement AsXML()
{
XElement clientOrderDetailAliquotElement = new XElement("ClientOrderDetailAliquot");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailAliquotPropertyWriter = new Persistence.XmlPropertyReader(this, clientOrderDetailAliquotElement);
clientOrderDetailAliquotPropertyWriter.Write();
return clientOrderDetailAliquotElement;
}
public static XElement GetClientOrders(string masterAccessionNo)
{
XElement result = new XElement("ClientOrders");
YellowstonePathology.Business.ClientOrder.Model.ClientOrderCollection clientOrderCollection = YellowstonePathology.Business.Gateway.ClientOrderGateway.GetClientOrdersByMasterAccessionNo(masterAccessionNo);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder in clientOrderCollection)
{
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(clientOrder, clientOrderElement);
clientOrderPropertyWriter.Write();
result.Add(clientOrderElement);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in clientOrder.ClientOrderDetailCollection)
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
return result;
}
public static XElement GetSpecimenOrder(string masterAccessionNo)
{
XElement result = new XElement("SpecimenOrders");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblSpecimenOrder where MasterAccessionno = '" + masterAccessionNo + "' order by SpecimenNumber";
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Specimen.Model.SpecimenOrder specimenOrder = new Specimen.Model.SpecimenOrder();
XElement specimenOrderElement = new XElement("SpecimenOrder");
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(specimenOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new Persistence.XmlPropertyReader(specimenOrder, specimenOrderElement);
xmlPropertyReader.Write();
result.Add(specimenOrderElement);
}
}
}
return result;
}
public static YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData GetPlacentalPathologyQuestionnaire(string clientOrderId, object writer)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullClientOrderByClientOrderId(clientOrderId, writer);
XElement clientOrderElement = new XElement("ClientOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderPropertyWriter = new Persistence.XmlPropertyReader(clientOrder, clientOrderElement);
clientOrderPropertyWriter.Write();
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in clientOrder.ClientOrderDetailCollection)
{
if (clientOrderDetail.OrderTypeCode == "PLCNT")
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData result = new YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData(clientOrderElement);
return result;
}