private List <SVHCDMItem> GetList(DateTime workDate)
{
List <SVHCDMItem> result = new List <SVHCDMItem>();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "select pso.ReportNo, ao.PLastName, ao.PFirstName, ao.ClientName, ao.PhysicianName, pso.PanelSetName, " +
"tor.ResultStatus, tor.TestOrderReportDistributionId, pso.Distribute, tor.ScheduledDistributionTime " +
"from tblPanelSetOrder pso " +
"join tblTestOrderReportDistribution tor on pso.ReportNo = tor.ReportNo " +
"join tblAccessionOrder ao on pso.MasterAccessionno = ao.MasterAccessionNo " +
"where tor.ResultStatus = 'P';";
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SVHCDMItem item = new SVHCDMItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(item, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(item);
}
}
}
return(result);
}
public static YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection GetOrderBrowserListItemsByOrderDate(DateTime orderDate)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection resultCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItemCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, ClientName, " +
"OrderedBy, OrderTime, Submitted, Received, OrderType, ExternalOrderId " +
"from tblClientOrder " +
"Where tblClientOrder.OrderDate = @OrderDate " +
"Order by OrderTime desc;";
cmd.Parameters.AddWithValue("@OrderDate", orderDate);
cmd.CommandType = System.Data.CommandType.Text;
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.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(orderBrowserListItem, dr);
propertyWriter.WriteProperties();
resultCollection.Add(orderBrowserListItem);
}
}
}
return(resultCollection);
}
public static InsuranceMapCollection GetCollection()
{
InsuranceMapCollection result = new InsuranceMapCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "Select * from tblInsuranceMap";
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
InsuranceMap item = new InsuranceMap();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(item, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(item);
}
}
}
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();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select ClientOrderId, OrderStatus, ClientName, PanelSetId, PLastName, PFirstName, ProviderName, " +
"OrderedBy, OrderTime, Submitted, Received, OrderType, ExternalOrderId " +
"from tblClientOrder " +
"Where ClientId in (" + clientIdString + ") and " +
"OrderTime > date_add(curdate(), Interval -7 Day) and " +
"SystemInitiatingOrder <> 'YPIILIS' " +
"Order by OrderTime desc;";
cmd.CommandType = System.Data.CommandType.Text;
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.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(orderBrowserListItem, dr);
propertyWriter.WriteProperties();
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();
MySqlCommand cmd = new MySqlCommand();
cmd.Parameters.AddWithValue("@PLastName", lastName);
if (string.IsNullOrEmpty(firstName) == true)
{
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, " +
"ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType, ExternalOrderId " +
"from tblClientOrder Where tblClientOrder.PLastName like concat(@PLastName, '%') Order by OrderTime desc;";
}
else
{
cmd.Parameters.AddWithValue("@PFirstName", firstName);
cmd.CommandText = "Select ClientOrderId, OrderStatus, PanelSetId, PLastName, PFirstName, ProviderName, " +
"ClientName, OrderedBy, OrderTime, Submitted, Received, OrderType, ExternalOrderId " +
"from tblClientOrder Where tblClientOrder.PLastName like concat(@PLastName, '%') and PFirstName like " +
"concat(@PFirstName, '%') Order by OrderTime desc;";
}
cmd.CommandType = System.Data.CommandType.Text;
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.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = new YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(orderBrowserListItem, dr);
propertyWriter.WriteProperties();
resultCollection.Add(orderBrowserListItem);
}
}
}
return(resultCollection);
}
private static SimulationList BuildList(MySqlCommand cmd)
{
SimulationList result = new SimulationList();
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SimulationListItem item = new SimulationListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(item, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(item);
}
}
}
return(result);
}
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 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>();
MySqlCommand cmd = new MySqlCommand("pGetPatientLinkingV2");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("MasterAccessionNo", patientLinkingListItem.MasterAccessionNo);
cmd.Parameters.AddWithValue("PFirstName", patientLinkingListItem.PFirstName);
cmd.Parameters.AddWithValue("PLastName", patientLinkingListItem.PLastName);
cmd.Parameters.AddWithValue("PSSN", DBNull.Value);
if (string.IsNullOrEmpty(patientLinkingListItem.PSSN) == false)
{
cmd.Parameters["PSSN"].Value = patientLinkingListItem.PSSN;
}
cmd.Parameters.AddWithValue("PatientId", DBNull.Value);
if (string.IsNullOrEmpty(patientLinkingListItem.PatientId) == false)
{
cmd.Parameters["PatientId"].Value = patientLinkingListItem.PatientId;
}
cmd.Parameters.AddWithValue("PBirthdate", patientLinkingListItem.PBirthdate.Value);
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.Patient.Model.PatientLinkingListItem item = new YellowstonePathology.Business.Patient.Model.PatientLinkingListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Business.Persistence.SqlDataReaderPropertyWriter(item, dr);
propertyWriter.WriteProperties();
result.Add(item);
}
}
}
return(result);
}
