public IPagedList <YachtTourCategoryViewModel> Search(YachtTourCategorySearchModel model) { try { var sortString = !string.IsNullOrEmpty(model.SortString) ? model.SortString : "ActivatedDate DESC"; var commonLang = _dbConfigContext.CommonLanguages.Where(x => !x.Deleted).ToList(); var query = (from i in _dbYachtContext.YachtTourCategories .Where(k => !k.Deleted) select new YachtTourCategoryViewModel() { Id = i.Id, DefaultName = i.DefaultName, ResourceKey = i.ResourceKey, IsActivated = i.IsActivated, ActivatedDate = i.ActivatedDate, LanguagesSupported = (from d in _dbYachtContext.YachtTourCategoryInfomations join l in commonLang on d.LanguageFid equals l.Id where !d.Deleted && d.TourCategoryFid == i.Id select l.ResourceKey).ToList() }).OrderBy(x => x.OrderBy); var result = new PagedList <YachtTourCategoryViewModel>(query, model.PageIndex, model.PageSize); if (result != null) { return(result); } return(new PagedList <YachtTourCategoryViewModel>()); } catch { throw; } }
public IActionResult SearchYachtMerchants([FromQuery] YachtTourCategorySearchModel searchModel = null) { try { var result = _yachtTourCategoryService.Search(searchModel); if (result.Data != null) { return(Ok(result)); } return(NoContent()); } catch (Exception ex) { return(BadRequest(ex.StackTrace.ToString())); } }