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();