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