public static List <vwAccountLevels> GetAccountLevels(int accountId) { using (GovHacSpatialEntities entities = new GovHacSpatialEntities()) { return(entities.vwAccountLevels.Where(a => a.accountId == accountId).ToList()); } }
public static IList <spGetImages_Result> GetImages(string lat, string lon, int placeMarkerId) { using (GovHacSpatialEntities entities = new GovHacSpatialEntities()) { return(entities.spGetImages(placeMarkerId, lat, lon).ToList()); } }
public static IList <spGetPlaceMarker_Result> GetPlaceMarker(string lat, string lon) { using (GovHacSpatialEntities entities = new GovHacSpatialEntities()) { return(entities.spGetPlaceMarker(lat, lon).ToList()); } }
public static string GetPlaceMarkerName(int placeMarkerId, bool shortName) { using (GovHacSpatialEntities entities = new GovHacSpatialEntities()) { string placeName = entities.PlaceMarker.Where(pm => pm.ID == placeMarkerId).Select(pm => pm.Name).FirstOrDefault(); if (!string.IsNullOrWhiteSpace(placeName)) { if (shortName) { int idx = placeName.IndexOf("("); if (idx >= 0) { string smallName = placeName.Substring(0, idx - 1); placeName = smallName; } } } return(placeName); } }