public IActionResult ServiceControlByProductId(int additionalId, [FromBody] YachtAdditionalServiceControlSearchModel model)
{
var result = _yachAdditionalService.AdditionalServiceControls(additionalId, model);
if (result.IsSuccessStatusCode)
{
return(Ok(result));
}
return(BadRequest());
}
public BaseResponse <PagedList <YachtAdditionalServiceControlModel> > AdditionalServiceControls(int additionalId, YachtAdditionalServiceControlSearchModel model)
{
try
{
var pageSize = model.PageSize > 0 ? model.PageSize : 10;
var pageIndex = model.PageIndex > 0 ? model.PageIndex : 1;
var query = (from v in _context.YachtAdditionalServices
join s in _context.YachtAdditionalServiceControls on v.Id equals s.AdditionalServiceFid
where s.Deleted == false && v.Deleted == false && s.AdditionalServiceFid == additionalId
select new YachtAdditionalServiceControlModel()
{
YachtFid = s.YachtFid,
AdditionalServiceFid = s.AdditionalServiceFid,
YachtName = _context.Yachts.FirstOrDefault(x => x.Id == s.YachtFid) != null ?
_context.Yachts.FirstOrDefault(x => x.Id == s.YachtFid).Name : string.Empty,
EffectiveDate = s.EffectiveDate,
EffectiveEndDate = s.EffectiveEndDate,
Remark = s.Remark
}).OrderBy(m => m.EffectiveDate).ThenBy(m => m.EffectiveDate);
var result = new PagedList <YachtAdditionalServiceControlModel>(query, pageIndex, pageSize);
return(BaseResponse <PagedList <YachtAdditionalServiceControlModel> > .Success(result));
}
catch (Exception ex)
{
return(BaseResponse <PagedList <YachtAdditionalServiceControlModel> > .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace));
}
}
