public void DenyAttestation(Person denyingPerson, string reason)
{
this.Attested = false;
this.Open = false;
SwarmDb.GetDatabaseForWriting().CreateFinancialValidation(FinancialValidationType.Kill,
FinancialDependencyType.ExpenseClaim, Identity,
DateTime.UtcNow, denyingPerson.Identity, this.CostTotalCents);
OutboundComm.CreateNotificationOfFinancialValidation(Budget, this.PayrollItem.Person, NetSalaryCents / 100.0, this.PayoutDate.ToString("MMMM yyyy"),
NotificationResource.Salary_Denied, reason);
FinancialTransaction transaction = FinancialTransaction.FromDependency(this);
transaction.RecalculateTransaction(new Dictionary <int, long>(), denyingPerson); // zeroes out the tx
}
public static void AutomatchAgainstUnbalancedTransactions(Organization organization)
{
// Matches unbalanced financial transactions against unclosed payouts
// Should this be in bot?
Payouts payouts = ForOrganization(organization);
FinancialTransactions transactions = FinancialTransactions.GetUnbalanced(organization);
foreach (FinancialTransaction transaction in transactions)
{
// Console.WriteLine("Looking at transaction #{0} ({1:yyyy-MM-dd}, {2:N2}).", transaction.Identity, transaction.DateTime, transaction.Rows.AmountTotal);
// First, establish that there are no similar transactions within 7 days. N^2 search.
DateTime timeLow = transaction.DateTime.AddDays(-7);
DateTime timeHigh = transaction.DateTime.AddDays(7);
bool foundCompeting = false;
foreach (FinancialTransaction possiblyCompetingTransaction in transactions)
{
if (possiblyCompetingTransaction.Rows.AmountCentsTotal == transaction.Rows.AmountCentsTotal &&
possiblyCompetingTransaction.DateTime >= timeLow &&
possiblyCompetingTransaction.DateTime <= timeHigh &&
possiblyCompetingTransaction.Identity != transaction.Identity)
{
foundCompeting = true;
// Console.WriteLine(" - Transaction #{0} ({1:yyyy-MM-dd} is competing, aborting", possiblyCompetingTransaction.Identity, possiblyCompetingTransaction.DateTime);
}
}
if (foundCompeting)
{
continue;
}
// Console.WriteLine(" - no competing transactions...\r\n - transaction description is \"{0}\".", transaction.Description);
// Console.WriteLine(" - looking for matching payouts");
int foundCount = 0;
int payoutIdFound = 0;
// As the amount of payouts grow, this becomes less efficient exponentially.
foreach (Payout payout in payouts)
{
// Ugly hack to fix cash advance payouts
DateTime payoutLowerTimeLimit = timeLow;
DateTime payoutUpperTimeLimit = timeHigh;
if (payout.AmountCents == -transaction.Rows.AmountCentsTotal &&
(payout.DependentCashAdvancesPayout.Count > 0 || payout.DependentCashAdvancesPayback.Count > 0))
{
// HACK: While PW5 doesn't have a manual-debug interface, special case for cash advances
payoutLowerTimeLimit = transaction.DateTime.AddDays(-60);
payoutUpperTimeLimit = transaction.DateTime.AddDays(60);
}
// HACK: Allow for up to 20 days beyond scheduled payment to catch tax payments
if (payout.DependentSalariesTax.Count > 0)
{
payoutLowerTimeLimit = transaction.DateTime.AddDays(-25);
payoutUpperTimeLimit = transaction.DateTime.AddDays(3); // nobody pays taxes early...
}
if (payout.ExpectedTransactionDate >= payoutLowerTimeLimit &&
payout.ExpectedTransactionDate <= payoutUpperTimeLimit &&
payout.AmountCents == -transaction.Rows.AmountCentsTotal)
{
// Console.WriteLine(" - - payout #{0} matches ({1}, {2:yyyy-MM-dd})", payout.Identity, payout.Recipient, payout.ExpectedTransactionDate);
try
{
// If this succeeds, there is a transaction already
FinancialTransaction.FromDependency(payout);
break;
}
catch (Exception)
{
// There isn't such a transaction, which is what we want
}
foundCount++;
payoutIdFound = payout.Identity;
}
}
if (foundCount == 0)
{
// Console.WriteLine(" - none found");
}
else if (foundCount > 1)
{
// Console.WriteLine(" - multiple found, not autoprocessing");
}
else
{
Payout payout = Payout.FromIdentity(payoutIdFound);
payout.BindToTransactionAndClose(transaction, null);
}
}
}
