public bool DeleteProduct(string productId)
        {
            try
            {
                Models.Products prodObj = _context.Products.Find(productId);

                _context.Products.Remove(prodObj);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                return(false);
            }
        }
        public bool UpdateProduct(Models.Products product)
        {
            try
            {
                Products dbProduct = _context.Products.Find(product.ProductId);
                dbProduct.ProductName       = product.ProductName;
                dbProduct.QuantityAvailable = product.QuantityAvailable;
                dbProduct.Price             = product.Price;
                dbProduct.CategoryId        = product.CategoryId;

                _context.Products.Update(dbProduct);
                _context.SaveChanges();
                return(true);
            }
            catch (Exception e)
            {
                return(false);
            }
        }