public ActionResult ShowAllProducts(string sortOrder)
{
using (var db = new Models.BeerModel())
{
var viewmodel = new ViewModels.ShowAllProductsViewModel();
viewmodel.ProductsList.AddRange(db.Products);
viewmodel = Sort(sortOrder, viewmodel);
return(View(viewmodel));
}
}
public ActionResult DeleteProduct(int id)
{
using (var entities = new Models.BeerModel())
{
var product = entities.Products.FirstOrDefault(x => x.Id == id);
entities.Products.Remove(product);
entities.SaveChanges();
return(RedirectToAction("Index", "Category"));
}
}
public ActionResult EditCategory(int id)
{
using (var entities = new Models.BeerModel())
{
var model = entities.Categories.FirstOrDefault(x => x.Id == id);
var viewmodel = new ViewModels.EditCategoryViewModel
{
Name = model.Name
};
return(View(viewmodel));
}
}
public ActionResult ViewSingleProduct(int id)
{
using (var entities = new Models.BeerModel())
{
var viewModel = new ViewModels.ViewSingleProductViewModel();
var prod = entities.Products.FirstOrDefault(x => x.Id == id);
viewModel.Description = prod.Description;
viewModel.Name = prod.Name;
viewModel.Price = prod.Price;
viewModel.PicURL = prod.PicURL;
viewModel.Id = prod.Id;
return(View(viewModel));
}
}
public ActionResult EditCategory(ViewModels.EditCategoryViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var entities = new Models.BeerModel())
{
var cat = entities.Categories.FirstOrDefault(x => x.Id == model.Id);
cat.Name = model.Name;
entities.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditProduct(int id)
{
using (var entities = new Models.BeerModel())
{
var product = entities.Products.FirstOrDefault(x => x.Id == id);
var viewModel = new EditProductViewModel
{
Id = product.Id,
Name = product.Name,
Description = product.Description,
Price = product.Price,
Category_Id = product.Category_Id,
PicURL = product.PicURL
};
SetupAvailableCatgoriesEdit(viewModel);
return(View(viewModel));
}
}
public ActionResult NewCategory(ViewModels.NewCategoryViewModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
using (var entities = new Models.BeerModel())
{
var newCat = new Category
{
Name = model.Name
};
entities.Categories.Add(newCat);
entities.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditProduct(ViewModels.EditProductViewModel modified)
{
SetupAvailableCatgoriesEdit(modified);
if (!ModelState.IsValid)
{
return(View(modified));
}
using (var entities = new Models.BeerModel())
{
var model = entities.Products.FirstOrDefault(x => x.Id == modified.Id);
model.Name = modified.Name;
model.Price = modified.Price;
model.Description = modified.Description;
model.Category_Id = modified.Category_Id;
model.PicURL = modified.PicURL;
entities.SaveChanges();
return(RedirectToAction("Index", "Category"));
}
}
