public static GeoPoint GetGeoPointFromDB(string streetAndNumber, string zipCode, string city, string countryCode) { Data.CSBooster_DataAccessDataContext csbDAC = new _4screen.CSB.DataAccess.Data.CSBooster_DataAccessDataContext(); 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 string GetDelimitedCommunityIDs(string delimitedCommunities, char delimiter) { string allObjs = string.Empty; if (!string.IsNullOrEmpty(delimitedCommunities)) { string allObjsToFind = string.Empty; string[] ids = delimitedCommunities.RemoveDuplicates(delimiter).Split(delimiter); foreach (string id in ids) { if (id.Length > 0) { if (id.IsGuid()) { allObjs += id + "|"; } else { allObjsToFind += string.Format("{0}|", id); } } } if (allObjsToFind.Length > 0) { allObjsToFind = allObjsToFind.TrimEnd('|'); Data.CSBooster_DataAccessDataContext csbDAC = new _4screen.CSB.DataAccess.Data.CSBooster_DataAccessDataContext(); var founsIDs = csbDAC.hisp_Community_GetIDSByVUrls(allObjsToFind); foreach (var foundID in founsIDs) { allObjs += foundID.CTY_ID.ToString() + "|"; } } if (allObjs.Length > 0) { allObjs = allObjs.TrimEnd('|'); allObjs.RemoveDuplicates('|'); } } return(allObjs); }
public static void StoreGeoPointInDB(GeoPoint geoPoint) { Data.CSBooster_DataAccessDataContext csbDAC = new _4screen.CSB.DataAccess.Data.CSBooster_DataAccessDataContext(); csbDAC.hisp_GeoKoordinates_Save(geoPoint.StreetAndNumber, geoPoint.ZipCode, geoPoint.City, geoPoint.CountryCode, geoPoint.Region, geoPoint.Lat, geoPoint.Long); }
public static void Delete(Guid comId) { _4screen.CSB.DataAccess.Data.CSBooster_DataAccessDataContext cdc = new _4screen.CSB.DataAccess.Data.CSBooster_DataAccessDataContext(ConfigurationManager.ConnectionStrings["CSBoosterConnectionString"].ConnectionString); cdc.hisp_Comments_SetCommentStatus(comId, (int?)CommentStatus.Deleted); }