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