public SearchMasterDataUnitEntity GetSearchMasterDataUnitEntity(int id)
{
var ret = new SearchMasterDataUnitEntity();
using (var context = new OHV_V3_SearchEntities())
{
var result = (from unit in context.SEH_UnitInfo
where unit.suUnitId == id
select unit).FirstOrDefault();
if (result == null)
{
return(null);
}
ret.suUnitId = result.suUnitId;
ret.SiteCode = result.suSiteCode.Trim();
ret.OfferCode = result.suOfferCode.Trim();
ret.TourOperatorId = result.suTourOperator;
ret.TourOperatorCode = result.TourOperatorCode.Trim();
ret.ImagePath = "/thumbnail/" + result.suImageLocation.Trim();
ret.OfferName = result.suKurzBeschreibung.Trim();
ret.AnbieterHinweis = result.suAnbieterHinweis == null ? string.Empty : result.suAnbieterHinweis.Trim();
}
return(ret);
}
public IEnumerable <SearchMasterDataUnitEntity> GetSearchMasterDataUnitEntitys(string routeObjektId, string portalCode)
{
var list = new List <SearchMasterDataUnitEntity>();
using (var context = new OHV_V3_SearchEntities())
{
var result = from unit in context.SEH_UnitInfo
join portal in context.SEH_PortalSet
on unit.suTourOperator equals portal.TourOperator
where unit.suRouteObjektId.ToUpper() == routeObjektId.ToUpper() &&
portal.PortalCode.ToLower() == portalCode.ToLower()
orderby unit.SuSort
select new
{
unit.Id,
SuUnitId = unit.suUnitId,
TourOperator = unit.suTourOperator,
SiteCode = unit.suSiteCode,
OfferCode = unit.suOfferCode,
OfferName = unit.suKurzBeschreibung,
Description = unit.suLangBeschreibung,
ImageName = unit.suImageLocation,
RouteObjektType = unit.suRouteObjektTyp,
IsActive = unit.suIsActive
};
foreach (var item in result)
{
if (item.IsActive.Trim() == "y")
{
var smdue = new SearchMasterDataUnitEntity();
smdue.Id = item.Id;
smdue.SiteCode = item.SiteCode.Trim();
smdue.OfferCode = item.OfferCode.Trim();
smdue.TourOperatorId = item.TourOperator;
smdue.suUnitId = item.SuUnitId;
smdue.OfferName = item.OfferName.Trim();
smdue.Description = item.Description.Trim();
smdue.ImagePath = item.ImageName.Trim();
smdue.RouteObjektTyp = item.RouteObjektType.Trim();
smdue.IsActiveUnit = item.IsActive.Trim();
list.Add(smdue);
}
}
}
return(list);
}
public void UpdateSearchUnit(SearchMasterDataUnitEntity unit)
{
SEH_UnitInfo entity = DP_Search.SEH_UnitInfo.GetFirstOrDefault(m => m.suSiteCode == unit.SiteCode &&
m.suOfferCode == unit.OfferCode);
if (entity != null)
{
entity.suAngebotVon = unit.AngebotVon;
entity.suAngebotBis = unit.AngebotBis;
entity.suKurzBeschreibung = unit.OfferName;
entity.suLangBeschreibung = unit.Description;
entity.suAnbieterHinweis = unit.AnbieterHinweis;
DP_Search.SEH_UnitInfo.AddEntity(entity);
}
}
public IEnumerable <SearchMasterDataUnitEntity> GetSearchMasterDataUnitEntitys(int tourOperatorId)
{
var list = new List <SearchMasterDataUnitEntity>();
using (var context = new OHV_V3_SearchEntities())
{
var result = from unit in context.SEH_UnitInfo
where unit.suTourOperator == tourOperatorId
select new
{
unit.Id,
SuUnitId = unit.suUnitId,
angebotVon = unit.suAngebotVon,
angebotBis = unit.suAngebotBis,
TourOperator = unit.suTourOperator,
TourOperatorCode = unit.TourOperatorCode,
SiteCode = unit.suSiteCode,
OfferCode = unit.suOfferCode,
OfferName = unit.suKurzBeschreibung,
Description = unit.suLangBeschreibung,
IsActive = unit.suIsActive
};
foreach (var item in result)
{
if (item.IsActive.Trim() == "y")
{
var smdue = new SearchMasterDataUnitEntity();
smdue.Id = item.Id;
smdue.SiteCode = item.SiteCode.Trim();
smdue.OfferName = item.OfferName.Trim();
smdue.OfferCode = item.OfferCode.Trim();
smdue.Description = item.Description.Trim();
smdue.AngebotVon = item.angebotVon;
smdue.AngebotBis = item.angebotBis;
smdue.TourOperatorId = item.TourOperator;
smdue.TourOperatorCode = item.TourOperatorCode;
smdue.suUnitId = item.SuUnitId;
list.Add(smdue);
}
}
}
return(list);
}
