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