//************************************************************* //*** Returns A List of TTB Permits Within Specified Radius *** //************************************************************* public static List <TTBWinePermit> GetTTBWinePermits(double latrad, double lngrad, int radius) { using (WOMOEntities db = new WOMOEntities()) { //List<int> permitListInt = new List<int>(); List <TTBWinePermit> permitRecordRadiusList = new List <TTBWinePermit>(); foreach (var permit in db.TTBWinePermits) { if ((permit.Lat != null) || (permit.Lng != null)) { double lat = (double)permit.Lat; double lng = (double)permit.Lng; var distance = distance2PointsAsCrowFlies(lat, lng, latrad, lngrad); //Needs to be established as a setting from the user //var radius = 30; if (distance < radius) { permitRecordRadiusList.Add(permit); } } } return(permitRecordRadiusList); } }
//************************************************************** //************************************************************** public static IEnumerable <TTBWinePermit> GetTTBWinePermitById(int winePermitId) { using (WOMOEntities db = new WOMOEntities()) { var permit = db.TTBWinePermits.FirstOrDefault(p => p.WinePermitId == winePermitId); return(new[] { permit }); } }