public List <Language> GetLanguagesOracle() { using (var context = new EntitiesPortalOracle()) { return(context.LANGUAGES.Select(x => new Language { LangID = x.LANG_ID, Name = x.NAME, Code = x.CODE }).ToList()); } }
public CusPoi GetPoiByIDOracle(int id) { using (var context = new EntitiesPortalOracle()) { return(context.POI_PLACES.Where(p => p.POI_PLACE_ID == id).Select(x => new CusPoi { PoiID = x.POI_PLACE_ID, Address = x.ADDRESS, PoiDesc = x.DESCRIPTION, PoiName = x.POI_PLACE_NAME, WmX = x.WM_X, WmY = x.WM_Y, Zip = x.ZIP, City = x.CITY, HouseNoumber = x.HOUSE_NUMBER }).FirstOrDefault()); } }
public List <CusPoi> GetAvailablePoiByDescriptionOracle(string keyword, int userID) { using (var context = new EntitiesPortalOracle()) { return(context.POI_PLACES.Where(p => (p.ADDRESS.ToLower().Contains(keyword.ToLower()) || p.DESCRIPTION.ToLower().Contains(keyword.ToLower()) || p.POI_PLACE_NAME.ToLower().Contains(keyword.ToLower())) && p.USER_ID == userID).Select(x => new CusPoi { PoiID = x.POI_PLACE_ID, Address = x.ADDRESS, PoiDesc = x.DESCRIPTION, PoiName = x.POI_PLACE_NAME, WmX = x.WM_X, WmY = x.WM_Y, Zip = x.ZIP, City = x.CITY, HouseNoumber = x.HOUSE_NUMBER, UserID = x.USER_ID }).ToList()); } }