// GET api/Facility/5
        public facilityDTO Getfacility(int id)
        {
            facility    facility = db.facilities.Single(f => f.id == id);
            facilityDTO dto      = facility.toDTO();

            dto.room_count  = db.rooms.Count(r => r.facility_id == facility.id);
            dto.asset_count = db.assets.Count(a => a.facility_id == facility.id);
            if (facility == null)
            {
                throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
            }

            return(dto);
        }