public YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection GetAllOrderTypes() { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select * from tblOrderType order by priority;"; cmd.CommandType = System.Data.CommandType.Text; YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection result = BuildOrderTypeCollection(cmd); return(result); }
private static YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection BuildOrderTypeCollection(MySqlCommand cmd) { YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection orderTypeCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection(); 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.OrderType orderType = new YellowstonePathology.Business.ClientOrder.Model.OrderType(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(orderType, dr); propertyWriter.WriteProperties(); orderTypeCollection.Add(orderType); } } } return(orderTypeCollection); }
public OrderCategory() { this.m_OrderTypeCollection = new OrderTypeCollection(); }
private static YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection BuildOrderTypeCollection(SqlCommand cmd) { YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection orderTypeCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection(); using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.ClientOrder.Model.OrderType orderType = new YellowstonePathology.Business.ClientOrder.Model.OrderType(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(orderType, dr); propertyWriter.WriteProperties(); orderTypeCollection.Add(orderType); } } } return orderTypeCollection; }
public OrderCategory() { this.m_OrderTypeCollection = new OrderTypeCollection(); }
public YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection GetAllOrderTypes() { YellowstonePathology.Business.ClientOrder.Model.OrderTypeCollection orderTypeCollection = this.m_ClientOrderChannel.GetAllOrderTypes(); return(orderTypeCollection); }