public List <TouristSiteItem> GetTouristSiteItems()
{
var retList = new List <TouristSiteItem>();
using (var context = new OHV_V3_SearchEntities())
{
var result = from obj in context.SEH_ObjektInfo
select obj;
foreach (var item in result)
{
var siteItem = new TouristSiteItem();
siteItem.Description = item.soLangBeschreibung;
siteItem.SiteName = item.soKurzBeschreibung;
siteItem.ImageThumbnailsPath = item.soImageLocation;
siteItem.SiteCode = item.soRouteObjektId;
siteItem.RegionId = item.soRegion;
siteItem.ImageThumbnailsPath = item.soImageLocation;
siteItem.PlaceId = item.soObjektId;
retList.Add(siteItem);
}
}
return(retList);
}
public TouristSiteItem GetSiteEntity(string siteCode)
{
var ret = new TouristSiteItem();
using (var context = new OHV_V3_SearchEntities())
{
var result = (from site in context.SEH_ObjektInfo
where site.soRouteObjektId == siteCode
select site).FirstOrDefault();
if (result == null)
{
return(null);
}
ret.SiteCode = result.soRouteObjektId;
ret.SiteName = result.soKurzBeschreibung.Trim();
ret.RegionId = result.soRegion;
ret.Description = result.soLangBeschreibung;
ret.PlaceId = result.soOrtId;
}
return(ret);
}
