public IActionResult SearchYachtGallery([FromQuery] YachtFileStreamSearchModel model) { var res = _yachtFileStreamService.SearchYachtGallery(model); if (res.IsSuccessStatusCode) { return(Ok(res)); } return(BadRequest()); }
//*****modified by hoangle 10-10-2019 //*****next modified by public BaseResponse <PagedList <YachtFileStreamViewModel> > GetFileStreamPaging(YachtFileStreamSearchModel searchModel) { try { var yachtIdde = Terminator.Decrypt(searchModel.YachtFId).ToInt32(); var result = (_aqYachtContext.YachtFileStreams .Where(k => k.Deleted == false && k.YachtFid == yachtIdde && k.FileTypeFid == searchModel.FileTypeFId && k.ActivatedDate <= DateTime.Now ) .Select(i => _mapper.Map <YachtFileStreams, YachtFileStreamViewModel>(i)) ); if (result != null) { return(BaseResponse <PagedList <YachtFileStreamViewModel> > .Success(new PagedList <YachtFileStreamViewModel>(result, searchModel.PageIndex, searchModel.PageSize))); } else { return(BaseResponse <PagedList <YachtFileStreamViewModel> > .NoContent()); } } catch (Exception ex) { return(BaseResponse <PagedList <YachtFileStreamViewModel> > .InternalServerError(new PagedList <YachtFileStreamViewModel>(Enumerable.Empty <YachtFileStreamViewModel>().AsQueryable(), searchModel.PageIndex, searchModel.PageSize), message : ex.Message, fullMsg : ex.StackTrace)); } }
public BaseResponse <PagedList <YachtFileStreamViewModel> > SearchYachtGallery(YachtFileStreamSearchModel model) { try { string sortString = !string.IsNullOrEmpty(model.SortString) ? model.SortString : "LastModifiedDate DESC"; var listFileType = Enum.GetValues(typeof(YachtImageTypeEnum)).Cast <YachtImageTypeEnum>().Select(x => new { Value = (int)x, Name = x.ToString() }).ToList(); var result = (from f in _context.YachtFileStreams.AsNoTracking() join t in listFileType on f.FileTypeFid equals t.Value where f.YachtFid == model.YachtId && f.Deleted == false && (model.FileTypeFid == 0 || f.FileTypeFid == model.FileTypeFid) && (model.FileCategoryFid == 0 || f.FileCategoryFid == model.FileCategoryFid) select _mapper.Map <YachtFileStreams, YachtFileStreamViewModel>(f)).OrderBy(sortString).AsQueryable(); return(BaseResponse <PagedList <YachtFileStreamViewModel> > .Success(new PagedList <YachtFileStreamViewModel>(result, model.PageIndex, model.PageSize))); } catch (Exception ex) { return(BaseResponse <PagedList <YachtFileStreamViewModel> > .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace)); } }
public BaseResponse <PagedList <YachtFileStreamViewModel> > SearchYachtFileStream(YachtFileStreamSearchModel model) { try { string sortString = !string.IsNullOrEmpty(model.SortString) ? model.SortString : "LastModifiedDate DESC"; var result = (from f in _context.YachtFileStreams.AsNoTracking() where f.YachtFid == model.YachtId && f.Deleted == false && (model.FileTypeFid == 0 || f.FileTypeFid == model.FileTypeFid) && (model.FileCategoryFid == 0 || f.FileCategoryFid == model.FileCategoryFid) select _mapper.Map <YachtFileStreams, YachtFileStreamViewModel>(f)).OrderBy(sortString).AsQueryable(); return(BaseResponse <PagedList <YachtFileStreamViewModel> > .Success(new PagedList <YachtFileStreamViewModel>(result, model.PageIndex, model.PageSize))); } catch (Exception ex) { return(BaseResponse <PagedList <YachtFileStreamViewModel> > .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace)); } }
public IActionResult GetFileStreamPaging([FromQuery] YachtFileStreamSearchModel searchModel) { var result = _yachtFileStreamService.GetFileStreamPaging(searchModel); return(Ok(result)); }