private void ListViewOrders_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (this.ListViewOrders.SelectedItems.Count != 0)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = (YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem) this.ListViewOrders.SelectedItem;
this.HandleOrderDetailRequested(orderBrowserListItem);
}
}
private void ListViewClientOrders_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.ListViewClientOrders.SelectedItem != null)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = (YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem) this.ListViewClientOrders.SelectedItem;
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullClientOrderByClientOrderId(orderBrowserListItem.ClientOrderId, this.m_Writer);
YellowstonePathology.Business.Document.ClientOrderCaseDocument clientOrderCaseDocument = new Business.Document.ClientOrderCaseDocument(clientOrder);
this.m_DocumentViewer.ShowDocument(clientOrderCaseDocument);
}
}
private void HyperSendMessage_Click(object sender, RoutedEventArgs e)
{
YpiConnect.Contract.Message message = new Contract.Message("*****@*****.**", YpiConnect.Contract.Identity.ApplicationIdentity.Instance.WebServiceAccount);
if (this.ListViewOrders.SelectedItem != null)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = (YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem) this.ListViewOrders.SelectedItem;
message.PatientName = orderBrowserListItem.PFirstName + " " + orderBrowserListItem.PLastName;
}
MessagePage messagePage = new MessagePage(message);
ApplicationNavigator.ApplicationContentFrame.NavigationService.Navigate(messagePage);
}
private void HandleOrderDetailRequested(YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = this.m_OrderEntryUI.ClientOrderServiceProxy.GetClientOrderByClientOrderId(orderBrowserListItem.ClientOrderId);
if (clientOrder.PanelSetId.HasValue == false)
{
if (clientOrder.ClientLocation.AllowMultipleOrderTypes == true)
{
this.GoToOrderTypePage(clientOrder);
}
else
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder specificClientOrder = YellowstonePathology.Business.ClientOrder.Model.ClientOrderFactory.GetClientOrder(clientOrder.ClientLocation.DefaultOrderPanelSetId);
specificClientOrder.Join(clientOrder);
specificClientOrder.PanelSetId = clientOrder.ClientLocation.DefaultOrderPanelSetId;
this.GoToOrderEntryPage(specificClientOrder);
}
}
else
{
this.GoToOrderEntryPage(clientOrder);
}
}
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 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 void ListViewOrders_KeyUp(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
if (this.ListViewOrders.SelectedItems.Count != 0)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = (YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem) this.ListViewOrders.SelectedItem;
this.HandleOrderDetailRequested(orderBrowserListItem);
}
}
}
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;
}
private void ListViewClientOrders_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (this.ListViewClientOrders.SelectedItem != null)
{
YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem orderBrowserListItem = (YellowstonePathology.Business.ClientOrder.Model.OrderBrowserListItem) this.ListViewClientOrders.SelectedItem;
YellowstonePathology.UI.Login.Receiving.ReceiveSpecimenPathStartingWithOrder path = new Login.Receiving.ReceiveSpecimenPathStartingWithOrder(orderBrowserListItem.ClientOrderId);
path.Start();
}
}
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.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);
}
