/// <summary>
/// Get list category and post data to show on homepage
/// Get top 6 post for each navigation
/// </summary>
/// <returns>List<NavigationViewModel></returns>
public static List <NavigationViewModel> GetListNavigationShowOnHomePage()
{
List <NavigationViewModel> _return = new List <NavigationViewModel>();
try
{
using (var _context = new TDHEntities())
{
//Return list
List <NavigationViewModel> _returnList = new List <NavigationViewModel>();
//Get data
var _list = _context.PROC_WEB_VIEW_HOME_PostByNavigation().ToList();
//Get list navigation
var _listNav = _list.Where(m => m.title.Length > 0);
foreach (var item in _listNav)
{
_returnList.Add(new NavigationViewModel()
{
Title = item.title,
Alias = item.alias,
Posts = _list.Where(m => m.id == item.id && m.title.Length == 0)
.Select(m => new PostViewModel()
{
Title = m.post_title,
Alias = m.post_alias,
Description = m.post_description,
Image = m.post_image,
CreateDate = m.post_create_date
})
.ToList()
});
}
//Return list
return(_returnList);
}
}
catch (Exception ex)
{
throw new UserException(FILE_NAME, MethodInfo.GetCurrentMethod().Name, 500, ErrorMessage.ErrorService, ex);
}
}
