private async Task CheckForVenmoDeposits()
{
while (true)
{
foreach (var workspace in Settings.SettingsObject.Workspaces.Workspaces)
{
WorkspaceInfo workspaceInfo = workspace.Value.ToObject <WorkspaceInfo>() !;
logger.LogDebug($"Processing workspace ${workspace.Key}");
MongoDatabase database = new MongoDatabase(workspace.Key, mongoDatabaseLogger);
SlackCore slackApi = new SlackCore(workspaceInfo.BotToken);
var slackUsers = await slackApi.UsersList();
List <Database.Models.VenmoUser> users = database.GetAllUsers();
foreach (var user in users)
{
if (user.YNAB != null && user.YNAB.DefaultAccount != null)
{
// Get YNAB access token
Configuration config = helperMethods.CreateConfiguration(user.YNAB.Auth !.AccessToken !);
string? ynabAccessToken = await helperMethods.CheckIfYNABAccessTokenIsExpired(user, database, new ApiClient(config));
if (ynabAccessToken == null)
{
logger.LogError($"Unable to refresh YNAB access token for {user.UserId}");
await WebhookController.SendSlackMessage(workspaceInfo, "Unable to import your Venmo deposits into YNAB because your YNAB authentication information is invalid. Please refresh it.",
user.UserId, httpClient);
continue;
}
config = helperMethods.CreateConfiguration(ynabAccessToken);
// Get Venmo access token
VenmoApi venmoApi = new VenmoApi(venmoApiLogger);
string? venmoAccessToken = await helperMethods.CheckIfVenmoAccessTokenIsExpired(user, venmoApi, database);
if (string.IsNullOrEmpty(venmoAccessToken))
{
logger.LogError($"Unable to refresh Venmo access token for {user.UserId}");
await WebhookController.SendSlackMessage(workspaceInfo,
"Unable to process scheduled Venmos as your token has expired. Please refresh it.",
user.UserId, httpClient);
continue;
}
venmoApi.AccessToken = venmoAccessToken;
logger.LogDebug($"Processing slack user {user.UserId}");
List <TransactionDetail> venmoDeposits = await GetVenmoDeposits(user, config);
if (!ShouldProcessLatestVenmoDeposit(venmoDeposits))
{
continue;
}
// (fromDate - toDate]. We can adjust which transactions get included after if the
// subtransactions total doesn't match the deposit total
DateOnly toDate = DateOnly.FromDateTime(venmoDeposits[0].Date !.Value);
DateOnly fromDate;
// if multiple deposits were made on the same day (due to Venmo transfer limits) then
// make sure we get the first deposit not on the same day
foreach (var deposit in venmoDeposits)
{
fromDate = DateOnly.FromDateTime(deposit.Date !.Value);
if (fromDate != toDate)
{
break;
}
}
fromDate = fromDate.AddDays(1);
var venmoTransactions = await GetVenmoTransactionsBetweenDates(fromDate, toDate, venmoApi, user);
TransactionDetail ynabDeposit = venmoDeposits[0];
SaveTransaction? newTransaction = null;
List <SaveSubTransaction> subTransactions = new List <SaveSubTransaction>();
VenmoTransaction? previousTransaction = null;
decimal originalDepositAmount = 0;
decimal depositAmount = 0;
bool multipleTransfers = false;
foreach (VenmoTransaction transaction in venmoTransactions)
{
if (previousTransaction == null)
{
depositAmount = transaction.Transfer !.Amount;
originalDepositAmount = depositAmount;
}
else
{
if (previousTransaction.Type == "transfer" && transaction.Type == "transfer")
{
multipleTransfers = true;
depositAmount += transaction.Transfer !.Amount;
originalDepositAmount = depositAmount;
}
if (transaction.Type == "payment")
{
if (previousTransaction.Type == "transfer" && multipleTransfers)
{
long milliunitAmount = (long)(depositAmount * 1000m);
string importId = $"YNAB:{milliunitAmount}:{ynabDeposit.Date:yyyy-MM-dd}";
newTransaction = new SaveTransaction(ynabDeposit.AccountId, ynabDeposit.Date,
amount: milliunitAmount, ynabDeposit.PayeeId, ynabDeposit.PayeeName,
ynabDeposit.CategoryId, memo: null, golf1052.YNABAPI.HelperMethods.ClearedEnum.Uncleared,
ynabDeposit.Approved, ynabDeposit.FlagColor, importId: importId,
subTransactions);
}
if (depositAmount - transaction.Payment !.Amount > 0)
{
string?memo = transaction.Payment.Note;
Guid? categoryId = null;
if (user.YNAB.Mapping != null && user.YNAB.Mapping.Count > 0 && memo != null)
{
foreach (var mapping in user.YNAB.Mapping)
{
if (mapping.VenmoNote.Equals(memo, StringComparison.InvariantCultureIgnoreCase))
{
categoryId = new Guid(mapping.CategoryId);
break;
}
}
}
var subTransaction = new SaveSubTransaction(amount: (long)(transaction.Payment.Amount * 1000),
payeeId: null, payeeName: null, categoryId: categoryId, memo);
subTransactions.Add(subTransaction);
depositAmount -= transaction.Payment.Amount;
}
}
}
previousTransaction = transaction;
}
if (depositAmount > 0)
{
var unknownSubTransaction = new SaveSubTransaction(amount: (long)(depositAmount * 1000),
payeeId: null, payeeName: null, categoryId: null, memo: "UNKNOWN");
subTransactions.Add(unknownSubTransaction);
}
TransactionsApi transactionsApi = new TransactionsApi(config);
if (multipleTransfers)
{
// we created a new transaction so POST it
var createTransactionsResponse = await transactionsApi.CreateTransactionAsync(Default,
new SaveTransactionsWrapper(newTransaction));
// then "delete" the other transfers
List <UpdateTransaction> transactionsToDelete = new List <UpdateTransaction>();
for (int i = 0; i < venmoDeposits.Count; i++)
{
TransactionDetail transactionDetail = venmoDeposits[i];
VenmoTransaction venmoTransaction = venmoTransactions[i];
if (venmoTransaction.Type != "transfer")
{
break;
}
UpdateTransaction updateTransaction = new UpdateTransaction(transactionDetail.AccountId,
transactionDetail.Date, transactionDetail.Amount, transactionDetail.PayeeId,
transactionDetail.PayeeName, transactionDetail.CategoryId,
memo: $"<DELETE ME: Combined into ${originalDepositAmount:F2} Transfer from Venmo> {transactionDetail.Memo}",
golf1052.YNABAPI.HelperMethods.ClearedEnum.Uncleared,
transactionDetail.Approved, transactionDetail.FlagColor, transactionDetail.ImportId,
new List <SaveSubTransaction>());
transactionsToDelete.Add(updateTransaction);
}
var updateTransactionsResponse = await transactionsApi.UpdateTransactionsAsync(Default, new UpdateTransactionsWrapper(transactionsToDelete));
await WebhookController.SendSlackMessage(workspaceInfo,
$"Imported and created a new YNAB Venmo transaction totaling ${originalDepositAmount:F2} with " +
$"{subTransactions.Count} Venmo subtransactions combining {transactionsToDelete.Count} " +
$"transactions which occured on {newTransaction!.Date:d}. " +
$"Please go into YNAB, confirm the new transaction and delete the old transactions.",
user.UserId, httpClient);
}
else
{
// we didn't create a new transaction so just PUT the existing transaction
newTransaction = new SaveTransaction(ynabDeposit.AccountId, ynabDeposit.Date,
ynabDeposit.Amount, ynabDeposit.PayeeId, ynabDeposit.PayeeName, ynabDeposit.CategoryId,
ynabDeposit.Memo, golf1052.YNABAPI.HelperMethods.ClearedEnum.Uncleared, ynabDeposit.Approved,
ynabDeposit.FlagColor, ynabDeposit.ImportId, subTransactions);
var response = await transactionsApi.UpdateTransactionAsync(Default, ynabDeposit.Id,
new SaveTransactionWrapper(newTransaction));
await WebhookController.SendSlackMessage(workspaceInfo,
$"Updated a YNAB Venmo transaction with {subTransactions.Count} Venmo subtransactions which occured" +
$"on {newTransaction.Date:d}. Please go into YNAB and confirm the updated transaction.",
user.UserId, httpClient);
}
}
}
}
await Task.Delay(CheckDuration.ToTimeSpan());
}
}