public async Task <IActionResult> Create(SubCategory_Category_ViewModel model)
{
if (ModelState.IsValid)
{
var Subcategoryexists = _db.SubCategory.Include(x => x.Category).Where(x => x.Name == model.SubCategory.Name && x.Category.Id == model.SubCategory.CategoryId);
if (Subcategoryexists.Count() > 0)
{
MessageError = "Error : Sub Category exists under " + Subcategoryexists.First().Category.Name + " category. Use another name";
}
else
{
_db.SubCategory.Add(model.SubCategory);
await _db.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
SubCategory_Category_ViewModel model1 = new SubCategory_Category_ViewModel()
{
CategoryList = await _db.Category.ToListAsync(),
SubCategory = model.SubCategory,
SubCategoryList = await _db.SubCategory.OrderBy(x => x.Name).Select(x => x.Name).ToListAsync(),
Message = MessageError
};
return(View(model1));
}
public async Task <IActionResult> Create()
{
SubCategory_Category_ViewModel model = new SubCategory_Category_ViewModel()
{
CategoryList = await _db.Category.ToListAsync(),
SubCategory = new Models.SubCategory(),
SubCategoryList = await _db.SubCategory.OrderBy(x => x.Name).Select(x => x.Name).Distinct().ToListAsync()
};
return(View(model));
}
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var SubCategory = await _db.SubCategory.SingleOrDefaultAsync(x => x.Id == id);
if (SubCategory == null)
{
return(NotFound());
}
SubCategory_Category_ViewModel model = new SubCategory_Category_ViewModel()
{
CategoryList = await _db.Category.ToListAsync(),
SubCategory = SubCategory,
SubCategoryList = await _db.SubCategory.OrderBy(x => x.Name).Select(x => x.Name).Distinct().ToListAsync()
};
return(View(model));
}