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