private void BuildClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder) { using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); this.m_SQLCommand.Connection = cn; using (SqlDataReader 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 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 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 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 static YellowstonePathology.Business.Client.Model.ClientSupplyOrder BuildClientSupplyOrder(XElement sourceElement) { YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder = new Client.Model.ClientSupplyOrder(); YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriter = new Persistence.XmlPropertyWriter(sourceElement, clientSupplyOrder); xmlPropertyWriter.Write(); List<XElement> clientSupplyOrderDetailElements = (from item in sourceElement.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 xmlPropertyWriterDetail = new YellowstonePathology.Business.Persistence.XmlPropertyWriter(clientSupplyOrderDetailElement, clientSupplyOrderDetail); xmlPropertyWriterDetail.Write(); clientSupplyOrder.ClientSupplyOrderDetailCollection.Add(clientSupplyOrderDetail); } return clientSupplyOrder; }
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; }