public static GeoPoint GetGeoPointFromDB(string streetAndNumber, string zipCode, string city, string countryCode) { Data.CSBooster_DataContext csbDAC = new _4screen.CSB.DataAccess.Data.CSBooster_DataContext(Helper.GetSiemeConnectionString()); var cachedGeoPoint = csbDAC.hisp_GeoKoordinates_Get(streetAndNumber, zipCode, city, countryCode).ElementAtOrDefault(0); if (cachedGeoPoint != null) { GeoPoint geoPoint = new GeoPoint() { StreetAndNumber = cachedGeoPoint.GEO_Street, ZipCode = cachedGeoPoint.GEO_PLZ, City = cachedGeoPoint.GEO_City, Region = cachedGeoPoint.GEO_Kanton, CountryCode = cachedGeoPoint.GEO_Land, Lat = cachedGeoPoint.GEO_Breite, Long = cachedGeoPoint.GEO_Laenge, }; return(geoPoint); } else { return(null); } }
public static void StoreGeoPointInDB(GeoPoint geoPoint) { Data.CSBooster_DataContext csbDAC = new _4screen.CSB.DataAccess.Data.CSBooster_DataContext(Helper.GetSiemeConnectionString()); csbDAC.hisp_GeoKoordinates_Save(geoPoint.StreetAndNumber, geoPoint.ZipCode, geoPoint.City, geoPoint.CountryCode, geoPoint.Region, geoPoint.Lat, geoPoint.Long); }