예제 #1
0
        public OrderData GetOrder(int id)
        {
            try
            {
                OrderData order = null;
                using (var database = new MMDatabaseEntities())
                {
                    var matchOrder = database.Orders.First((o) => o.OrderId == id);

                    order              = new OrderData();
                    order.Id           = matchOrder.OrderId;
                    order.CustomerName = matchOrder.CustomerName;
                    order.Product      = matchOrder.Product;
                    order.Quantity     = matchOrder.Quantity;
                }
                return(order);
            }
            catch (Exception e)
            {
                Logger.Error(e.Message);
                throw;
            }
        }
예제 #2
0
        public List <string> ListOrders()
        {
            var orderList = new List <string>();

            try
            {
                Logger.Info("ListOrders() has been called by client");

                using (var database = new MMDatabaseEntities())
                {
                    var orders = from order in database.Orders
                                 select order.CustomerName;

                    orderList = orders.ToList();
                }
                return(orderList);
            }
            catch (Exception e)
            {
                Logger.Error(e.Message);
                throw;
            }
        }