public ActionResult Accsesories() { long id = 4; var i = from t in data.Items join c in data.ItemTypes on t.TypeID equals c.ID where c.MenuID == id && t.Active == true select new { t, c }; List <HelmetsEntity> listhl = new List <HelmetsEntity>(); foreach (var info in i.ToList()) { HelmetsEntity hl = new HelmetsEntity(); hl.Name = info.t.Name; hl.Picture = info.t.Picture; hl.Quantity = info.t.Quantity; hl.Sellprice = info.t.SellPrice; hl.Status = info.t.ShortTitle; hl.Describe = info.t.Describe; listhl.Add(hl); } return(View(listhl)); }
//public ActionResult DetailProduct(long? id) //{ // var temp = data.Items.Find(id); // return View(new ItemEntity(temp)); //} public ActionResult DetailProduct(long id) { var i = from t in data.Items join c in data.ItemTypes on t.TypeID equals c.ID where t.ID.Equals(id) select t; List <HelmetsEntity> listhl = new List <HelmetsEntity>(); foreach (var info in i) { HelmetsEntity hl = new HelmetsEntity(); //var a = from t in data.Items where t.ID == hl.ID; hl.Name = info.Name; hl.Picture = info.Picture; hl.Quantity = info.Quantity; hl.Sellprice = info.SellPrice; hl.Status = info.ShortTitle; hl.Describe = info.Describe; listhl.Add(hl); } return(View(listhl)); }
//public ActionResult Helmetss() //{ // long id = 1; // var i = data.ItemTypes.Find( // var listitem=data.ItemTypes.Where(a=>a.ID==id) // var temp = db.Clients.Find(id); // var listorder = db.Orders.Where(o => o.IDClient == id); // var lissordetai = db.OrderDetails.Where(d => d.Order.IDClient == id); // ViewBag.listorder = listorder; // //ViewBag.lissordetai = lissordetai; // return View(new ClientManagerEntity(temp)); //} public ActionResult Helmets() { long id = 2; var i = from t in data.Items join c in data.ItemTypes on t.TypeID equals c.ID //join d in data.Menus on c.MenuID equals d.ID where c.MenuID == id && t.Active == true select new { t, c }; List <HelmetsEntity> listhl = new List <HelmetsEntity>(); foreach (var info in i.ToList()) { HelmetsEntity hl = new HelmetsEntity(); hl.Name = info.t.Name; hl.Picture = info.t.Picture; hl.Quantity = info.t.Quantity; hl.Sellprice = info.t.SellPrice; hl.Status = info.t.ShortTitle; hl.Describe = info.t.Describe; listhl.Add(hl); } //long id = 2; //var temp = data.Menus.Find(id); //var a = data.ItemTypes.Where(b => b.MenuID == id); //var listorder = db.Orders.Where(o => o.IDClient == id); //var lissordetai = db.OrderDetails.Where(d => d.Order.IDClient == id); //ViewBag.listorder = listorder; ////ViewBag.lissordetai = lissordetai; //return View(new ClientManagerEntity(temp)); return(View(listhl)); }