public IActionResult Products() { AddNewOrRef modelobject = new AddNewOrRef(); List <Product> AllProducts = _db.Products.ToList(); modelobject.Products = AllProducts; return(View(modelobject)); }
public IActionResult Categories() { AddNewOrRef modelobject = new AddNewOrRef(); List <Category> AllCategories = _db.Categories.OrderByDescending(p => p.Name).ToList(); modelobject.Categories = AllCategories; return(View(modelobject)); }
public IActionResult AddToProduct(int id, AddNewOrRef formobject) { if (ModelState.IsValid && formobject.Relationship != null) { formobject.Relationship.ProductId = id; _db.Add(formobject.Relationship); _db.SaveChanges(); return(RedirectToAction("Product", new { id = formobject.Relationship.ProductId })); } return(RedirectToAction("Products")); }
public IActionResult NewProduct(AddNewOrRef formobject) { if (ModelState.IsValid) { _db.Add(formobject.Product); _db.SaveChanges(); return(RedirectToAction("Products")); } AddNewOrRef modelobject = new AddNewOrRef(); List <Product> AllProducts = _db.Products.OrderByDescending(p => p.Price).ToList(); modelobject.Products = AllProducts; return(View("Products", modelobject)); }
public IActionResult NewCategory(AddNewOrRef formobject) { if (ModelState.IsValid) { _db.Add(formobject.Category); _db.SaveChanges(); return(RedirectToAction("Categories")); } AddNewOrRef modelobject = new AddNewOrRef(); List <Category> AllCategories = _db.Categories.OrderByDescending(p => p.Name).ToList(); modelobject.Categories = AllCategories; return(View("Categories", modelobject)); }
public IActionResult Product(int id) { Product GetProductById = _db.Products .Include(c => c.Categories) .ThenInclude(pc => pc.Category) .FirstOrDefault(p => p.ProductId == id); if (GetProductById != null) { AddNewOrRef modelobject = new AddNewOrRef(); List <Category> CategoryList = _db.Categories .Include(c => c.Products) .ThenInclude(pc => pc.Product) .Where(c => !c.Products.Any(p => p.ProductId == id)) .ToList(); modelobject.Categories = CategoryList; modelobject.Product = GetProductById; return(View(modelobject)); } return(RedirectToAction("Products")); }
public IActionResult Category(int id) { Category GetCategoryById = _db.Categories .Include(c => c.Products) .ThenInclude(pc => pc.Product) .FirstOrDefault(c => c.CategoryId == id); if (GetCategoryById != null) { AddNewOrRef modelobject = new AddNewOrRef(); List <Product> ProductList = _db.Products .Include(c => c.Categories) .ThenInclude(pc => pc.Category) .Where(p => !p.Categories.Any(c => c.CategoryId == id)) .ToList(); modelobject.Products = ProductList; modelobject.Category = GetCategoryById; return(View(modelobject)); } return(RedirectToAction("Categories")); }