//This method gets all records in tbl_news which has parent name == Constants.NEWS_CATEGORY_NAME_POLICY
public List <Models.tbl_new> getListAllPolicy(Models.DataClassesDataContext data)
{
Models.tbl_news_category newsCategory = getOneNewsCategory(data, Constants.NEWS_CATEGORY_NAME_POLICY);
return(data.tbl_news.OrderByDescending(a => a.date_added).Where(n => n.parent.Value == newsCategory.id).ToList());
}
public Models.tbl_news_category getNewsCategoryById(Models.DataClassesDataContext data, int id)
{
Models.tbl_news_category result = data.tbl_news_categories.Where(n => n.id == id).Single();
return(result);
}
