public IHttpActionResult GetAllSuburbs(FilterRequest filter) { var model = _repoAddress.AsQueryable() .Select(a => new { Suburb = a.Suburb.Name }).ToList(); return(Ok(model)); }
public IHttpActionResult GetSiteAddresses(FilterRequest filter) { var model = _repoAddress.AsQueryable() .Select(a => new { Id = a.Id, Street1 = a.Street1, Suburb = a.Suburb.Name, Postcode = a.Suburb.Postcode, State = a.Suburb.State.Name }).ToList(); return(Ok(model)); }
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)); }