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