Example #1
0
        public IHttpActionResult GetCustomersPerSuburb(FilterRequest filter)
        {
            var model = _repoSite.AsQueryable()
                        .Select(s => new
            {
                Customer = new List <int>()
                {
                    s.Site.CustomerId
                },
                Suburb = new List <char>()
                {
                    s.Site.Address.Suburb.Name
                },
                //need to Fetch customer count for CustomerSite where its equal to a  == zone
            }).ToList();

            return(Ok(model));
        }
Example #2
0
 public IQueryable <Site> AsQueryable()
 {
     return(_repoSite.AsQueryable());
 }