public tbl_POI SavePOI(string title, string description, int categoryID, string latitude, string longitude, string phone, int addressID, string address1, string address2, string address3, string town, string postcode, string county, string country, int[] tagsIDs, int?sitemapID, int poiID) { if (String.IsNullOrEmpty(title) || categoryID < 1 || String.IsNullOrEmpty(latitude) || String.IsNullOrEmpty(longitude) || tagsIDs == null || String.IsNullOrEmpty(address1) || String.IsNullOrEmpty(town) || String.IsNullOrEmpty(postcode) || String.IsNullOrEmpty(country)) { return(null); } var address = AddressRepository.SaveAddress((int?)null, country, (int?)null, county, String.Empty, String.Empty, String.Empty, address1, address2, address3, postcode, String.Empty, town, addressID); if (address == null) { return(null); } var poi = POIRepository.Save(title, description, categoryID, address.AddressID, latitude.Replace(',', '.'), longitude.Replace(',', '.'), phone, sitemapID, poiID); if (poi == null) { return(null); } poi = POIRepository.SaveTags(tagsIDs, poi.POIID); return(poi); }
public tbl_POI SaveTagsForPOI(int[] tagsIDs, int poiID) { if (poiID < 1 || tagsIDs == null) { return(null); } return(POIRepository.SaveTags(tagsIDs, poiID)); }
public List <tbl_POI> SearchPOIs(string search, int?categoryID, int[] tagIDs) { if (!String.IsNullOrEmpty(search)) { search = search.ToLower(); } var pois = POIRepository.GetAll().ToList().Where(p => (String.IsNullOrEmpty(search) || (p.POI_Title ?? String.Empty).ToLower().Contains(search) || (p.tbl_Address.A_County ?? String.Empty).ToLower().Contains(search) || (p.tbl_Address.A_Town ?? String.Empty).ToLower().Contains(search)) && (!categoryID.HasValue || categoryID.Value == 0 || p.POI_CategoryID == categoryID.Value) && (tagIDs == null || tagIDs.Count() == 0 || p.tbl_POITags.Any(t => tagIDs.Contains(t.POITagID))) ).ToList(); return(pois); }
public tbl_POI GetPOIByID(int poiID) { return(POIRepository.GetByID(poiID)); }
public List <tbl_POI> GetAllPOIs() { return(POIRepository.GetAll().ToList()); }
public bool DeletePOI(int poiID) { return(POIRepository.Delete(poiID)); }