Exemple #1
0
        public async Task <IActionResult> Create(SubCatandCatVm CatandCat)
        {
            if (ModelState.IsValid)
            {
                var doesSubCatExist = await _db.Subcategory.Include(s => s.Category)
                                      .Where(s => s.Name == CatandCat.SubCategory.Name && s.Category.Id == CatandCat.SubCategory.CategoryId)
                                      .ToListAsync();

                if (doesSubCatExist.Count() > 0)
                {
                    StatusMessage = "Sub Category exist under " + doesSubCatExist.First().Category.Name;
                }
                else
                {
                    await _db.Subcategory.AddAsync(CatandCat.SubCategory);

                    await _db.SaveChangesAsync();

                    return(RedirectToAction(nameof(Index)));
                }
            }

            SubCatandCatVm model = new SubCatandCatVm()
            {
                Categories      = await _db.Category.ToListAsync(),
                SubCategory     = CatandCat.SubCategory,
                SubCategoryList = await _db.Subcategory.OrderBy(p => p.Name).Select(p => p.Name).ToListAsync(),
                StatusMessage   = StatusMessage
            };

            return(View(model));
        }
Exemple #2
0
        public async Task <IActionResult> Create()
        {
            SubCatandCatVm subcatVm = new SubCatandCatVm()
            {
                Categories      = await _db.Category.ToListAsync(),
                SubCategory     = new Models.SubCategory(),
                SubCategoryList = await _db.Subcategory.OrderBy(p => p.Name).Select(n => n.Name).Distinct().ToListAsync(),
                StatusMessage   = null
            };

            return(View(subcatVm));
        }
Exemple #3
0
        public async Task <IActionResult> Edit(int id)
        {
            var SubCategory = await _db.Subcategory.Where(c => c.Id == id).FirstOrDefaultAsync();

            SubCatandCatVm subcatVm = new SubCatandCatVm()
            {
                Categories      = await _db.Category.ToListAsync(),
                SubCategory     = SubCategory,
                SubCategoryList = await _db.Subcategory.OrderBy(p => p.Name).Select(n => n.Name).Distinct().ToListAsync(),
                StatusMessage   = null
            };

            return(View(subcatVm));
        }
Exemple #4
0
        public async Task <IActionResult> Update(SubCatandCatVm subCat)
        {
            if (ModelState.IsValid)
            {
                var subcategory = await _db.Subcategory.Where(s => s.Id == subCat.SubCategory.Id).FirstOrDefaultAsync();

                subcategory.Name       = subCat.SubCategory.Name;
                subcategory.CategoryId = subCat.SubCategory.CategoryId;

                await _db.SaveChangesAsync();

                TempData["success"] = "The update was successful";
                return(Redirect(nameof(Edit) + "/" + subCat.SubCategory.Id));
            }

            SubCatandCatVm modelone = new SubCatandCatVm()
            {
                StatusMessage = "Error: An error has occured"
            };

            return(RedirectToAction(nameof(Edit)));
        }