public static XElement GetAccessionOrder(string masterAccessionNo)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblAccessionOrder where MasterAccessionno = '" + masterAccessionNo + "'";
cmd.CommandType = CommandType.Text;
YellowstonePathology.Business.Test.AccessionOrder accessionOrder = new Test.AccessionOrder();
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.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(accessionOrder, dr);
propertyWriter.WriteProperties();
}
}
}
XElement result = new XElement("AccessionOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new YellowstonePathology.Business.Persistence.XmlPropertyReader(accessionOrder, result);
xmlPropertyReader.Write();
return result;
}
public static XElement GetAccessionOrder(string masterAccessionNo)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblAccessionOrder where MasterAccessionno = '" + masterAccessionNo + "'";
cmd.CommandType = CommandType.Text;
YellowstonePathology.Business.Test.AccessionOrder accessionOrder = new Test.AccessionOrder();
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.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(accessionOrder, dr);
propertyWriter.WriteProperties();
}
}
}
XElement result = new XElement("AccessionOrder");
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new YellowstonePathology.Business.Persistence.XmlPropertyReader(accessionOrder, result);
xmlPropertyReader.Write();
return result;
}
private void PlacentalFormDisplayPage_Loaded(object sender, RoutedEventArgs e)
{
XElement clientOrderElement = this.m_ClientOrder.ToXML(false);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in this.m_ClientOrder.ClientOrderDetailCollection)
{
if (clientOrderDetail.OrderTypeCode == "PLCNT")
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData placentalPathologyQuestionnaireData = new YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData(clientOrderElement);
YellowstonePathology.Document.PlacentalPathologyQuestionnaire placentalPathologyQuestionnare = new Document.PlacentalPathologyQuestionnaire(placentalPathologyQuestionnaireData);
this.Viewer.Document = placentalPathologyQuestionnare.FixedDocument;
}
private void PlacentalFormDisplayPage_Loaded(object sender, RoutedEventArgs e)
{
XElement clientOrderElement = this.m_ClientOrder.ToXML(false);
foreach (YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail in this.m_ClientOrder.ClientOrderDetailCollection)
{
if (clientOrderDetail.OrderTypeCode == "PLCNT")
{
XElement clientOrderDetailElement = new XElement("ClientOrderDetail");
YellowstonePathology.Business.Persistence.XmlPropertyReader clientOrderDetailPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyReader(clientOrderDetail, clientOrderDetailElement);
clientOrderDetailPropertyWriter.Write();
clientOrderElement.Add(clientOrderDetailElement);
}
}
YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData placentalPathologyQuestionnaireData = new YellowstonePathology.Document.Result.Data.PlacentalPathologyQuestionnaireData(clientOrderElement);
YellowstonePathology.Document.PlacentalPathologyQuestionnaire placentalPathologyQuestionnare = new Document.PlacentalPathologyQuestionnaire(placentalPathologyQuestionnaireData);
this.Viewer.Document = placentalPathologyQuestionnare.FixedDocument;
}
