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