public IEnumerable <TaxPaymentReceipt> GetAllTaxPaymentReceipts(
decimal parcelNumber, decimal parcelExtension, int taxyear, out int resultCount, int pageNumber = 1, int pageSize = 50)
{
var results = new List <TaxPaymentReceipt>();
var query = from transaction in _context.TreasallPropertyTaxReceivableTransactions
where ((parcelNumber <= 0) || transaction.ParcelNumber == parcelNumber) &&
((parcelExtension <= 0) || transaction.ParcelExtension == parcelExtension) &&
((taxyear <= 0) || transaction.TaxYear == taxyear)
select TaxReceiptMapper.Map(transaction)
;
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 AffadavitReceiptDetails AffadavitReceiptDetails(int affadavitReceiptId)
{
var query = (from receipt in _context.TreastenderAffadavits
join cashReceipt in _context.TreascashReceiptsTender
on new { receipt.TranYear, receipt.ReceiptTranNumber } equals new { cashReceipt.TranYear, cashReceipt.ReceiptTranNumber }
into cashReceiptJoin
from cashReceiptRecord in cashReceiptJoin.DefaultIfEmpty()
join codeArea in _context.AsmttaxCodeArea on receipt.TaxCodeArea equals codeArea.TaxCodeArea
into codeAreaJoin
from codeAreaRecord in codeAreaJoin.DefaultIfEmpty()
where receipt.Id == affadavitReceiptId
select new
{
AffadavitReceipt = receipt,
CashReceipt = cashReceiptRecord,
CodeArea = codeAreaRecord
}).FirstOrDefault();
var affadavitParcels = (from receipt in _context.TreastenderAffadavits
join valueMaster in _context.AsmtrealPropertyAssessedValueMaster on receipt.ParcelNumber equals valueMaster.ParcelNumber
join nameAddress in _context.AsmtmasterNameAddress
on valueMaster.TitleOwnerCode equals nameAddress.NameCode
join legalDescription in _context.AsmtfullLegalDescription.Where(t => t.SequenceNumber == 1)
on receipt.ParcelNumber equals legalDescription.ParcelNumber
into legalDescriptionJoin
from legalDescriptionRecord in legalDescriptionJoin.DefaultIfEmpty()
where receipt.ReceiptTran == query.AffadavitReceipt.ReceiptTran
select TaxReceiptMapper.MapToParcel(receipt, valueMaster, nameAddress, legalDescriptionRecord)
).ToList();
return(TaxReceiptMapper.MapToDetails(query.AffadavitReceipt, query.CashReceipt, query.CodeArea, affadavitParcels));
}
public IEnumerable <GeneralReceipt> GetAllGeneralReceipts(decimal receiptNumber, out int resultCount, int pageNumber = 1, int pageSize = 50)
{
var results = new List <GeneralReceipt>();
var query = from transaction in _context.TreastenderGeneralReceipts
where ((receiptNumber <= 0) || transaction.ReceiptTranNumber == receiptNumber)
select TaxReceiptMapper.Map(transaction)
;
if (pageNumber > 0)
{
resultCount = query.Count();
results = query.Skip((pageNumber - 1) * pageSize)
.Take(pageSize)
.OrderBy(t => t.ReceiptNumber)
.ToList();
}
else
{
results = query.OrderBy(t => t.ReceiptNumber)
.ToList();
resultCount = results.Count();
}
return(results);
}
public IEnumerable <AffadavitReceipt> GetAllAffadavitReceipts(
decimal minParcelNumber, decimal?maxParcelNumber, decimal minAffidavitNumber, decimal?maxAffidavitNumber, out int resultCount, int pageNumber = 1,
int pageSize = 50)
{
var results = new List <AffadavitReceipt>();
// if Max TransactionNumber is null or zero, make it same as Min value as if "single" value was provided
if (!maxParcelNumber.HasValue || maxParcelNumber.Value == 0)
{
maxParcelNumber = minParcelNumber;
}
if (!maxAffidavitNumber.HasValue || maxAffidavitNumber.Value == 0)
{
maxAffidavitNumber = minAffidavitNumber;
}
var query = from receipt in _context.TreastenderAffadavits
where ((minParcelNumber <= 0) || receipt.ParcelNumber >= minParcelNumber) &&
((maxParcelNumber <= 0) || receipt.ParcelNumber <= maxParcelNumber) &&
((minAffidavitNumber <= 0) || receipt.ReceiptTran >= minAffidavitNumber) &&
((maxAffidavitNumber <= 0) || receipt.ReceiptTran <= maxAffidavitNumber) &&
(receipt.TotalPaid > 0)
select TaxReceiptMapper.Map(receipt);
if (pageNumber > 0)
{
resultCount = query.Count();
results = query.Skip((pageNumber - 1) * pageSize)
.Take(pageSize)
.OrderBy(t => t.AffidavitDate)
.ToList();
}
else
{
results = query.OrderBy(t => t.AffidavitDate)
.ToList();
resultCount = results.Count();
}
return(results);
}
public TaxReceiptDetails Details(decimal receiptNumber)
{
var cashReceipts = (from x in _context.TreascashReceiptsTender
where x.ReceiptTranNumber == receiptNumber
select TaxReceiptMapper.Map(x)).ToList();
var generalReceipts = (from x in _context.TreastenderGeneralReceipts
where x.ReceiptTranNumber == receiptNumber
select TaxReceiptMapper.Map(x)).ToList();
var affadavitReceipts = (from x in _context.TreastenderAffadavits
where x.ReceiptTranNumber == receiptNumber &&
x.TotalPaid > 0
select TaxReceiptMapper.Map(x)).ToList();
IEnumerable <DateTime> receiptDates = cashReceipts.Select(x => x.ReceiptDate.Value);
var propertyTransactions = GetPropertyTaxReceivableTransactions(receiptNumber, receiptDates);
return(new TaxReceiptDetails(receiptNumber, cashReceipts, generalReceipts, affadavitReceipts, propertyTransactions));
}
