public YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection GetAllOrderCategories() { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select * from tblOrderCategory order by priority; " + "Select * from tblOrderType order by priority;"; cmd.CommandType = System.Data.CommandType.Text; YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection result = BuildOrderCategoryCollection(cmd); return(result); }
public YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection GetOrderCategory(string orderCategoryId) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select * from tblOrderCategory where tblOrderCategory.OrderCategoryId = @OrderCategoryId order by Priority; " + "Select * from tblOrderType where tblOrderType.OrderCategoryId = @OrderCategoryId order by Priority;"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@OrderCategoryId", orderCategoryId); YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection result = BuildOrderCategoryCollection(cmd); return(result); }
private static YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection BuildOrderCategoryCollection(MySqlCommand cmd) { YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection orderCategoryCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection(); 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.OrderCategory orderCategory = new YellowstonePathology.Business.ClientOrder.Model.OrderCategory(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(orderCategory, dr); propertyWriter.WriteProperties(); orderCategoryCollection.Add(orderCategory); } dr.NextResult(); 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(); foreach (YellowstonePathology.Business.ClientOrder.Model.OrderCategory orderCategory in orderCategoryCollection) { if (orderCategory.OrderCategoryId == orderType.OrderCategoryId) { orderCategory.OrderTypeCollection.Add(orderType); break; } } } } } return(orderCategoryCollection); }
private static YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection BuildOrderCategoryCollection(SqlCommand cmd) { YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection orderCategoryCollection = new YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection(); using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.ClientOrder.Model.OrderCategory orderCategory = new YellowstonePathology.Business.ClientOrder.Model.OrderCategory(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(orderCategory, dr); propertyWriter.WriteProperties(); orderCategoryCollection.Add(orderCategory); } dr.NextResult(); 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(); foreach (YellowstonePathology.Business.ClientOrder.Model.OrderCategory orderCategory in orderCategoryCollection) { if (orderCategory.OrderCategoryId == orderType.OrderCategoryId) { orderCategory.OrderTypeCollection.Add(orderType); break; } } } } } return orderCategoryCollection; }
public YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection GetAllOrderCategories() { YellowstonePathology.Business.ClientOrder.Model.OrderCategoryCollection orderCategoryCollection = this.m_ClientOrderChannel.GetAllOrderCategories(); return(orderCategoryCollection); }