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); }