public static XElement GetOrderComments(string masterAccessionNo)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblOrderCommentLog where MasterAccessionNo = @MasterAccessionNo; ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@MasterAccessionNo", SqlDbType.VarChar).Value = masterAccessionNo;
XElement result = new XElement("OrderComments");
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.Domain.OrderCommentLog orderCommentLog = new Domain.OrderCommentLog();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderCommentLog.WriteProperties(propertyWriter);
YellowstonePathology.Business.Domain.Persistence.XmlPropertyReader xmlPropertyReader = new Domain.Persistence.XmlPropertyReader();
xmlPropertyReader.Initialize("OrderComment");
orderCommentLog.ReadProperties(xmlPropertyReader);
result.Add(xmlPropertyReader.Document);
}
}
}
return result;
}
public YellowstonePathology.YpiConnect.Contract.Flow.FlowAccessionCollection Build()
{
YellowstonePathology.YpiConnect.Contract.Flow.FlowAccessionCollection flowAccessionCollection = new Contract.Flow.FlowAccessionCollection();
YellowstonePathology.YpiConnect.Contract.Flow.FlowAccession flowAccession = new Contract.Flow.FlowAccession();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
flowAccession.WriteProperties(propertyWriter);
flowAccessionCollection.Load(flowAccession);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Domain.SpecimenOrder specimenOrder = new Contract.Domain.SpecimenOrder();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
specimenOrder.WriteProperties(propertyWriter);
flowAccession.SpecimenOrderCollection.Load(specimenOrder);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Domain.PanelSetOrderLeukemiaLymphoma panelSetOrderLeukemiaLymphoma = new Contract.Domain.PanelSetOrderLeukemiaLymphoma();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
panelSetOrderLeukemiaLymphoma.WriteProperties(propertyWriter);
flowAccession.PanelSetOrderCollection.Load(panelSetOrderLeukemiaLymphoma);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Flow.FlowMarker flowMarker = new Contract.Flow.FlowMarker();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
flowMarker.WriteProperties(propertyWriter);
((YellowstonePathology.YpiConnect.Contract.Domain.PanelSetOrderLeukemiaLymphoma)flowAccession.PanelSetOrderCollection[0]).FlowMarkerCollection.Load(flowMarker);
}
}
}
flowAccession.CaseDocumentList = new Contract.RemoteFileList(flowAccession.PanelSetOrderCollection[0].ReportNo, false);
flowAccession.CaseDocumentList.Load();
return flowAccessionCollection;
}
public YellowstonePathology.YpiConnect.Contract.Billing.BillingDetail Build()
{
YellowstonePathology.YpiConnect.Contract.Billing.BillingDetail billingDetail = new Contract.Billing.BillingDetail();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.PanelSetOrderCPTCode panelSetOrderCPTCode = new Contract.Billing.PanelSetOrderCPTCode();
panelSetOrderCPTCode.WriteProperties(propertyWriter);
billingDetail.PanelSetOrderCPTCodeCollection.Add(panelSetOrderCPTCode);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.PanelSetOrderCPTCodeBill panelSetOrderCPTCodeBill = new Contract.Billing.PanelSetOrderCPTCodeBill();
panelSetOrderCPTCodeBill.WriteProperties(propertyWriter);
billingDetail.PanelSetOrderCPTCodeBillCollection.Add(panelSetOrderCPTCodeBill);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Billing.ICD9BillingCode icd9BillingCode = new Contract.Billing.ICD9BillingCode();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(icd9BillingCode, dr);
propertyWriter.WriteProperties();
billingDetail.ICD9BillingCodeCollection.Add(icd9BillingCode);
}
}
}
billingDetail.RemoteFileList = new Contract.RemoteFileList(this.m_ReportNo, this.m_IncludeMemorystream);
billingDetail.RemoteFileList.Load();
return billingDetail;
}
public YellowstonePathology.YpiConnect.Contract.Billing.BillingAccessionCollection Build()
{
YellowstonePathology.YpiConnect.Contract.Billing.BillingAccessionCollection billingAccessionCollection = new Contract.Billing.BillingAccessionCollection();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.BillingAccession billingAccession = new Contract.Billing.BillingAccession();
billingAccession.WriteProperties(propertyWriter);
billingAccessionCollection.Add(billingAccession);
}
}
}
return billingAccessionCollection;
}
public static ObservableCollection<YellowstonePathology.Business.Patient.Model.PatientLinkingListItem> GetPatientLinkingList(YellowstonePathology.Business.Patient.Model.PatientLinkingListItem patientLinkingListItem)
{
ObservableCollection<YellowstonePathology.Business.Patient.Model.PatientLinkingListItem> result = new ObservableCollection<Patient.Model.PatientLinkingListItem>();
SqlCommand cmd = new SqlCommand("pGetPatientLinking");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MasterAccessionNo", SqlDbType.VarChar).Value = patientLinkingListItem.MasterAccessionNo;
cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = patientLinkingListItem.PFirstName;
cmd.Parameters.Add("@PLastName", SqlDbType.VarChar).Value = patientLinkingListItem.PLastName;
cmd.Parameters.Add("@PSSN", SqlDbType.VarChar).Value = DBNull.Value;
if (string.IsNullOrEmpty(patientLinkingListItem.PSSN) == false)
{
cmd.Parameters["@PSSN"].Value = patientLinkingListItem.PSSN;
}
cmd.Parameters.Add("@PatientId", SqlDbType.VarChar).Value = DBNull.Value;
if (string.IsNullOrEmpty(patientLinkingListItem.PatientId) == false)
{
cmd.Parameters["@PatientId"].Value = patientLinkingListItem.PatientId;
}
cmd.Parameters.Add("@PBirthdate", SqlDbType.DateTime).Value = patientLinkingListItem.PBirthdate.Value;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Patient.Model.PatientLinkingListItem item = new YellowstonePathology.Business.Patient.Model.PatientLinkingListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
item.WriteProperties(propertyWriter);
result.Add(item);
}
}
}
return result;
}
private YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection BuildSearchResultCollection(SqlCommand cmd)
{
YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection searchResultCollection = new Contract.Search.SearchResultCollection();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Search.SearchResult searchResult = new Contract.Search.SearchResult();
searchResult.WriteProperties(propertyWriter);
searchResultCollection.Add(searchResult);
}
}
}
return searchResultCollection;
}
public static YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection GetShipmentListItemCollection(int clientId)
{
YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = " Select * from tblShipment where ClientId = @ClientId and (ShipDate is null or datediff(dd, ShipDate, getdate()) < 8) order by ShipDate Desc";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.ShipmentListItem shipmentListItem = new YellowstonePathology.Business.ClientOrder.Model.ShipmentListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
shipmentListItem.WriteProperties(propertyWriter);
resultCollection.Add(shipmentListItem);
}
}
}
return resultCollection;
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetRecentOrderBrowserListItemsByClientId(int clientId)
{
string clientIdString = clientId.ToString();
if (clientId == 649 || clientId == 650)
{
clientIdString = "649, 650";
}
else if (clientId == 723)
{
clientIdString = "649, 650, 723";
}
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ClientOrderId, OrderStatus, ClientName, PanelSetId, PLastName, PFirstName, ProviderName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder " +
"Where ClientId in (" + clientIdString + ") and " +
"OrderTime > dateadd(dd, -7, getdate()) and " +
"SystemInitiatingOrder <> 'YPIILIS' " +
"Order by OrderTime desc";
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return resultCollection;
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetOrderBrowserListItemsByPatientName(string lastName, string firstName)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@PLastName", SqlDbType.VarChar).Value = lastName;
if (string.IsNullOrEmpty(firstName) == true)
{
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder Where PLastName like @PLastName + '%' Order by OrderTime desc";
}
else
{
cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = firstName;
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder Where PLastName like @PLastName + '%' and PFirstName like @PFirstName + '%' Order by OrderTime desc";
}
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return resultCollection;
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetOrderBrowserListItemsByOrderDate(DateTime orderDate)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder " +
"Where OrderDate = @OrderDate " +
"Order by OrderTime desc";
cmd.Parameters.Add("@OrderDate", SqlDbType.DateTime).Value = orderDate;
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return resultCollection;
}
public YellowstonePathology.YpiConnect.Contract.Billing.BillingDetail Build()
{
YellowstonePathology.YpiConnect.Contract.Billing.BillingDetail billingDetail = new Contract.Billing.BillingDetail();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.PanelSetOrderCPTCode panelSetOrderCPTCode = new Contract.Billing.PanelSetOrderCPTCode();
panelSetOrderCPTCode.WriteProperties(propertyWriter);
billingDetail.PanelSetOrderCPTCodeCollection.Add(panelSetOrderCPTCode);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.PanelSetOrderCPTCodeBill panelSetOrderCPTCodeBill = new Contract.Billing.PanelSetOrderCPTCodeBill();
panelSetOrderCPTCodeBill.WriteProperties(propertyWriter);
billingDetail.PanelSetOrderCPTCodeBillCollection.Add(panelSetOrderCPTCodeBill);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Billing.ICD9BillingCode icd9BillingCode = new Contract.Billing.ICD9BillingCode();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(icd9BillingCode, dr);
propertyWriter.WriteProperties();
billingDetail.ICD9BillingCodeCollection.Add(icd9BillingCode);
}
}
}
billingDetail.RemoteFileList = new Contract.RemoteFileList(this.m_ReportNo, this.m_IncludeMemorystream);
billingDetail.RemoteFileList.Load();
return(billingDetail);
}
/*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.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 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.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 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 GetOrderComments(string masterAccessionNo)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblOrderCommentLog where MasterAccessionNo = @MasterAccessionNo; ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@MasterAccessionNo", SqlDbType.VarChar).Value = masterAccessionNo;
XElement result = new XElement("OrderComments");
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.Domain.OrderCommentLog orderCommentLog = new Domain.OrderCommentLog();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderCommentLog.WriteProperties(propertyWriter);
YellowstonePathology.Business.Domain.Persistence.XmlPropertyReader xmlPropertyReader = new Domain.Persistence.XmlPropertyReader();
xmlPropertyReader.Initialize("OrderComment");
orderCommentLog.ReadProperties(xmlPropertyReader);
result.Add(xmlPropertyReader.Document);
}
}
}
return result;
}
private YellowstonePathology.YpiConnect.Contract.Flow.MarkerCollection BuildMarkerCollection(SqlCommand cmd)
{
YellowstonePathology.YpiConnect.Contract.Flow.MarkerCollection markerCollection = new YellowstonePathology.YpiConnect.Contract.Flow.MarkerCollection();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Flow.Marker marker = new Contract.Flow.Marker();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
marker.WriteProperties(propertyWriter);
markerCollection.Add(marker);
}
}
}
return(markerCollection);
}
public static ObservableCollection <YellowstonePathology.Business.Patient.Model.PatientLinkingListItem> GetPatientLinkingList(YellowstonePathology.Business.Patient.Model.PatientLinkingListItem patientLinkingListItem)
{
ObservableCollection <YellowstonePathology.Business.Patient.Model.PatientLinkingListItem> result = new ObservableCollection <Patient.Model.PatientLinkingListItem>();
SqlCommand cmd = new SqlCommand("pGetPatientLinking");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MasterAccessionNo", SqlDbType.VarChar).Value = patientLinkingListItem.MasterAccessionNo;
cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = patientLinkingListItem.PFirstName;
cmd.Parameters.Add("@PLastName", SqlDbType.VarChar).Value = patientLinkingListItem.PLastName;
cmd.Parameters.Add("@PSSN", SqlDbType.VarChar).Value = DBNull.Value;
if (string.IsNullOrEmpty(patientLinkingListItem.PSSN) == false)
{
cmd.Parameters["@PSSN"].Value = patientLinkingListItem.PSSN;
}
cmd.Parameters.Add("@PatientId", SqlDbType.VarChar).Value = DBNull.Value;
if (string.IsNullOrEmpty(patientLinkingListItem.PatientId) == false)
{
cmd.Parameters["@PatientId"].Value = patientLinkingListItem.PatientId;
}
cmd.Parameters.Add("@PBirthdate", SqlDbType.DateTime).Value = patientLinkingListItem.PBirthdate.Value;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Patient.Model.PatientLinkingListItem item = new YellowstonePathology.Business.Patient.Model.PatientLinkingListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
item.WriteProperties(propertyWriter);
result.Add(item);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Domain.PatientHistory GetPatientHistory(string patientId)
{
YellowstonePathology.Business.Domain.PatientHistory result = new Domain.PatientHistory();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "pGetPatientHistoryResults";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PatientId", SqlDbType.VarChar).Value = patientId;
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.Domain.PatientHistoryResult patientHistoryResult = new Domain.PatientHistoryResult();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
patientHistoryResult.WriteProperties(propertyWriter);
result.Add(patientHistoryResult);
}
}
}
return result;
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetRecentOrderBrowserListItemsByClientId(int clientId)
{
string clientIdString = clientId.ToString();
if (clientId == 649 || clientId == 650)
{
clientIdString = "649, 650";
}
else if (clientId == 723)
{
clientIdString = "649, 650, 723";
}
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ClientOrderId, ClientName, PanelSetId, PLastName, PFirstName, ProviderName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder " +
"Where ClientId in (" + clientIdString + ") and " +
"OrderTime > dateadd(dd, -7, getdate()) and " +
"SystemInitiatingOrder <> 'YPIILIS' " +
"Order by OrderTime desc";
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return(resultCollection);
}
public static YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection GetShipmentListItemCollection(int clientId)
{
YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.ShipmentListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = " Select * from tblShipment where ClientId = @ClientId and (ShipDate is null or datediff(dd, ShipDate, getdate()) < 8) order by ShipDate Desc";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.ShipmentListItem shipmentListItem = new YellowstonePathology.Business.ClientOrder.Model.ShipmentListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
shipmentListItem.WriteProperties(propertyWriter);
resultCollection.Add(shipmentListItem);
}
}
}
return(resultCollection);
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetOrderBrowserListItemsByHoldStatus()
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ClientOrderId, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder " +
"Where Hold = 1 " +
"Order by OrderTime desc";
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return(resultCollection);
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetOrderBrowserListItemsByPatientName(string lastName, string firstName)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add("@PLastName", SqlDbType.VarChar).Value = lastName;
if (string.IsNullOrEmpty(firstName) == true)
{
cmd.CommandText = "Select ClientOrderId, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder Where PLastName like @PLastName + '%' Order by OrderTime desc";
}
else
{
cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = firstName;
cmd.CommandText = "Select ClientOrderId, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType " +
"from tblClientOrder Where PLastName like @PLastName + '%' and PFirstName like @PFirstName + '%' Order by OrderTime desc";
}
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
orderBrowserListItem.WriteProperties(propertyWriter);
resultCollection.Add(orderBrowserListItem);
}
}
}
return(resultCollection);
}
public YellowstonePathology.YpiConnect.Contract.Billing.BillingAccessionCollection Build()
{
YellowstonePathology.YpiConnect.Contract.Billing.BillingAccessionCollection billingAccessionCollection = new Contract.Billing.BillingAccessionCollection();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
YellowstonePathology.YpiConnect.Contract.Billing.BillingAccession billingAccession = new Contract.Billing.BillingAccession();
billingAccession.WriteProperties(propertyWriter);
billingAccessionCollection.Add(billingAccession);
}
}
}
return(billingAccessionCollection);
}
public YellowstonePathology.YpiConnect.Contract.Flow.FlowAccessionCollection Build()
{
YellowstonePathology.YpiConnect.Contract.Flow.FlowAccessionCollection flowAccessionCollection = new Contract.Flow.FlowAccessionCollection();
YellowstonePathology.YpiConnect.Contract.Flow.FlowAccession flowAccession = new Contract.Flow.FlowAccession();
using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString))
{
cn.Open();
m_Cmd.Connection = cn;
using (SqlDataReader dr = m_Cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
flowAccession.WriteProperties(propertyWriter);
flowAccessionCollection.Load(flowAccession);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Domain.SpecimenOrder specimenOrder = new Contract.Domain.SpecimenOrder();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
specimenOrder.WriteProperties(propertyWriter);
flowAccession.SpecimenOrderCollection.Load(specimenOrder);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Domain.PanelSetOrderLeukemiaLymphoma panelSetOrderLeukemiaLymphoma = new Contract.Domain.PanelSetOrderLeukemiaLymphoma();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
panelSetOrderLeukemiaLymphoma.WriteProperties(propertyWriter);
flowAccession.PanelSetOrderCollection.Load(panelSetOrderLeukemiaLymphoma);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.YpiConnect.Contract.Flow.FlowMarker flowMarker = new Contract.Flow.FlowMarker();
YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr);
flowMarker.WriteProperties(propertyWriter);
((YellowstonePathology.YpiConnect.Contract.Domain.PanelSetOrderLeukemiaLymphoma)flowAccession.PanelSetOrderCollection[0]).FlowMarkerCollection.Load(flowMarker);
}
}
}
flowAccession.CaseDocumentList = new Contract.RemoteFileList(flowAccession.PanelSetOrderCollection[0].ReportNo, false);
flowAccession.CaseDocumentList.Load();
return(flowAccessionCollection);
}
