private void BuildClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder) { using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); this.m_SQLCommand.Connection = cn; using (MySqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo)) { while (dr.Read()) { Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrder, dr); sqlDataReaderPropertyWriter.WriteProperties(); } dr.NextResult(); while (dr.Read()) { YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail clientSupplyOrderDetail = new YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail(); Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrderDetail, dr); sqlDataReaderPropertyWriter.WriteProperties(); clientSupplyOrder.ClientSupplyOrderDetailCollection.Add(clientSupplyOrderDetail); } } } }
private void ListViewOrderDetails_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (this.ListViewOrderDetails.SelectedItem != null) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewOrderDetails.SelectedItem; ClientSupplyOrderDialog clientSupplyOrderDialog = new ClientSupplyOrderDialog(clientSupplyOrder); clientSupplyOrderDialog.ShowDialog(); } }
private void ButtonDeleteSupplyOrder_Click(object sender, RoutedEventArgs e) { if (this.ListViewOrderDetails.SelectedItem != null) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewOrderDetails.SelectedItem; YellowstonePathology.Business.Persistence.DocumentGateway.Instance.DeleteDocument(clientSupplyOrder, this); this.ClientSupplyOrderCollection.Remove(clientSupplyOrder); this.NotifyPropertyChanged("ClientSupplyOrderCollection"); } }
private void ListViewClientSupplyOrders_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (this.ListViewClientSupplyOrders.SelectedItem != null) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewClientSupplyOrders.SelectedItem; YellowstonePathology.UI.Client.ClientSupplyOrderDialog clientSupplyOrderDialog = new ClientSupplyOrderDialog(clientSupplyOrder.ClientSupplyOrderId); clientSupplyOrderDialog.ShowDialog(); this.FillClientSupplyOrderCollection(); } }
public ClientSupplyOrderDialog(string clientSupplyOrderId) { this.m_ClientSupplyOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullClientSupplyOrder(clientSupplyOrderId, this); this.m_UserCollection = YellowstonePathology.Business.User.SystemUserCollectionInstance.Instance.SystemUserCollection.GetUsersByRole(Business.User.SystemUserRoleDescriptionEnum.Log, true); InitializeComponent(); this.DataContext = this; Closing += ClientSupplyOrderDialog_Closing; Loaded += ClientSupplyOrderDialog_Loaded; Unloaded += ClientSupplyOrderDialog_Unloaded; }
public ClientSupplyOrderDialog(string clientSupplyOrderId) { this.m_ClientSupplyOrder = YellowstonePathology.Business.Persistence.DocumentGateway.Instance.PullClientSupplyOrder(clientSupplyOrderId, this); this.m_UserCollection = YellowstonePathology.Business.User.SystemUserCollectionInstance.Instance.SystemUserCollection.GetUsersByRole(Business.User.SystemUserRoleDescriptionEnum.Log, true); InitializeComponent(); this.DataContext = this; Closing += ClientSupplyOrderDialog_Closing; Loaded += ClientSupplyOrderDialog_Loaded; Unloaded += ClientSupplyOrderDialog_Unloaded; }
public void PullClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder, object writer) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT cso.*, (SELECT * from tblClientSupplyOrderDetail where clientsupplyorderid = cso.ClientSupplyOrderId for xml path('ClientSupplyOrderDetail'), type) ClientSupplyOrderDetailCollection " + "FROM tblClientSupplyOrder cso where cso.ClientSupplyOrderId = @ClientSupplyOrderId for xml Path('ClientSupplyOrder'), type"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ClientSupplyOrderId", SqlDbType.VarChar).Value = clientSupplyOrder.ClientSupplyOrderId; ClientSupplyOrderDocumentBuilder builder = new ClientSupplyOrderDocumentBuilder(cmd); DocumentId documentId = new DocumentId(clientSupplyOrder, writer); Document document = this.m_Stack.Pull(documentId, builder); }
private void ButtonPrint_Click(object sender, RoutedEventArgs e) { if (this.ListViewClientSupplyOrders.SelectedItem != null) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewClientSupplyOrders.SelectedItem; XElement dataElement = YellowstonePathology.Business.Gateway.XmlGateway.GetClientSupplyOrderReportData(clientSupplyOrder.ClientSupplyOrderId); YellowstonePathology.Business.XPSDocument.Result.Data.ClientSupplyOrderReportData clientSupplyOrderReportData = new Business.XPSDocument.Result.Data.ClientSupplyOrderReportData(dataElement); YellowstonePathology.Business.XPSDocument.Result.Xps.ClientSupplyOrderReport clientSupplyOrderReport = new Business.XPSDocument.Result.Xps.ClientSupplyOrderReport(clientSupplyOrderReportData); XpsDocumentViewer xpsDocumentViewer = new XpsDocumentViewer(); xpsDocumentViewer.LoadDocument(clientSupplyOrderReport.FixedDocument); xpsDocumentViewer.ShowDialog(); } }
private void BuildClientSupplyOrderDetail(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder, XElement clientSupplyOrderElement) { clientSupplyOrder.ClientSupplyOrderDetailCollection.Clear(); List <XElement> clientSupplyOrderDetailElements = (from item in clientSupplyOrderElement.Elements("ClientSupplyOrderDetailCollection") select item).ToList <XElement>(); foreach (XElement clientSupplyOrderDetailElement in clientSupplyOrderDetailElements.Elements("ClientSupplyOrderDetail")) { YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail clientSupplyOrderDetail = new YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail(); YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(clientSupplyOrderDetailElement, clientSupplyOrderDetail); xmlPropertyWriter.Write(); clientSupplyOrder.ClientSupplyOrderDetailCollection.Add(clientSupplyOrderDetail); } }
private void ButtonDeleteSupplyOrder_Click(object sender, RoutedEventArgs e) { if (this.ListViewOrderDetails.SelectedItem != null) { MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure you want to delete this supply order?", "Delete?", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewOrderDetails.SelectedItem; YellowstonePathology.Business.Persistence.DocumentGateway.Instance.DeleteDocument(clientSupplyOrder, this); this.ClientSupplyOrderCollection.Remove(clientSupplyOrder); this.NotifyPropertyChanged("ClientSupplyOrderCollection"); } } }
private void ButtonDelete_Click(object sender, RoutedEventArgs e) { if (this.ListViewClientSupplyOrders.SelectedItem != null) { MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure you want to delete this supply order?", "Delete?", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder) this.ListViewClientSupplyOrders.SelectedItem; YellowstonePathology.Business.Persistence.DocumentGateway.Instance.DeleteDocument(clientSupplyOrder, this); this.FillClientSupplyOrderCollection(); } } else { MessageBox.Show("You must select an item before deleting."); } }
private void BuildClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder) { using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); this.m_SQLCommand.Connection = cn; using (XmlReader xmlReader = this.m_SQLCommand.ExecuteXmlReader()) { if (xmlReader.Read() == true) { XElement result = XElement.Load(xmlReader, LoadOptions.PreserveWhitespace); YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(result, clientSupplyOrder); xmlPropertyWriter.Write(); BuildClientSupplyOrderDetail(clientSupplyOrder, result); } } } }
public override void Refresh(object o) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = (YellowstonePathology.Business.Client.Model.ClientSupplyOrder)o; this.BuildClientSupplyOrder(clientSupplyOrder); //document.IsLockAquiredByMe = true; }
private static YellowstonePathology.Business.Client.Model.ClientSupplyOrderCollection BuildClientSupplyOrderCollection(SqlCommand cmd) { Client.Model.ClientSupplyOrderCollection result = new Client.Model.ClientSupplyOrderCollection(); using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.KeyInfo)) { while (dr.Read()) { Client.Model.ClientSupplyOrder clientSupplyOrder = new YellowstonePathology.Business.Client.Model.ClientSupplyOrder(); Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrder, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(clientSupplyOrder); } if (dr.IsClosed == false) { dr.NextResult(); while (dr.Read()) { YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail clientSupplyOrderDetail = new YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail(); Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrderDetail, dr); sqlDataReaderPropertyWriter.WriteProperties(); foreach (Client.Model.ClientSupplyOrder clientSupplyOrder in result) { if (clientSupplyOrder.ClientSupplyOrderId == clientSupplyOrderDetail.clientsupplyorderid) { clientSupplyOrder.ClientSupplyOrderDetailCollection.Add(clientSupplyOrderDetail); break; } } } } } } return result; }