Esempio n. 1
0
 public static void AddOrder(Order order)
 {
     Console.WriteLine(order.Total);
     OrderDb.AddOrder(order.OrderId, order.Total, order.Note,
                      order.DateTime, order.UserId);
     foreach (var entry in order.OrderEntries)
     {
         OrderEntry.AddOrderEntry(entry);
     }
 }
Esempio n. 2
0
        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())));
            }
        }
Esempio n. 3
0
        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())));
            }
        }
Esempio n. 4
0
        public static IEnumerable <OrderEntry> GetOrderEntries(string orderId)
        {
            var entriesList = OrderEntry.GetOrderEntries(orderId);

            return(entriesList);
        }
Esempio n. 5
0
 public void RemoveEntry(OrderEntry entry)
 {
     OrderEntries.Remove(entry);
 }
Esempio n. 6
0
 public void AddEntry(OrderEntry entry)
 {
     OrderEntries.Add(entry);
 }
Esempio n. 7
0
 public static void AddOrderEntry(OrderEntry entry)
 {
     OrderDb.AddOrderEntry(entry.OrderId, entry.ProductId, entry.UnitPrice, entry.Quantity,
                           entry.DiscountPercent, entry.NetPrice);
 }