public static CartBody GetDetailsForShoppingCart(int orderNumber) { CartBody body = new CartBody(); using (FreeMarketEntities db = new FreeMarketEntities()) { body.OrderDetails = db.GetDetailsForShoppingCart(orderNumber) .Select(c => new OrderDetail { CourierName = c.CourierName, CustodianNumber = c.CustodianNumber, ItemNumber = c.ItemNumber, MainImageNumber = 0, OrderItemStatus = c.OrderItemStatus, OrderItemValue = c.OrderItemValue, OrderNumber = c.OrderNumber, PaidCourier = c.PaidCourier, PaidSupplier = c.PaidSupplier, PayCourier = c.PayCourier, PaySupplier = c.PaySupplier, Price = c.PriceOrderDetail, ProductDepartment = c.DepartmentName, ProductDescription = c.Description, ProductNumber = c.OrderDetailProductNumber, ProductPrice = c.PricePerUnit, ProductWeight = c.Weight ?? 0, Quantity = c.Quantity, Settled = false, SupplierName = c.SupplierName, SupplierNumber = c.SupplierNumber, Selected = false, SizeType = c.SizeType } ).ToList(); if (body.OrderDetails != null && body.OrderDetails.Count > 0) { foreach (OrderDetail detail in body.OrderDetails) { int imageNumber = db.ProductPictures .Where(c => c.ProductNumber == detail.ProductNumber && c.Dimensions == PictureSize.Small.ToString()) .Select(c => c.PictureNumber) .FirstOrDefault(); detail.MainImageNumber = imageNumber; } } } Debug.Write(body); return(body); }