public ActionResult DetailsCustomer(string id) { var itemList = (from x in db.orders join y in db.products on x.productID equals y.productID where x.orderID.Equals(id) select new { x, y }); List <OrderProductViewModels> list = new List <OrderProductViewModels>(); foreach (var item in itemList) { OrderProductViewModels opvm = new OrderProductViewModels(); opvm.order = new order(); opvm.product = new product(); opvm.order.orderDate = item.x.orderDate; opvm.order.orderID = item.x.orderID; opvm.order.orderQuantity = item.x.orderQuantity; opvm.order.productID = item.x.productID; opvm.order.shippingAddress = item.x.shippingAddress; opvm.product.productID = item.y.productID; opvm.product.productContent = item.y.productContent; opvm.product.productName = item.y.productName; opvm.product.productPrice = item.y.productPrice; opvm.product.productQuantity = item.y.productQuantity; opvm.product.shopID = item.y.shopID; list.Add(opvm); } return(View(list)); }
public ActionResult DetailsOwner(string id) { string userid = null; if (Request.Cookies["user"] != null) { userid = Request.Cookies["user"]["userid"]; } string shopid = (from x in db.shopOwners where x.userID.Equals(userid) select x.shopID).SingleOrDefault(); var itemList = (from x in db.orders join y in db.products on x.productID equals y.productID where x.orderID.Equals(id) && y.shopID.Equals(shopid) select new { x, y }); List <OrderProductViewModels> list = new List <OrderProductViewModels>(); foreach (var item in itemList) { OrderProductViewModels opvm = new OrderProductViewModels(); opvm.order = new order(); opvm.product = new product(); opvm.order.orderDate = item.x.orderDate; opvm.order.orderID = item.x.orderID; opvm.order.orderQuantity = item.x.orderQuantity; opvm.order.productID = item.x.productID; opvm.order.shippingAddress = item.x.shippingAddress; opvm.product.productID = item.y.productID; opvm.product.productContent = item.y.productContent; opvm.product.productName = item.y.productName; opvm.product.productPrice = item.y.productPrice; opvm.product.productQuantity = item.y.productQuantity; opvm.product.shopID = item.y.shopID; list.Add(opvm); } return(View(list)); }