private List<OrderDetailsReportDataLine> getOrderDetails(OrderReportDataLine order)
{
var x = (from o in new QueryableEntity<Order>()
join od in new QueryableEntity<OrderDetails>() on o.OrderID equals od.OrderID
join i in new QueryableEntity<Items>() on od.ItemID equals i.ItemID
where o.OrderID == order.OrderID
select new OrderDetailsReportDataLine
{
Description = i.ItemName,
Quantity = od.Quantity,
UnitPrice = i.Price,
Amount = od.Amount
}).ToList();
return x;
}
private List<ExtraCharges> getExtraCharges(OrderReportDataLine order)
{
var y = (from o in new QueryableEntity<OrderMiscCharges>()
join m in new QueryableEntity<MiscCharge>() on o.MiscChargeID equals m.DeductionID
where o.OrderID == order.OrderID
select new ExtraCharges
{
Description = m.Description,
Amount = o.Amount
}).ToList();
return y;
}