public IActionResult SearchHotelMerchantMgt([FromQuery] HotelMerchantMgtSearchModel model) { var response = _hotelMerchantMgtService.SearchHotelMerchantMgt(model); if (response != null) { return(Ok(response)); } return(BadRequest()); }
public IPagedList <HotelMerchantMgtViewModel> SearchHotelMerchantMgt(HotelMerchantMgtSearchModel model) { var sortString = !string.IsNullOrEmpty(model.SortString) ? model.SortString : $"{nameof(HotelMerchantAqmgts.CreatedDate)} Desc"; var lstHotelMerchant = new PagedList <HotelMerchantMgtViewModel>(); var userGuid = _workContext.UserGuid; var userRoleId = _workContext.UserRoleId; var query = (from hmmgt in _dbYachtContext.YachtMerchantAqmgts.AsNoTracking() join hm in _dbYachtContext.YachtMerchants.AsNoTracking() on hmmgt.MerchantFid equals hm.Id where hmmgt.Deleted == false && hm.Deleted == false && (userRoleId == (int)UserRoleEnum.YachtMerchantManager ? hmmgt.AqadminUserFid == userGuid : true) && (string.IsNullOrEmpty(model.AqadminUserFid) || hmmgt.AqadminUserFid.ToString().Contains(model.AqadminUserFid)) && (model.MerchantFid == 0 || hmmgt.MerchantFid == model.MerchantFid) && (string.IsNullOrEmpty(model.EffectiveStartDate) || Convert.ToDateTime(model.EffectiveStartDate) <= hmmgt.EffectiveStartDate) && (string.IsNullOrEmpty(model.EffectiveEndDate) || Convert.ToDateTime(model.EffectiveEndDate) >= hmmgt.EffectiveEndDate) select _mapper.Map <HotelMerchantMgtViewModel>(hmmgt)).OrderBy(sortString).AsQueryable(); if (query.Count() > 0) { lstHotelMerchant = new PagedList <HotelMerchantMgtViewModel>(query, model.PageIndex, model.PageSize); } return(lstHotelMerchant); }