/// <summary>
/// return data context with attached debugger
/// </summary>
private static DataClassesNewsDataContext getNewsDataContext()
{
DataClassesNewsDataContext db = new DataClassesNewsDataContext();
db.Log = new DebuggerWriter();
return(db);
}
public static IEnumerable <NEWS_ITEM> GetNews()
{
DataClassesNewsDataContext db = new DataClassesNewsDataContext();
IEnumerable <NEWS_ITEM> data = db.NEWS_ITEMs.OrderBy(e => e.TimeStamp);
return(data);
}
/// <summary>
/// Gets News, ordered by DateTime
/// </summary>
/// <returns></returns>
private static IEnumerable <NewsItem> GetNewsHelper(string cultureCode, bool isTopNews)
{
DataClassesNewsDataContext db = getNewsDataContext();
return(from val in db.NewsValues
join key in db.NewsKeys on val.NewsKeyID equals key.NewsKeyID
where val.CultureCode == cultureCode &&
key.TopNewsIndicator == isTopNews &&
key.Visible == true
orderby key.NewsDate descending
select new NewsItem()
{
ContentText = val.BodyText,
CultureCode = val.CultureCode,
NewsDate = key.NewsDate,
NewsId = key.NewsKeyID,
TitleText = val.HeaderText,
TopNews = key.TopNewsIndicator
});
}
