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