public CustomerModel AddCustomer(CustomerModel appCustomer)
        {
            IQueryable <Customer> dbCustomer = _context.Customers
                                               .OrderBy(x => x.CustomerId);

            DateTime dateTime = DateTime.Now;

            var newCustomer = new Customer
            {
                FirstName       = appCustomer.FirstName,
                LastName        = appCustomer.LastName,
                StreetAddress1  = appCustomer.StreetAddress1,
                StreetAddress2  = appCustomer.StreetAddress2,
                City            = appCustomer.City,
                State           = appCustomer.State,
                Zipcode         = appCustomer.Zipcode,
                CustomerCreated = dateTime,
                DefaultStoreId  = appCustomer.DefaultStore
            };

            _context.Add(newCustomer);
            _context.SaveChanges();

            appCustomer.CustomerID = newCustomer.CustomerId;
            return(appCustomer);
        }
        public void AddOrder(OrderModel appOrder)
        {
            Order dbOrder = _context.Orders.OrderBy(x => x.OrderId).Last();

            DateTime dateTime = DateTime.Now;

            Order newOrder = new Order
            {
                CustomerId       = appOrder.CustomerNumber,
                StoreId          = appOrder.StoreID,
                NumberOfProducts = appOrder.NumberOfProducts,
                OrderTotal       = appOrder.Total,
                DatePlaced       = dateTime
            };

            _context.Add(newOrder);
            _context.SaveChanges();

            Order       dbOrderV2      = _context.Orders.OrderBy(x => x.OrderId).Last();
            OrderDetail dbOrderDetails = _context.OrderDetails.OrderBy(x => x.Id).Last();

            List <OrderDetail> orderDetailList = new List <OrderDetail>();

            foreach (var product in appOrder.Product)
            {
                OrderDetail newDetail = new OrderDetail
                {
                    OrderId   = dbOrderV2.OrderId,
                    ProductId = product.ProductId,
                    Quantity  = product.Quantity,
                    TotalCost = product.CostPerItem * product.Quantity
                };
                orderDetailList.Add(newDetail);
            }

            foreach (var lineItem in orderDetailList)
            {
                _context.Add(lineItem);
                _context.SaveChanges();
            }

            for (int prod = 0; prod < appOrder.Product.Count; prod++)
            {
                Inventory dbInventory = _context.Inventories
                                        .Include(x => x.Product)
                                        .Where(x => appOrder.StoreID == x.StoreId)
                                        .Where(x => x.Product.ProductId == appOrder.Product[prod].ProductId)
                                        .First();

                dbInventory.ProductId = appOrder.Product[prod].ProductId;
                dbInventory.Quantity -= appOrder.Product[prod].Quantity;

                _context.Update(dbInventory);
                _context.SaveChanges();
            }
        }