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)); } }