public IActionResult SearchYachtAdditionalSerivce([FromQuery] YachAdditionalServiceSearchModel model)
{
var result = _yachAdditionalService.SearchYachtAdditionalService(model);
if (result.IsSuccessStatusCode)
{
return(Ok(result));
}
return(BadRequest());
}
public BaseResponse <PagedList <YachAdditionalServiceViewModel> > SearchYachtAdditionalService(YachAdditionalServiceSearchModel model)
{
try
{
var query = (from i in _context.YachtAdditionalServices
.Where(k => !k.Deleted && k.MerchantFid == model.MerchantFid &&
(string.IsNullOrEmpty(model.Name) || k.Name.Contains(model.Name)))
select new YachAdditionalServiceViewModel()
{
Id = i.Id,
Name = i.Name,
AdditonalServiceTypeResKey = i.AdditonalServiceTypeResKey,
Remark = i.Remark,
IsActive = i.IsActive,
ActiveFrom = i.ActiveFrom,
ActiveTo = i.ActiveTo,
CountServiceDetail = _context.YachtAdditionalServiceDetails.Where(x => x.AdditionalServiceFid == i.Id).Count(),
CountServiceControl = _context.YachtAdditionalServiceControls.Where(x => x.AdditionalServiceFid == i.Id).Count(),
}).OrderByDescending(x => x.Id);
return(BaseResponse <PagedList <YachAdditionalServiceViewModel> > .Success(new PagedList <YachAdditionalServiceViewModel>(query, model.PageIndex, model.PageSize)));
}
catch
{
return(BaseResponse <PagedList <YachAdditionalServiceViewModel> > .Success(new PagedList <YachAdditionalServiceViewModel>()));
}
}
