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());
}
}
