Beispiel #1
0
        public ActionResult <string> Index(OrderHelper orderHelper)
        {
            string ret;

            try
            {
                CustomerDAO customerDAO = new CustomerDAO(_db);
                OrderDAO    orderDAO    = new OrderDAO(_db);

                Customer orderOwner = customerDAO.GetByEmail(orderHelper.Email);

                AddOrderResultHelper result = orderDAO.AddOrder(orderOwner.Id, orderHelper.Selections);

                if (result.OrderId > 0)
                {
                    ret = "Order " + result.OrderId + " is successfully saved.";

                    if (result.IsThereBackOrder)
                    {
                        ret += " Goods are backordered.";
                    }
                }
                else
                {
                    ret = "Order is not saved.";
                }
            }
            catch (Exception ex)
            {
                ret = "We encounter a problem saving order: " + ex.Message;
            }

            return(ret);
        }
        // Adds a new Order, updates both the Order and OrderLineItem table using transaction.
        // Returns the new Order entry Id.
        public AddOrderResultHelper AddOrder(int CustomerId, OrderSelectionHelper[] Selections)
        {
            int orderId = -1;

            bool isThereBackOrder = false;

            using (_db)
            {
                using (var _transaction = _db.Database.BeginTransaction())
                {
                    try
                    {
                        ProductDAO productDAO  = new ProductDAO(_db);
                        decimal    orderAmount = 0;
                        decimal    hst         = 0;

                        // Constructs a new Order object
                        Order order = new Order();
                        order.CustomerId = CustomerId;
                        order.OrderDate  = System.DateTime.Now;

                        // Finds the total amount for the order.
                        foreach (OrderSelectionHelper selection in Selections)
                        {
                            orderAmount += (selection.Item.CostPrice) * (selection.Qty); // subtotal
                            hst          = orderAmount * 0.13M;                          // hst
                            orderAmount += hst;                                          //total for that selection.
                        }
                        order.OrderAmount = orderAmount;

                        // Persists the Order object to db
                        _db.Orders.Add(order);
                        _db.SaveChanges();

                        //Saves the order line items into the db.
                        foreach (OrderSelectionHelper selection in Selections)
                        {
                            OrderLineItem orderLineItem = new OrderLineItem();
                            orderLineItem.OrderId     = order.Id; //oops
                            orderLineItem.ProductName = selection.ProductName;

                            Product product = productDAO.GetByProductName(selection.ProductName);

                            if (selection.Qty <= product.QtyOnHand)
                            {
                                //We have enough stock
                                product.QtyOnHand     -= selection.Qty;
                                product.QtyOnBackOrder = 0;

                                orderLineItem.QtySold        = selection.Qty;
                                orderLineItem.QtyOrdered     = selection.Qty;
                                orderLineItem.QtyBackOrdered = 0;
                            }
                            else
                            {
                                //We lack stock.
                                orderLineItem.QtySold        = product.QtyOnHand;
                                orderLineItem.QtyOrdered     = selection.Qty;
                                orderLineItem.QtyBackOrdered = (selection.Qty - product.QtyOnHand);

                                product.QtyOnBackOrder += (selection.Qty - product.QtyOnHand);
                                product.QtyOnHand       = 0;

                                isThereBackOrder = true;
                            }

                            productDAO.Update(product);

                            _db.OrderLineItems.Add(orderLineItem);
                            _db.SaveChanges();
                        }

                        // Commits
                        _transaction.Commit();
                        orderId = order.Id;
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                        _transaction.Rollback();
                    }
                }
            }

            AddOrderResultHelper outcome = new AddOrderResultHelper();

            outcome.OrderId          = orderId;
            outcome.IsThereBackOrder = isThereBackOrder;

            return(outcome);
        }