/// <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); } }