public ActionResult ListCategory() { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); List <Category> category = easyServiceEntities.Categories.ToList(); return(View(category)); }
public ActionResult VendorListings(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); List <VendorListing> vendorListings = easyServiceEntities.VendorListings.Where(a => a.SubCategoryId == Id).ToList(); return(View(vendorListings)); }
public ActionResult ViewListing() { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); List <VendorListing> vendorListings = easyServiceEntities.VendorListings.ToList(); return(View(vendorListings)); }
public ActionResult EditListing(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); VendorListing vendorListing = easyServiceEntities.VendorListings.Where(a => a.Id == Id).FirstOrDefault(); return(View(vendorListing)); }
public ActionResult EditCategory(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); Category category = easyServiceEntities.Categories.Where(x => x.Id == Id).FirstOrDefault(); return(View(category)); }
public ActionResult EditListing(VendorListing model) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); easyServiceEntities.Entry(model).State = EntityState.Modified; easyServiceEntities.SaveChanges(); return(RedirectToAction("ViewListing")); }
public ActionResult EditCategory(Category model) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); easyServiceEntities.Entry(model).State = EntityState.Modified; easyServiceEntities.SaveChanges(); return(RedirectToAction("ListCategory")); }
public ActionResult AddCategory(Category model) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); easyServiceEntities.Categories.Add(model); easyServiceEntities.SaveChanges(); return(RedirectToAction("ListCategory")); }
public ActionResult ListSubCategories(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); List <SubCategory> subCategory = easyServiceEntities.SubCategories.Where(a => a.CategoryId == Id).OrderBy(a => a.Name).ToList(); return(View(subCategory)); }
public ActionResult DeleteSubCategory(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); SubCategory subCategory = easyServiceEntities.SubCategories.Where(a => a.Id == Id).FirstOrDefault(); easyServiceEntities.SubCategories.Remove(subCategory); easyServiceEntities.SaveChanges(); return(RedirectToAction("ListSubCategory")); }
public ActionResult DeleteListing(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); VendorListing vendorListing = easyServiceEntities.VendorListings.Where(a => a.Id == Id).FirstOrDefault(); easyServiceEntities.VendorListings.Remove(vendorListing); easyServiceEntities.SaveChanges(); return(RedirectToAction("ViewListing")); }
public ActionResult SelectCategory() { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); ViewBag.categoryList = easyServiceEntities.Categories.OrderBy(r => r.Name).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); return(View()); }
public ActionResult EditSubCategory(int Id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); SubCategory subCategory = easyServiceEntities.SubCategories.Where(a => a.Id == Id).FirstOrDefault(); ViewBag.categoryList = easyServiceEntities.Categories.OrderBy(r => r.Name).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); return(View(subCategory)); }
public ActionResult AddListing(VendorListing model) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); var userId = easyServiceEntities.AspNetUsers.Where(a => a.UserName == User.Identity.Name).Select(x => x.Id).FirstOrDefault(); model.UserId = userId; easyServiceEntities.VendorListings.Add(model); int c = easyServiceEntities.SaveChanges(); return(RedirectToAction("ViewListing")); }
public ActionResult AddListing(SelectCategory model) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); ViewBag.categoryList = easyServiceEntities.Categories.Where(r => r.Id == model.CategoryId).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); ViewBag.subCategoryList = easyServiceEntities.SubCategories.Where(r => r.CategoryId == model.CategoryId).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); return(View()); }
public ActionResult ListSubCategory(int?categoryId) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); if (categoryId == null) { List <SubCategory> subCategories = easyServiceEntities.SubCategories.ToList(); return(View(subCategories)); } else { List <SubCategory> subCategories = easyServiceEntities.SubCategories.Where(a => a.CategoryId == categoryId).ToList(); return(View(subCategories)); } }
public ActionResult AddSubCategory(int?categoryId) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); if (categoryId == null) { ViewBag.categoryList = easyServiceEntities.Categories.OrderBy(r => r.Name).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); } else { ViewBag.categoryList = easyServiceEntities.Categories.Where(r => r.Id == categoryId).ToList().Select(rr => new SelectListItem { Value = rr.Id.ToString(), Text = rr.Name }).ToList(); } return(View()); }
public ActionResult DeleteCategory(int id) { EasyServiceEntities easyServiceEntities = new EasyServiceEntities(); bool subCategory = easyServiceEntities.SubCategories.Where(a => a.CategoryId == id).Any(); if (!subCategory) { Category category = easyServiceEntities.Categories.Where(a => a.Id == id).FirstOrDefault(); easyServiceEntities.Categories.Remove(category); easyServiceEntities.SaveChanges(); return(RedirectToAction("ListCategory")); } else { TempData["errorMessage"] = "<script>alert('There are Subcategory associated with this category, please delete those subcategory first');</script>"; return(RedirectToAction("ListCategory")); } }