public ActionResult Rename(int Id, string NewName) { using (var database = new DatabaseEntities()) { var category = database.CategoryById(Id); category.Name = NewName; database.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Index() { var viewModel = new NestedCategoryDescriptor(); using (var database = new DatabaseEntities()) { viewModel.Subcategories = new List<NestedCategoryDescriptor>(); foreach (var category in database.Categories.Where(c => c.Parent == null)) viewModel.Subcategories.Add(GenerateCategory(category)); } return View(viewModel); }
public ActionResult Index(int id) { ItemViewModel viewModel; using (var database = new DatabaseEntities()) { var item = database.ItemById(id); if (item != null) return HttpNotFound(); viewModel = new ItemViewModel(item); } return View(viewModel); }
public ActionResult Details(int id) { var downloads = new DownloadCollection(); using (var database = new DatabaseEntities()) { var item = database.ItemById(id); if (item == null) return HttpNotFound(); downloads.PrimaryItem = new ItemViewModel(item); AddDependencies(downloads, item); } return Json(downloads, JsonRequestBehavior.AllowGet); }
public ActionResult Index() { var viewModel = new WebIndexViewModel(); using (var database = new DatabaseEntities()) { var user = Membership.GetUser(); viewModel.Items = new List<Item>( from i in database.Items where i.User == user.UserName select i); } return View(viewModel); }
public ActionResult Delete(int Item) { // TODO: Move all items under this category to parent category using (var database = new DatabaseEntities()) { var category = database.CategoryById(Item); if (category != null) { database.DeleteObject(category); database.SaveChanges(); } } return RedirectToAction("Index"); }
public ActionResult Add(AddCategoryViewModel viewModel) { if (!ModelState.IsValid) return View(viewModel); var category = new Category { Name = viewModel.Name, Parent = viewModel.Parent }; using (var database = new DatabaseEntities()) { database.AddToCategories(category); database.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Add() { var viewModel = new AddCategoryViewModel(); int parentId; if (Request.QueryString["parent"] != null && int.TryParse(Request.QueryString["parent"], out parentId)) { Category parent; using (var database = new DatabaseEntities()) { parent = database.CategoryById(parentId); } if (parent != null) { viewModel.Parent = parentId; viewModel.ParentName = parent.Name; } } return View(viewModel); }
public ActionResult Category(string id) { var categories = id.Split('/'); id = categories.Last(); var viewModel = new CategoryViewModel(); using (var database = new DatabaseEntities()) { var category = database.CategoryByName(id); if (category == null) return HttpNotFound(); viewModel.Name = category.Name; if (category.Featured != null) viewModel.FeaturedItem = new ItemViewModel(category.Featured); viewModel.Items = new List<Item>(category.Items.Skip(0).Take(10)); // TODO: Pagination viewModel.Subcategories = new List<Category>(category.Children); viewModel.ParentCategory = category.ParentCategory; } return View(viewModel); }
public static Item ItemById(this DatabaseEntities database, int id) { return(database.Items.FirstOrDefault(i => i.Id == id)); }
public static Category CategoryByName(this DatabaseEntities database, string name) { return(database.Categories.FirstOrDefault(c => c.Name.ToUpper() == name.ToUpper())); }
public static Category CategoryById(this DatabaseEntities database, int id) { return(database.Categories.FirstOrDefault(c => c.Id == id)); }