public class FunctionsController: BaseController
    {
        [HttpGet, ODataRoute("GetAggregatedShopSales(SiteId={siteId},PeriodId={periodId})")]
        public IEnumerable<Sale> GetAggregatedShopSales(int siteId, int periodId)
        {
            var ss = Context.Sales
                .Where(s => s.SiteId == siteId && s.PeriodId == periodId)
                .GroupBy(s =>
                    new { s.DayOfWeek, Hour = s.Hour < 9 ? 9 : s.Hour > 22 ? 22 : s.Hour },
                    s => s.Qty,
                    (key, sales) => new
                    {
                        Hour = key.Hour,
                        DayOfWeek = key.DayOfWeek,
                        SiteId = siteId,
                        PeriodId = periodId,
                        Qty = sales.Sum()
                    })
                .AsEnumerable()
                .Select(g => new Sale()
                {
                    Hour = g.Hour,
                    DayOfWeek = g.DayOfWeek,
                    SiteId = g.SiteId,
                    PeriodId = g.PeriodId,
                    Qty = g.Qty
                });
            return ss;
        }

        [HttpGet, ODataRoute("RecalcWorkload(SiteId={siteId},PeriodId={periodId})")]
        public RecalcPosWorkloadResult RecalcWorkload(int siteId, int periodId)
        {
            var recalc = new RecalcItem(Context, siteId, periodId);
            return recalc.RecalcWorkload();
        }

        [HttpGet, EnableQuery, ODataRoute("GetInstancesWithOrderedZones(SiteId={siteId},DateId={dateId})")]
        public IEnumerable<RoleInShopInstance> GetInstancesWithOrderedZones(int siteId, int dateId)
        {
            var instances = Context
                .RoleInShopInstances
                .Include("Employee")
                .Include("RoleInShop")
                .Include("RoleInShop.Role")
                .Include("Zones")
                .Include("Zones.Zone")
                .Where(i => i.SiteId == siteId && i.DateId == dateId).ToList(); // IEnumerable

            foreach (var instance in instances)
            {
                instance.Zones = instance.Zones.OrderBy(z => z.SortOrder).ToList(); // сортировка вложенной коллекции, OData такого не умеет
            }

            return instances;
        }
    }