// GET: Orders public ActionResult Index(int? page) { IEnumerable<OrderElement> ord = new Queue<OrderElement>(); List<OrderElement> list = new List<OrderElement>(); var order = from m in db.Orders select m; var userId = User.Identity.GetUserId(); order = order.Where(s => s.UserId == userId); var users = from m in dbU.UserInfoes select m; users = users.Where(s => s.UserId == userId); ViewBag.UserName = users.First().Firstname; ViewBag.LastName = users.First().Lastname; foreach (var item in order) { var productId = item.ProductId; var product = dbP.SW_Product.Find(productId); OrderElement oE = new OrderElement(); oE.Logo = product.Logo; oE.OrderId = item.OrderId; oE.ProductId = product.IDProduct; oE.ProductName = product.Name; oE.ProductPrice = product.Price; oE.Tag = product.Tag; oE.UserId = item.UserId; oE.Date = item.Date; ord=list.AsEnumerable<OrderElement>(); list.Add(oE); } ViewBag.list = list; int pageSize = 5; int pageNumber = (page ?? 1); return View(ord.ToPagedList(pageNumber, pageSize)); }