Пример #1
0
        /// <summary>
        /// Send a console app to the database
        /// </summary>
        /// <param name="order"></param>
        public void SendGenOrderToDB(IOrder order)
        {
            // Create context
            using var context = new danielGProj0DBContext(_contextOptions);
            // Create a database GenOrder using info from the order passed into this method
            GenOrder dbGeneralOrder = new GenOrder
            {
                CustomerId = order.Customer.Id,
                StoreId    = order.Location.Id,
                Cost       = order.Cost,
                Date       = order.Date
            };

            // Add GenOrder to database and save change
            context.GenOrders.Add(dbGeneralOrder);
            context.SaveChanges();


            // From here, see the last order to get the id and update the other tables
            int lastOrder = GetAmountOfGenOrders();

            // Send the AggOrder of the products to the DB
            SendAggOrder(order, lastOrder);

            // Update the inventory of the store that had a purchase
            UpdateInventory(order);
        }
Пример #2
0
        /// <summary>
        /// Method runs when creating a new
        /// </summary>
        /// <param name="customer"></param>
        public void CreateCustomerInDb(CustomerClass customer)
        {
            // Create Context
            using var context = new danielGProj0DBContext(_contextOptions);
            // Create a database customer using info from ConsoleApp Customer
            Customer dbCustomer = new Customer
            {
                Name = customer.Name
            };

            // Add Customer to database and save change
            context.Customers.Add(dbCustomer);
            context.SaveChanges();
        }
Пример #3
0
        /// <summary>
        /// Update the inventory in the database after an order is placed
        /// </summary>
        /// <param name="order"></param>
        public void UpdateInventory(IOrder order)
        {
            // Create Context
            using var context = new danielGProj0DBContext(_contextOptions);
            // Get agg inventory items from the database- this is a stores inventory
            var itemsInInventory = context.AggInventories.Where(i => i.StoreId == order.Location.Id).ToList();

            // Iterate over the items in the order
            foreach (var item in order.Customer.ShoppingCart)
            {
                // Find the item in the list of items that are in stock at that store
                //   then decrement based on the amount ordered
                var currentItem = itemsInInventory.Find(x => x.Product == item.Key);
                currentItem.InStock -= item.Value;
            }
            // Save changes made and send to DB
            context.SaveChanges();
        }
Пример #4
0
        /// <summary>
        /// Send aggregate Order to database when an order is placed
        /// </summary>
        /// <param name="order"></param>
        /// <param name="orderID"></param>
        public void SendAggOrder(IOrder order, int orderID)
        {
            // Create Context
            using var context = new danielGProj0DBContext(_contextOptions);
            // Create the aggOrders list that need to get sent
            List <AggOrder> aggOrders = new List <AggOrder>();

            // For each value in order.customer.shoppingCart, create a single aggOrder
            //   then add that aggOrder to the database
            foreach (var product in order.Customer.ShoppingCart)
            {
                AggOrder orderDetails = new AggOrder
                {
                    OrderId = orderID,
                    Product = product.Key,
                    Amount  = product.Value
                };
                context.AggOrders.Add(orderDetails);
            }
            context.SaveChanges();
        }