Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<sLoadingList> GetOrdersforLoadingByWard(string _mywCode, DateTime _orderDate, int _periodId)
- {
- var _formattedDate = _orderDate.Date;
- List<sLoadingList> query = (from o in CateringEntities.Orders
- join i in CateringEntities.OrderItems
- on o.OrderId equals i.OrderId
- where o.LocationsLookUp.WardCode.Equals(_mywCode) &&
- DbFunctions.TruncateTime(o.Date) == _formattedDate && o.Period == _periodId
- select new sLoadingList()
- {
- ItemId = i.ItemId,
- ItemName = i.Item.ItemName,
- ItemType = i.ItemType,
- Quantity = i.Item.ItemName.Count()
- }).GroupBy(i => i.ItemId).Select(i => i.FirstOrDefault()).ToList();
- return query.ToList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement