public IList<News> GetNews(SiteLanguage siteLanguage, DateTime currentDate, int rowCount)
        {
            return NHibernateHelper.GetCurrentSession()
                .CreateQuery("select n from News as n inner join n.SiteLanguage as s " +
                " where s.ID = :SiteLanguageID and :CurrentDate between coalesce(n.StartDate, :CurrentDate) and coalesce(n.EndDate, :CurrentDate) ")
                .SetParameter("SiteLanguageID", siteLanguage.ID)
                .SetParameter("CurrentDate", currentDate)
                .SetMaxResults(rowCount)
                .List<News>();
        }