public List <GetGeneratePriceListTermListDto> GetGeneratePriceListTermByTermID(int termID)//passed { var dataGroup = (from A in _msTermRepo.GetAll() join B in _msTermAddDiscRepo.GetAll() on A.Id equals B.termID into BB from B in BB.DefaultIfEmpty() where A.Id == termID orderby B.addDiscNo ascending select new GetGeneratePriceListTermListDto { termRemarks = A.remarks, discPct = B == null ? 0 : B.addDiscPct / 100, discAmt = B == null ? 0 : B.addDiscAmt, }) .ToList(); var dataResult = dataGroup.Select(x => new GetGeneratePriceListTermListDto { termRemarks = x.termRemarks, discPct = Convert.ToDouble(x.discPct.ToString("0.##")), discAmt = x.discAmt }).ToList(); return(dataResult); }