public ActionResult Create(int?id)
{
var model = new ViewModels.CreateOrEditProductViewModel();
using (var db = new Models.ModelDB())
{
model.Category_Id = (int)id;
}
return(View(model));
}
public ActionResult Edit(int id)
{
using (var db = new Models.ModelDB())
{
var newCategory = db.Categories.FirstOrDefault(p => p.Id == id);
var model = new ViewModels.CreateOrEditViewModel
{
Name = newCategory.Name
};
return(View(model));
}
}
// GET: Category
public ActionResult Index()
{
var model = new ViewModels.CategoryIndexViewModel();
using (var db = new Models.ModelDB())
{
model.Categorys.AddRange(db.Categories.Select(x => new ViewModels.CategoryIndexViewModel.CategoryListViewModel
{
Id = x.Id,
Name = x.Name
}
));
}
return(View(model));
}
public ActionResult Edit(int id)
{
using (var db = new Models.ModelDB())
{
var editProduct = db.Products.FirstOrDefault(p => p.Id == id);
var model = new ViewModels.CreateOrEditProductViewModel
{
Id = editProduct.Id,
Name = editProduct.Name,
Description = editProduct.Description,
Price = editProduct.Price,
Category_Id = editProduct.Category_id
};
return(View(model));
}
}
public ActionResult Edit(ViewModels.CreateOrEditViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.ModelDB())
{
var editCategory = db.Categories.FirstOrDefault(x => x.Id == model.Id);
editCategory.Name = model.Name;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(ViewModels.CreateOrEditViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.ModelDB())
{
var newCategory = new Models.Category
{
Id = model.Id,
Name = model.Name
};
db.Categories.Add(newCategory);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult ViewAllProducts(string sort)
{
var model = new ViewModels.ProductFromCategoryViewModel();
using (var db = new Models.ModelDB())
{
model.ProductList.AddRange(db.Products.Select(x => new ViewModels.ProductFromCategoryViewModel.ProductListViewModel
{
Id = x.Id,
Name = x.Name,
Price = x.Price,
Description = x.Description,
Category_Id = x.Category_id
}));
}
SortProducts(sort, model);
return(View(model));
}
// GET: Product
public ActionResult Index(int id)
{
var model = new ViewModels.ProductFromCategoryViewModel();
using (var db = new Models.ModelDB())
{
model.CategoryId = id;
model.ProductList.AddRange(db.Products.Select(x => new ViewModels.ProductFromCategoryViewModel.ProductListViewModel
{
Id = x.Id,
Name = x.Name,
Price = x.Price,
Description = x.Description,
Category_Id = x.Category_id
}).Where(x => x.Category_Id == id));
return(View(model));
}
}
public ActionResult Edit(ViewModels.CreateOrEditProductViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.ModelDB())
{
var editProduct = db.Products.FirstOrDefault(x => x.Id == model.Id);
editProduct.Name = model.Name;
editProduct.Price = model.Price;
editProduct.Description = model.Description;
editProduct.Category_id = model.Category_Id;
db.SaveChanges();
}
return(RedirectToAction($"Index/{model.Category_Id}"));
}
public ActionResult Search(string search, string sort)
{
using (var db = new Models.ModelDB())
{
var model = new ViewModels.ProductFromCategoryViewModel
{
Search = search
};
model.ProductList.AddRange(db.Products.ToList().Select(r => new ViewModels.ProductFromCategoryViewModel.ProductListViewModel
{
Id = r.Id,
Name = r.Name,
Price = r.Price,
Description = r.Description,
Category_Id = r.Category_id
}).Where(c => c.Name.ToLower().Contains(model.Search.ToLower()) || c.Description.ToLower().Contains(model.Search.ToLower()))
);
SortProducts(sort, model);
return(View(model));
}
}
public ActionResult Create(ViewModels.CreateOrEditProductViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var db = new Models.ModelDB())
{
var prod = new Models.Product
{
Id = model.Id,
Name = model.Name,
Price = model.Price,
Description = model.Description,
Category_id = model.Category_Id,
};
db.Products.Add(prod);
db.SaveChanges();
return(RedirectToAction($"Index/{model.Category_Id}"));
}
}
