public List <AssociatedPersonMain> GetAssociatedPersonMain(decimal?parcelNumber, string nameCode , out int resultCount, int pageNumber = 1, int pageSize = 50) { List <AssociatedPersonMain> results = new List <AssociatedPersonMain>(); var query = from RPASC in _context.AsmtrealPropertyAssociatedPersons where ((parcelNumber == null) || (parcelNumber == 0) || (RPASC.ParcelNumber == parcelNumber)) && ((nameCode == null) || (RPASC.NameCode == nameCode)) select AssociatedPersonMapper.Map(RPASC); if (pageNumber > 0) { resultCount = query.Count(); results = query.Skip((pageNumber - 1) * pageSize) .Take(pageSize) .OrderBy(t => t.ParcelNumber) .ToList(); } else { results = query.OrderBy(t => t.ParcelNumber) .ToList(); resultCount = results.Count(); } return(results); }
public AssociatedPerson GetAssociatedPerson(decimal?parcelNumber, string nameCode) { var rpasc = _context.AsmtrealPropertyAssociatedPersons.Where(t => ((parcelNumber == null) || (parcelNumber == 0) || (t.ParcelNumber == parcelNumber)) && ((nameCode == null) || (t.NameCode == nameCode))).FirstOrDefault(); var nnamejoinedRpasc = _context.AsmtmasterNameAddress.FirstOrDefault(t => rpasc != null && t.NameCode == rpasc.NameCode); var rpmas = _context.AsmtrealPropertyAssessedValueMaster.Where(t => t.ParcelNumber == parcelNumber).FirstOrDefault(); var taxPayerNName = _context.AsmtmasterNameAddress.Where(t => t.NameCode == rpmas.TaxpayerCode).FirstOrDefault(); var ownerNName = _context.AsmtmasterNameAddress.Where(t => t.NameCode == rpmas.TaxpayerCode).FirstOrDefault(); var aplnd = _context.AsmtlandUseCodes.Where(t => t.LandUseCode == rpmas.LandUseCode).FirstOrDefault(); var rpzon = _context.AsmtzoneDescriptions.Where(t => t.ZoneCode == rpmas.ZoneCode).FirstOrDefault(); var aptxc = _context.AsmttaxCodeArea.Where(t => t.TaxCodeArea == rpmas.TaxCodeArea).FirstOrDefault(); var lineValues = from RPASC in _context.AsmtrealPropertyAssociatedPersons join NNAME in _context.AsmtmasterNameAddress on RPASC.NameCode equals NNAME.NameCode where ((parcelNumber == null) || (parcelNumber == 0) || (RPASC.ParcelNumber == parcelNumber)) && ((nameCode == null) || (RPASC.NameCode == nameCode)) select AssociatedPersonMapper.Map(RPASC, NNAME); lineValues = lineValues?.OrderBy(t => t.AsmtmasterNameAddressNameCode); if (rpasc != null) { var result = new AssociatedPerson(rpasc.Id, rpasc?.ParcelNumber, taxPayerNName?.Name, ownerNName?.Name, rpmas?.Description1, aplnd?.UseCodeShortDesc, rpmas?.Description2, rpmas?.Description3, rpmas?.Description4, rpmas?.Description5 , rpmas?.LienDate, rpmas?.AffidavitNumber, rpzon?.ZoneCodeDesc, aptxc?.TaxCodeDesc, rpmas?.FirePatrolAcres , rpmas?.UnimprovedLandAcres, rpmas?.ImprovedLandAcers, rpmas?.FmimprovedLandValue, rpmas?.BuildingValue , rpmas?.AffidavitTaxYear, lineValues.ToList() , nnamejoinedRpasc?.AddressLine1, nnamejoinedRpasc?.City, nnamejoinedRpasc?.State , nnamejoinedRpasc?.Zip, rpasc?.ChangeId, rpasc?.ChangeDate, rpasc.NameCode, nnamejoinedRpasc?.Name, rpasc.Comment); return(result); } return(null); }