public ActionResult CheckOrder() { using (DayTideEntities db = new DayTideEntities()) { List <OrderRequest> orders = db.OrderRequests.ToList(); List <CartBackup> carts = db.CartBackups.ToList(); var Orders = from o in orders join c in carts on o.OrderId equals c.OrderId into table1 from c in table1.GroupBy(x => x.OrderId).Select(g => g.First()).ToList() select new Orders { Order = o, Cart = c }; return(View(Orders)); } }
public ActionResult RequestCustomization(int OrderId) { using (DayTideEntities db = new DayTideEntities()) { List <OrderRequest> orders = db.OrderRequests.ToList(); List <CartBackup> carts = db.CartBackups.ToList(); List <Product> products = db.Products.ToList(); var request = from o in orders join c in carts on o.OrderId equals c.OrderId into table1 from c in table1.Where(x => x.OrderId == OrderId).ToList() join p in products on c.ProductId equals p.ProductId into table2 from p in table2.ToList() select new Request { Order = o, Cart = c, Product = p }; return(View(request)); } }