public static IEnumerable <Order> GetOrders(string orderId = "%", string dateTime = "",
string note = "")
{
var reader = OrderDb.GetOrders(orderId, dateTime, note).CreateDataReader();
while (reader.Read())
{
yield return(new Order(
int.Parse(reader["Order_ID"].ToString()),
int.Parse(reader["User_ID"].ToString()),
OrderEntry.GetOrderEntries(reader["Order_ID"].ToString()).ToList()
/*GetOrderEntries(orderId).ToList()*/ /*meth is below*/,
reader["Note"].ToString(),
DateTime.Parse(reader["DateTime"].ToString())));
}
}
public static IEnumerable <CreditOrder> GetCreditOrders(string orderId = "", string customerId = "",
string dateTime = "", string note = "")
{
var reader = OrderDb.GetCreditOrders(orderId, customerId, dateTime, note).CreateDataReader();
while (reader.Read())
{
yield return(new CreditOrder(
int.Parse(reader["Order_ID"].ToString()),
int.Parse(reader["User_ID"].ToString()),
OrderEntry.GetOrderEntries(reader["Order_ID"].ToString()).ToList(),
reader["Note"].ToString(),
DateTime.Parse(reader["DateTime"].ToString()),
int.Parse(reader["Customer_ID"].ToString())));
}
}
public static IEnumerable <OrderEntry> GetOrderEntries(string orderId)
{
var entriesList = OrderEntry.GetOrderEntries(orderId);
return(entriesList);
}
