public List <OrderItem> GetOrderItemsByOrder(Order order)
        {
            using var context = new project0Context(_contextOptions);
            var dbOrderItems = context.OrderItems
                               .Where(o => o.OrderId == order.OrderId)
                               .Include(o => o.Product)
                               .ToList();
            var result = new List <OrderItem>();

            foreach (var orderItem in dbOrderItems)
            {
                var newProduct = new Product()
                {
                    ProductId   = orderItem.Product.ProductId,
                    ProductName = orderItem.Product.ProductName,
                    Price       = orderItem.Product.Price
                };
                var newOrderItem = new OrderItem(orderItem.OrderId, newProduct, orderItem.Quantity, orderItem.Total)
                {
                    ItemId = orderItem.ItemId
                };
                result.Add(newOrderItem);
            }
            return(result);
        }
        public OrderItem GetOrderItemById(int id)
        {
            using var context = new project0Context(_contextOptions);
            var dbOrderItem = context.OrderItems
                              .Where(o => o.ItemId == id)
                              .Include(o => o.Product)
                              .FirstOrDefault();

            if (dbOrderItem == null)
            {
                return(null);
            }
            var newAnimal = new Product()
            {
                ProductId   = dbOrderItem.Product.ProductId,
                ProductName = dbOrderItem.Product.ProductName,
                Price       = dbOrderItem.Product.Price
            };
            var result = new OrderItem(dbOrderItem.OrderId, newAnimal, dbOrderItem.Quantity, (decimal)dbOrderItem.Total)
            {
                ItemId = dbOrderItem.ItemId
            };

            return(result);
        }
        public void UpdateProduct(Product product)
        {
            using var context = new project0Context(_contextOptions);
            var dbProduct = context.Products
                            .Where(a => a.ProductId == product.ProductId)
                            .FirstOrDefault();

            dbProduct.ProductName = product.ProductName;
            dbProduct.Price       = product.Price;
            context.SaveChanges();
        }
        public void CreateProduct(Product product)
        {
            using var context = new project0Context(_contextOptions);
            var newEntry = new Models.Product()
            {
                ProductName = product.ProductName,
                Price       = product.Price
            };

            context.Products.Add(newEntry);
            context.SaveChanges();
        }
        public void CreateInventory(Store store, Product product, int stock)
        {
            using var context = new project0Context(_context);
            var currentLocation = store;
            var currentProduct  = product;
            var newEntry        = new Models.Inventory()
            {
                StoreId   = currentLocation.StoreId,
                ProductId = currentProduct.ProductId,
                Stock     = stock
            };

            context.Inventories.Add(newEntry);
            context.SaveChanges();
        }
        public List <Product> GetAllProducts()
        {
            using var context = new project0Context(_contextOptions);
            var dbProducts = context.Products.Distinct().ToList();
            var result     = new List <Product>();

            foreach (var product in dbProducts)
            {
                var newProduct = new Product()
                {
                    ProductId   = product.ProductId,
                    ProductName = product.ProductName,
                    Price       = product.Price
                };
                result.Add(newProduct);
            }
            ;
            return(result);
        }
        public Product GetProductByName(string name)
        {
            using var context = new project0Context(_contextOptions);
            var dbProduct = context.Products
                            .Where(a => a.ProductName == name)
                            .FirstOrDefault();

            if (dbProduct == null)
            {
                return(null);
            }
            else
            {
                var newProduct = new Product()
                {
                    ProductId   = dbProduct.ProductId,
                    ProductName = dbProduct.ProductName,
                    Price       = dbProduct.Price
                };
                return(newProduct);
            }
        }
Example #8
0
        //Inventories
        // GET: Location/CreateInventory
        public IActionResult ImportProduct(int id)
        {
            if (!ModelState.IsValid)
            {
                throw new Exception("Controller Error!");
            }
            var result      = new InventoryViewModel();
            var productList = _productRepo.GetAllProducts();

            result.StoreId = id;
            result.Stock   = 1;
            foreach (var product in productList)
            {
                var newProduct = new Product()
                {
                    ProductId   = product.ProductId,
                    ProductName = product.ProductName,
                    Price       = product.Price
                };
                result.Products.Add(newProduct);
            }
            return(View(result));
        }