public async Task <IActionResult> Add(Subcategory subcat)
        {
            if (ModelState.IsValid)
            {
                //using (_db)
                //{
                string   categoryName = Request.Form["CategoryName"].ToString();
                Category category     = await _db.Categories.Where(c => c.Name == categoryName).FirstOrDefaultAsync();

                Subcategory subcategory = new Subcategory();
                subcategory.Name       = subcat.Name;
                subcategory.Category   = category;
                subcategory.CategoryId = category.Id;
                await _db.AddAsync(subcategory);

                await _db.SaveChangesAsync();

                //}
                return(RedirectToAction(nameof(List)));
            }
            else
            {
                ModelState.AddModelError("", "Something is wrong!");
                return(View());
            }
        }
        public async Task <IActionResult> Add(Category cat)
        {
            if (ModelState.IsValid)
            {
                //using (_db)
                //{
                Category category = new Category();
                category.Name        = cat.Name;
                category.Description = cat.Description;
                category.Visibilty   = cat.Visibilty;
                await _db.AddAsync(category);

                await _db.SaveChangesAsync();

                //}
                return(RedirectToAction(nameof(List)));
            }
            else
            {
                ModelState.AddModelError("", "Something is wrong!");
                return(View());
            }
        }