public async Task <IActionResult> Edit(int id, [Bind("Id,FabricId,ProductId,QtyFabricOnProduct")] ProductFabricQuantity productFabricQuantity)
        {
            //productFabricQuantity.ProductId = productFabricQuantity.Id;
            //productFabricQuantity.Id = 0;
            if (id != productFabricQuantity.Id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    var     user            = _userManger.GetUserName(HttpContext.User);
                    var     productName     = "";
                    var     productQuantity = 0;
                    var     fabricName      = "";
                    decimal fabricQuantity  = 0;
                    foreach (var item in _context.Product)
                    {
                        if (productFabricQuantity.ProductId == item.Id)
                        {
                            productName     = item.Title;
                            productQuantity = item.Quantity;
                        }
                    }
                    foreach (var item in _context.Fabric)
                    {
                        if (productFabricQuantity.FabricId == item.Id)
                        {
                            fabricName     = item.Title;
                            fabricQuantity = item.Quantity;
                        }
                    }
                    _context.Update(productFabricQuantity);
                    await _context.SaveChangesAsync();

                    logger.Info(user + " edited to " + productName + " quantity " + productQuantity + " and " + fabricName + " quantity " + fabricQuantity);
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!ProductFabricQuantityExists(productFabricQuantity.Id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction("Details", "Products", new { id = productFabricQuantity.ProductId }));
            }
            ViewData["FabricId"]  = new SelectList(_context.Fabric, "Id", "Id", productFabricQuantity.FabricId);
            ViewData["ProductId"] = productFabricQuantity.ProductId;
            return(View(productFabricQuantity));
        }
        public async Task <IActionResult> Create([Bind("Id,FabricId,ProductId,QtyFabricOnProduct")] ProductFabricQuantity productFabricQuantity)
        {
            var user = _userManger.GetUserName(HttpContext.User);
            var x    = productFabricQuantity.Id;

            productFabricQuantity.ProductId = x;
            productFabricQuantity.Id        = 0;
            var     productName     = "";
            var     productQuantity = 0;
            var     fabricName      = "";
            decimal fabricQuantity  = 0;

            foreach (var item in _context.Product)
            {
                if (productFabricQuantity.ProductId == item.Id)
                {
                    productName     = item.Title;
                    productQuantity = item.Quantity;
                }
            }
            foreach (var item in _context.Fabric)
            {
                if (productFabricQuantity.FabricId == item.Id)
                {
                    fabricName     = item.Title;
                    fabricQuantity = item.Quantity;
                }
            }
            if (ModelState.IsValid)
            {
                _context.Add(productFabricQuantity);
                await _context.SaveChangesAsync();

                logger.Info(user + " created " + productName + " with quantity of " + productQuantity + " and " + fabricName + " with quantity of " + fabricQuantity);
                return(RedirectToAction("Index"));
            }
            else
            {
                _context.Add(productFabricQuantity);
                await _context.SaveChangesAsync();

                logger.Info(user + " created " + productName + " with quantity of " + productQuantity + " and " + fabricName + " with quantity of " + fabricQuantity);
                return(RedirectToAction("Details", "Products", new { id = productFabricQuantity.ProductId }));
            }
            ViewData["FabricId"]  = new SelectList(_context.Fabric, "Id", "Title", productFabricQuantity.FabricId);
            ViewData["ProductId"] = productFabricQuantity.ProductId;
            return(View(productFabricQuantity));
        }