public async Task <decimal> GetTotalBuys(DateTime dateTime) { var ordersForTheDay = await _ordersRepository.Find(dateTime); var orderItems = await _orderItemsRepository.GetOrderItems(); var orders = ordersForTheDay.ToList(); return((from item in orderItems from order in orders where item.OrderId.Equals(order.Id) select item.BuyPriceExVAT).Sum()); }
// GET api/OrderItems public IEnumerable <OrderItem> Get() { return(_db.GetOrderItems()); }
public IQueryable <OrderItemViewModel> GetOrderItems(Guid id) { var orderItems = _repo.GetOrderItems(id).ProjectTo <OrderItemViewModel>(_mapper.ConfigurationProvider); return(orderItems); }