public ActionResult Layout() { EmarketDBEntities emarketDB = new EmarketDBEntities(); var categorylist = emarketDB.Categories.ToList(); SelectList list = new SelectList(categorylist, "id", "name"); ViewBag.CategoryList = list; var record = db.Products.ToList(); return(View(record)); }
public ActionResult Search(string key) { EmarketDBEntities emarketDB = new EmarketDBEntities(); var categorylist = emarketDB.Categories.ToList(); SelectList list = new SelectList(categorylist, "id", "name"); ViewBag.CategoryList = list; //var categoryID = (from p in db.Categories // where p.name == key // select new Category { id = p.id }); var categoryID = (from p in db.Categories where p.name == key select p.id).FirstOrDefault(); // int parsed = int.Parse(categoryID); var listOfProducts = db.Products.Where(x => x.category_id == categoryID).ToList(); // SqlCommand cmd = new SqlCommand(categoryID); // int parsed = Convert.ToInt32(categoryID); // var listOfProducts = db.Products.Where(x => x.id == parsed).ToList(); return(View(listOfProducts)); }