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