public IActionResult ServiceDetailByProductId(int additionalId, [FromBody] YachtAdditionalServiceDetailSearchModel model)
{
var result = _yachAdditionalService.AdditionalServiceDetails(additionalId, model);
if (result.IsSuccessStatusCode)
{
return(Ok(result));
}
return(BadRequest());
}
public BaseResponse <PagedList <YachtAdditionalServiceDetailModel> > AdditionalServiceDetails(int additionalId, YachtAdditionalServiceDetailSearchModel 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.YachtAdditionalServiceDetails on v.Id equals s.AdditionalServiceFid
where s.Deleted == false && v.Deleted == false && s.AdditionalServiceFid == additionalId
select new YachtAdditionalServiceDetailModel()
{
ProductFid = s.ProductFid,
AdditionalServiceFid = s.AdditionalServiceFid,
ProductName = _context.YachtMerchantProductInventories.FirstOrDefault(x => x.Id == s.ProductFid) != null ?
_context.YachtMerchantProductInventories.FirstOrDefault(x => x.Id == s.ProductFid).ProductName : string.Empty,
EffectiveDate = s.EffectiveDate,
EffectiveEndDate = s.EffectiveEndDate,
Remark = s.Remark
}).OrderBy(m => m.EffectiveDate).ThenBy(m => m.EffectiveDate);
var result = new PagedList <YachtAdditionalServiceDetailModel>(query, pageIndex, pageSize);
return(BaseResponse <PagedList <YachtAdditionalServiceDetailModel> > .Success(result));
}
catch (Exception ex)
{
return(BaseResponse <PagedList <YachtAdditionalServiceDetailModel> > .InternalServerError(message : ex.Message, fullMsg : ex.StackTrace));
}
}
