public ActionResult Index(string sort) { var model = new ViewModels.CategoryIndexViewModel(); using (var db = new EcommerceModel()) { model.Categories.AddRange(db.Categories.Select(r => new ViewModels.CategoryIndexViewModel.CategoryListViewModel { Name = r.Name, CategoryId = r.CategoryId })); } if (sort == "NamnAsc") { model.Categories = model.Categories.OrderBy(r => r.Name).ToList(); } else if (sort == "NamnDesc") { model.Categories = model.Categories.OrderByDescending(r => r.Name).ToList(); } model.CurrentSort = sort; return(View(model)); }
// GET: Product public ActionResult Index(string sort, int Id) { var model = new ViewModels.ProductIndexViewModel(); using (var db = new EcommerceModel()) { model.ProductList.AddRange(db.Products.Select(p => new ViewModels.ProductIndexViewModel.ProductListViewModel { ProductId = p.ProductId, Name = p.Name, Description = p.Description, Price = p.Price, CategoryId = p.CategoryId }).Where(p => p.CategoryId == Id)); } if (sort == "NamnAsc") { model.ProductList = model.ProductList.OrderBy(r => r.Name).ToList(); } else if (sort == "NamnDesc") { model.ProductList = model.ProductList.OrderByDescending(r => r.Name).ToList(); } model.CurrentSort = sort; return(View(model)); }
public ViewResult Search(string sortOrder, string searchString) { var model = new ProductIndexViewModel(); model.SearchAll = searchString; if (!string.IsNullOrWhiteSpace(searchString)) { using (var db = new EcommerceModel()) { model.ProductList.AddRange(db.Products .Select(x => new ProductIndexViewModel.ProductListViewModel { ProductId = x.ProductId, Name = x.Name, Description = x.Description, Price = x.Price, CategoryId = x.CategoryId })); model.ProductList = model.ProductList.Where(x => x.Name.ToUpper().Contains(searchString.ToUpper()) || x.Description.ToUpper().Contains(searchString.ToUpper())).ToList(); model = SortProducts(sortOrder, model); return(View("Search", model)); } } return(View("Search", model)); }
public ActionResult Edit(int id) { using (var db = new EcommerceModel()) { var cats = db.Categories.FirstOrDefault(p => p.CategoryId == id); var model = new ViewModels.CategoryEditViewModel { Name = cats.Name, CategoryId = cats.CategoryId, }; return(View(model)); } }
public ActionResult DeleteConfirm(int?id) { using (var db = new EcommerceModel()) { var obj = db.Categories.Find(id); if (obj != null) { db.Categories.Remove(obj); db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirm(int?id) { using (var db = new EcommerceModel()) { var obj = db.Products.Find(id); if (obj != null) { db.Products.Remove(obj); db.SaveChanges(); return(RedirectToAction("Index", "Product", new { id = obj.CategoryId })); } return(RedirectToAction("Index", "Home")); } }
public ActionResult Index() { var model = new ViewModels.CategoryIndexViewModel(); using (var db = new EcommerceModel()) { model.Categories.AddRange(db.Categories.Select(r => new ViewModels.CategoryIndexViewModel.CategoryListViewModel { Name = r.Name, CategoryId = r.CategoryId })); } return(View(model)); }
public ActionResult Delete(int?id) { using (var db = new EcommerceModel()) { var cat = db.Categories.Find(id); //new Createviewmodel för att Delete hade haft samma prop var model = new CategoryCreateViewModel { CategoryId = cat.CategoryId, Name = cat.Name }; return(View(model)); } }
public ActionResult View(int Id) { var viewModel = new ProductViewViewModel(); using (var db = new EcommerceModel()) { var product = db.Products.FirstOrDefault(p => p.ProductId == Id); viewModel.Name = product.Name; viewModel.Price = product.Price; viewModel.Description = product.Description; viewModel.CategoryId = product.CategoryId; viewModel.ProductId = product.ProductId; } return(View(viewModel)); }
public ActionResult Edit(ViewModels.CategoryEditViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new EcommerceModel()) { var cats = db.Categories.FirstOrDefault(r => r.CategoryId == model.CategoryId); cats.Name = model.Name; cats.CategoryId = model.CategoryId; db.SaveChanges(); } return(RedirectToAction("Index", "Category", new { id = model.CategoryId })); }
public ActionResult Edit(int id) { using (var db = new EcommerceModel()) { var prod = db.Products.FirstOrDefault(p => p.ProductId == id); var model = new ViewModels.ProductEditViewModel { Name = prod.Name, Description = prod.Description, Price = prod.Price, CategoryId = prod.CategoryId, ProductId = prod.ProductId, }; SetupAvailableCatagories(model); return(View(model)); } }
public ActionResult Create(ViewModels.CategoryCreateViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new EcommerceModel()) { var cat = new Models.CategoryModel { Name = model.Name, }; db.Categories.Add(cat); db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { using (var db = new EcommerceModel()) { var prod = db.Products.Find(id); //using new prodCreate, it has the same prop as if i would do a deleteviewmodel var model = new ProductCreateViewModel { ProductId = prod.ProductId, Name = prod.Name, Description = prod.Description, Price = prod.Price, CategoryId = prod.CategoryId }; return(View(model)); } }
public ActionResult Edit(ViewModels.ProductEditViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new EcommerceModel()) { var prod = db.Products.FirstOrDefault(r => r.ProductId == model.ProductId); prod.Name = model.Name; prod.Description = model.Description; prod.Price = model.Price; prod.CategoryId = model.CategoryId; db.SaveChanges(); } return(RedirectToAction("Index", "Product", new { id = model.CategoryId })); }
//SetUpAvailableCat FÖR CREATE void SetupAvailableCatagories(ViewModels.ProductCreateViewModel model) { model.AvailableCategory = new List <SelectListItem> { new SelectListItem { Value = null, Text = "..Choose a catagory.." }, }; using (var db = new EcommerceModel()) { foreach (var cat in db.Categories) { model.AvailableCategory.Add(new SelectListItem { Value = cat.CategoryId.ToString(), Text = cat.Name }); } } }
public ActionResult Create(ViewModels.ProductCreateViewModel model) { if (!ModelState.IsValid) { return(View(model)); } using (var db = new EcommerceModel()) { var pro = new Models.ProductsModel { Name = model.Name, Description = model.Description, Price = model.Price, CategoryId = model.CategoryId }; db.Products.Add(pro); db.SaveChanges(); } return(RedirectToAction("Index", "Product", new { id = model.CategoryId })); }
public ViewResult Search(string sortOrder, string searchString) { EcommerceModel db = new EcommerceModel(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.PriceSortParm = sortOrder == "Price" ? "price_desc" : "Price"; ViewBag.CurrentFilter = searchString; var prod = from s in db.Products select s; if (!String.IsNullOrEmpty(searchString)) { prod = prod.Where(p => p.Name.Contains(searchString) || p.Description.Contains(searchString)); } var prods = from p in db.Products select p; switch (sortOrder) { case "name_desc": prod = prod.OrderByDescending(s => s.Name); break; case "Price": prod = prod.OrderBy(s => s.Price); break; case "price_desc": prod = prod.OrderByDescending(s => s.Price); break; default: prod = prod.OrderBy(s => s.Name); break; } return(View(prod)); }