public List <UrlHistoryInfo> GetAllOtherUrls(Webpage webpage)
{
UrlHistoryInfo urlHistoryInfo = new UrlHistoryInfo();
IList <UrlHistoryInfo> urlHistoryInfoList =
_session.QueryOver <UrlHistory>()
.SelectList(
builder =>
builder.Select(history => history.UrlSegment)
.WithAlias(() => urlHistoryInfo.UrlSegment)
.Select(history => history.Webpage.Id)
.WithAlias(() => urlHistoryInfo.WebpageId))
.TransformUsing(Transformers.AliasToBean <UrlHistoryInfo>())
.Cacheable()
.List <UrlHistoryInfo>();
IList <UrlHistoryInfo> webpageHistoryInfoList =
_session.QueryOver <Webpage>()
.SelectList(
builder =>
builder.Select(page => page.UrlSegment)
.WithAlias(() => urlHistoryInfo.UrlSegment)
.Select(page => page.Id)
.WithAlias(() => urlHistoryInfo.WebpageId))
.TransformUsing(Transformers.AliasToBean <UrlHistoryInfo>())
.Cacheable()
.List <UrlHistoryInfo>();
return(urlHistoryInfoList.Union(webpageHistoryInfoList).Where(info => info.WebpageId != webpage.Id).ToList());
}
public List<UrlHistoryInfo> GetAllOtherUrls(Webpage webpage)
{
var urlHistoryInfo = new UrlHistoryInfo();
var urlHistoryInfoList =
_session.QueryOver<UrlHistory>()
.SelectList(
builder =>
builder.Select(history => history.UrlSegment)
.WithAlias(() => urlHistoryInfo.UrlSegment)
.Select(history => history.Webpage.Id)
.WithAlias(() => urlHistoryInfo.WebpageId))
.TransformUsing(Transformers.AliasToBean<UrlHistoryInfo>())
.Cacheable()
.List<UrlHistoryInfo>();
var webpageHistoryInfoList =
_session.QueryOver<Webpage>()
.SelectList(
builder =>
builder.Select(page => page.UrlSegment)
.WithAlias(() => urlHistoryInfo.UrlSegment)
.Select(page => page.Id)
.WithAlias(() => urlHistoryInfo.WebpageId))
.TransformUsing(Transformers.AliasToBean<UrlHistoryInfo>())
.Cacheable()
.List<UrlHistoryInfo>();
return urlHistoryInfoList.Union(webpageHistoryInfoList).Where(info => info.WebpageId != webpage.Id).ToList();
}
