//GET: Products/details public ActionResult Details(long id) { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); Product p = db.Products.Where(temp => temp.ProductId == id).FirstOrDefault(); return(View(p)); }
public ActionResult Delete(long id) { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductId == id).FirstOrDefault(); return(View(existingProduct)); }
// GET: Brands/Index public ActionResult Index() { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); List <Brand> brands = db.Brands.ToList(); return(View(brands)); }
public ActionResult Create(Product p) { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); db.Products.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: Categories/Index public ActionResult Index() { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); List <category> categories = db.categories.ToList(); return(View(categories)); }
public ActionResult Delete(long id, Product p) { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductId == id).FirstOrDefault(); db.Products.Remove(existingProduct); db.SaveChanges(); return(RedirectToAction("index", "Products")); }
// GET: Products/index public ActionResult Index(string search = "") { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); // List<Product> products = db.Products.Where(temp=>temp.CategoryId==1 && temp.Price>75000).ToList(); List <Product> products = db.Products.Where(temp => temp.ProductName.Contains(search)).ToList(); ViewBag.search = search; return(View(products)); }
public ActionResult Edit(Product p) { EFDBFirstdatabaseEntities db = new EFDBFirstdatabaseEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductId == p.ProductId).FirstOrDefault(); existingProduct.ProductName = p.ProductName; existingProduct.Price = p.Price; existingProduct.DateOfPurchase = p.DateOfPurchase; existingProduct.AvailabilityStatus = p.AvailabilityStatus; existingProduct.CategoryId = p.CategoryId; existingProduct.BrandId = p.BrandId; existingProduct.Active = p.Active; db.SaveChanges(); return(RedirectToAction("Index", "Products")); }