public RealPropertyLegalDocument GetByParcelNumber(decimal parcelNumber)
{
var realproperty = (from namesRecord in _context.ASMTValueMasterNameView
join valueMasterRecord in _context.AsmtrealPropertyAssessedValueMaster on namesRecord.Id equals valueMasterRecord.Id
join codeArea in _context.AsmttaxCodeArea on namesRecord.TaxCodeArea equals codeArea.TaxCodeArea
join landUseCode in _context.AsmtlandUseCodes on valueMasterRecord.LandUseCode equals landUseCode.LandUseCode
where namesRecord.ParcelNumber == parcelNumber
select new { namesRecord, codeArea, valueMasterRecord, landUseCode }).SingleOrDefault();
if (realproperty != null)
{
var query = (from legalDocument in _context.AsmtlegalDocuments
join exciseTaxData in _context.AsmtsalesAndExciseTaxData
on new
{
legalDocument.ParcelNumber,
}
equals new
{
exciseTaxData.ParcelNumber,
}
where legalDocument.ParcelNumber == parcelNumber &&
legalDocument.RecordCode != "*" && exciseTaxData.RecordCode != "*"
orderby legalDocument.LegalInstrumentDate
select new
{
LegalDocumentRecord = legalDocument,
ExciseTaxDataRecord = exciseTaxData
})
.ToList();
var legalDocs =
query.GroupBy(
g => g.LegalDocumentRecord,
g => g.ExciseTaxDataRecord,
(legalDocument, exciseTaxData)
=> LegalDocumentMapper.Map(
legalDocument,
exciseTaxData.FirstOrDefault(x => x.AffidavitNumber == legalDocument.AffidavitNumber &&
x.AffidavitNumberExtension == legalDocument.AffidavitNumberExtension))
).ToList();
return(LegalDocumentMapper.Map(realproperty.valueMasterRecord,
realproperty.namesRecord,
realproperty.codeArea,
realproperty.landUseCode,
legalDocs));
}
return(null);
}
public LegalDocumentDetails Details(int legalDocumentId)
{
var query = (from legalDocument in _context.AsmtlegalDocuments
join namesRecord in _context.ASMTValueMasterNameView on legalDocument.ParcelNumber equals namesRecord.ParcelNumber
join valueMasterRecord in _context.AsmtrealPropertyAssessedValueMaster on namesRecord.Id equals valueMasterRecord.Id
join codeArea in _context.AsmttaxCodeArea on namesRecord.TaxCodeArea equals codeArea.TaxCodeArea
join landUseCode in _context.AsmtlandUseCodes on valueMasterRecord.LandUseCode equals landUseCode.LandUseCode
join exciseTaxData in _context.AsmtsalesAndExciseTaxData
on new
{
legalDocument.ParcelNumber,
legalDocument.AffidavitNumber,
legalDocument.AffidavitNumberExtension,
legalDocument.LegalInstrumentDate,
}
equals new
{
exciseTaxData.ParcelNumber,
exciseTaxData.AffidavitNumber,
exciseTaxData.AffidavitNumberExtension,
LegalInstrumentDate = exciseTaxData.SaleDate
}
into exciseTaxDataJoin
from exciseTaxDataRecord in exciseTaxDataJoin.DefaultIfEmpty()
join rejection in _context.AsmtsalesRejectionReasonCodes on exciseTaxDataRecord.SaleRejectionCode equals rejection.SaleRejectionCode
into rejectionJoin
from defaultRejection in rejectionJoin.DefaultIfEmpty()
join instrument in _context.AsmtinstrumentType on legalDocument.LegalDocumentType equals instrument.InstrumentCode
into instrumentJoin
from defaultInstrument in instrumentJoin.DefaultIfEmpty()
where legalDocument.Id == legalDocumentId
select new { namesRecord, codeArea, valueMasterRecord, landUseCode, exciseTaxDataRecord, legalDocument, defaultInstrument, defaultRejection }
).FirstOrDefault();
if (query != null)
{
return(LegalDocumentMapper.Map(query.valueMasterRecord,
query.namesRecord,
query.legalDocument,
query.codeArea,
query.landUseCode,
query.exciseTaxDataRecord,
query.defaultInstrument,
query.defaultRejection));
}
return(null);
}