public IActionResult SearchYachtMerchantAccMgt([FromQuery] YachtMerchantAccMgtSearchModel searchModel)
{
try
{
var result = _yachtMerchantAccMgtService.SearchYachtMerchantAccMgt(searchModel);
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.StackTrace.ToString()));
}
}
public IPagedList <YachtMerchantAccMgtViewModel> SearchYachtMerchantAccMgt(YachtMerchantAccMgtSearchModel model)
{
try
{
var userGuid = _workContext.UserGuid;
var userRoleId = _workContext.UserRoleId;
var sortString = !string.IsNullOrEmpty(model.SortString) ? model.SortString : "CreatedDate DESC";
var query = (from ymamgt in _dbYachtContext.YachtMerchantAqmgts.AsNoTracking()
join ym in _dbYachtContext.YachtMerchants.AsNoTracking() on ymamgt.MerchantFid equals ym.Id
where ymamgt.Deleted == false && ym.Deleted == false &&
(userRoleId == (int)UserRoleEnum.YachtMerchantManager ? ymamgt.AqadminUserFid == userGuid : true) &&
(string.IsNullOrEmpty(model.UserFid) || ymamgt.AqadminUserFid.ToString().Contains(model.UserFid)) &&
(model.MerchantFid == 0 || ymamgt.MerchantFid == model.MerchantFid) &&
(string.IsNullOrEmpty(model.EffectiveStartDate) || Convert.ToDateTime(model.EffectiveStartDate) <= ymamgt.EffectiveStartDate) &&
(string.IsNullOrEmpty(model.EffectiveEndDate) || Convert.ToDateTime(model.EffectiveEndDate) >= ymamgt.EffectiveEndDate)
select _mapper.Map <YachtMerchantAccMgtViewModel>(ymamgt)).OrderBy(sortString).AsQueryable();
return(new PagedList <YachtMerchantAccMgtViewModel>(query, model.PageIndex, model.PageSize));
}
catch
{
throw;
}
}
