public HttpResponseMessage Regions() { //returns a list of vintages using (WineDBEntities wdb = new WineDBEntities()) { var Regions = wdb.Regions; List<RegionDTO> lm = new List<RegionDTO>(); foreach (var region in Regions) { lm.Add(new RegionDTO { AreaName = region.Name, Country = region.Country, RegionId = region.RegionId }); } return Request.CreateResponse(HttpStatusCode.OK, lm); } }
public ServiceResponseMessage List(ServiceResponseMessage newRequest) { this.request = newRequest; using (WineDBEntities wdb = new WineDBEntities()) { var regions = wdb.Regions; RegionList rl = new RegionList(); rl.Regions = new List<RegionDTO>(); foreach (var rv in regions) { rl.Regions.Add(new RegionDTO() { RegionId = rv.RegionId, AreaName = rv.Name, Country = rv.Country, OldestVintage = rv.Vintages.Min(x=>x.Year)}); } request.RequestObject = rl; //request.ElapsedTime = sw.Elapsed.Milliseconds; return request; } }