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"));
}
}
