/// <summary>
/// Handles the Click event of the lbSaveImage control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void lbSaveImage_Click(object sender, EventArgs e)
{
var rockContext = new RockContext();
var service = new FinancialTransactionImageService(rockContext);
var financialTransactionImage = new FinancialTransactionImage();
var transactionId = hfIdTransValue.ValueAsInt();
financialTransactionImage.BinaryFileId = imgupTransactionImages.BinaryFileId.Value;
financialTransactionImage.TransactionId = transactionId;
financialTransactionImage.TransactionImageTypeValueId = ddlTransactionImageType.SelectedValueAsInt();
service.Add(financialTransactionImage);
rockContext.SaveChanges();
imgupTransactionImages.BinaryFileId = 0;
LoadRelatedImages(transactionId);
}
/// <summary>
/// Loads the related images.
/// </summary>
/// <param name="transactionId">The transaction identifier.</param>
private void LoadRelatedImages(int transactionId)
{
var rockContext = new RockContext();
// Let's get a list of related images from the FinancialTransactionImage table
var relatedImageList = new FinancialTransactionImageService(rockContext).Queryable().Where(image => image.TransactionId == transactionId).ToList();
var binaryFileService = new BinaryFileService(rockContext);
// Now let's get the binary files from the BinaryFile table
var binaryFileList = new List <BinaryFile>();
foreach (var relatedImage in relatedImageList)
{
var binaryFileId = relatedImage.BinaryFileId;
var binaryFile = binaryFileService.Get(binaryFileId);
binaryFileList.Add(binaryFile);
}
dlImages.DataSource = binaryFileList;
dlImages.DataBind();
}
/// <summary>
/// Handles the Click event of the lbDelete control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton lbDelete = sender as LinkButton;
var imageId = int.Parse(lbDelete.Attributes["imageId"]);
var rockContext = new RockContext();
// Delete the reference to the binary file (image) from the FinancialTransactionImage table
var imageService = new FinancialTransactionImageService(rockContext);
var financialTransactionImage = imageService.Queryable().Where(image => image.BinaryFileId == imageId).FirstOrDefault();
imageService.Delete(financialTransactionImage);
// Delete the actual binary file (image)
var binaryFileService = new BinaryFileService(rockContext);
var binaryFile = binaryFileService.Get(imageId);
binaryFileService.Delete(binaryFile);
rockContext.SaveChanges();
LoadRelatedImages(hfIdTransValue.ValueAsInt());
}
/// <summary>
/// Handles the Click event of the lbSave control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void lbSave_Click(object sender, EventArgs e)
{
var rockContext = new RockContext();
var txnService = new FinancialTransactionService(rockContext);
var txnDetailService = new FinancialTransactionDetailService(rockContext);
var txnImageService = new FinancialTransactionImageService(rockContext);
var binaryFileService = new BinaryFileService(rockContext);
FinancialTransaction txn = null;
int?txnId = hfTransactionId.Value.AsIntegerOrNull();
int?batchId = hfBatchId.Value.AsIntegerOrNull();
if (txnId.HasValue)
{
txn = txnService.Get(txnId.Value);
}
if (txn == null)
{
txn = new FinancialTransaction();
txnService.Add(txn);
txn.BatchId = batchId;
}
if (txn != null)
{
if (ppAuthorizedPerson.PersonId.HasValue)
{
txn.AuthorizedPersonAliasId = ppAuthorizedPerson.PersonAliasId;
}
txn.TransactionDateTime = dtTransactionDateTime.SelectedDateTime;
txn.TransactionTypeValueId = ddlTransactionType.SelectedValue.AsInteger();
txn.SourceTypeValueId = ddlSourceType.SelectedValueAsInt();
Guid?gatewayGuid = cpPaymentGateway.SelectedValueAsGuid();
if (gatewayGuid.HasValue)
{
var gatewayEntity = EntityTypeCache.Read(gatewayGuid.Value);
if (gatewayEntity != null)
{
txn.GatewayEntityTypeId = gatewayEntity.Id;
}
else
{
txn.GatewayEntityTypeId = null;
}
}
else
{
txn.GatewayEntityTypeId = null;
}
txn.TransactionCode = tbTransactionCode.Text;
txn.CurrencyTypeValueId = ddlCurrencyType.SelectedValueAsInt();
txn.CreditCardTypeValueId = ddlCreditCardType.SelectedValueAsInt();
txn.Summary = tbSummary.Text;
if (!Page.IsValid || !txn.IsValid)
{
return;
}
foreach (var txnDetail in TransactionDetailsState)
{
if (!txnDetail.IsValid)
{
return;
}
}
rockContext.WrapTransaction(() =>
{
// Save the transaction
rockContext.SaveChanges();
// Delete any transaction details that were removed
var txnDetailsInDB = txnDetailService.Queryable().Where(a => a.TransactionId.Equals(txn.Id)).ToList();
var deletedDetails = from txnDetail in txnDetailsInDB
where !TransactionDetailsState.Select(d => d.Guid).Contains(txnDetail.Guid)
select txnDetail;
deletedDetails.ToList().ForEach(txnDetail =>
{
txnDetailService.Delete(txnDetail);
});
rockContext.SaveChanges();
// Save Transaction Details
foreach (var editorTxnDetail in TransactionDetailsState)
{
// Add or Update the activity type
var txnDetail = txn.TransactionDetails.FirstOrDefault(d => d.Guid.Equals(editorTxnDetail.Guid));
if (txnDetail == null)
{
txnDetail = new FinancialTransactionDetail();
txnDetail.Guid = editorTxnDetail.Guid;
txn.TransactionDetails.Add(txnDetail);
}
txnDetail.AccountId = editorTxnDetail.AccountId;
txnDetail.Amount = UseSimpleAccountMode ? tbSingleAccountAmount.Text.AsDecimal() : editorTxnDetail.Amount;
txnDetail.Summary = editorTxnDetail.Summary;
}
rockContext.SaveChanges();
// Delete any transaction images that were removed
var orphanedBinaryFileIds = new List <int>();
var txnImagesInDB = txnImageService.Queryable().Where(a => a.TransactionId.Equals(txn.Id)).ToList();
foreach (var txnImage in txnImagesInDB.Where(i => !TransactionImagesState.Contains(i.BinaryFileId)))
{
orphanedBinaryFileIds.Add(txnImage.BinaryFileId);
txnImageService.Delete(txnImage);
}
// Save Transaction Images
int imageOrder = 0;
foreach (var binaryFileId in TransactionImagesState)
{
// Add or Update the activity type
var txnImage = txnImagesInDB.FirstOrDefault(i => i.BinaryFileId == binaryFileId);
if (txnImage == null)
{
txnImage = new FinancialTransactionImage();
txnImage.TransactionId = txn.Id;
txn.Images.Add(txnImage);
}
txnImage.BinaryFileId = binaryFileId;
txnImage.Order = imageOrder;
imageOrder++;
}
rockContext.SaveChanges();
// Make sure updated binary files are not temporary
foreach (var binaryFile in binaryFileService.Queryable().Where(f => TransactionImagesState.Contains(f.Id)))
{
binaryFile.IsTemporary = false;
}
// Delete any orphaned images
foreach (var binaryFile in binaryFileService.Queryable().Where(f => orphanedBinaryFileIds.Contains(f.Id)))
{
binaryFileService.Delete(binaryFile);
}
rockContext.SaveChanges();
});
// Save selected options to session state in order to prefill values for next added txn
Session["NewTxnDefault_BatchId"] = txn.BatchId;
Session["NewTxnDefault_TransactionDateTime"] = txn.TransactionDateTime;
Session["NewTxnDefault_TransactionType"] = txn.TransactionTypeValueId;
Session["NewTxnDefault_SourceType"] = txn.SourceTypeValueId;
Session["NewTxnDefault_CurrencyType"] = txn.CurrencyTypeValueId;
Session["NewTxnDefault_CreditCardType"] = txn.CreditCardTypeValueId;
if (TransactionDetailsState.Count() == 1)
{
Session["NewTxnDefault_Account"] = TransactionDetailsState.First().AccountId;
}
else
{
Session.Remove("NewTxnDefault_Account");
}
// Requery the batch to support EF navigation properties
var savedTxn = GetTransaction(txn.Id);
ShowReadOnlyDetails(savedTxn);
}
}
