List<ren> renewedorderlist = (from ordernum in salesContext.SL_OrderIdMapper where ordernum.OrderNumber == placeOrderModel.OrderInfo.OrderID from orderDetail in salesContext.SL_OrderDetails where ordernum.OrderId == orderDetail.OrderId from renProducts in salesContext.products where renProducts.pid == orderDetail.ProductID from licenseDetails in salesContext.SL_LicenseDetails where licenseDetails.OrderDetailId == orderDetail.OrderDetailId from licenses in salesContext.SL_License where licenses.LicenseId == licenseDetails.LicenseId from oldProducts in salesContext.products where oldProducts.pid == licenses.ProductID group licenses.LicenseId by ordernum.OrderId into g select new ren { OrderId=ordernum.OrderId, OldProductName = oldProducts.productdesc, NewProductName = renProducts.productdesc, Quantity = orderDetail.Quantity, LicenseID = licenses.LicenseId.ToString() }).ToList<ren>();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)