/// <summary>
/// Pres the save.
/// </summary>
/// <param name="dbContext">The database context.</param>
/// <param name="state">The state.</param>
public override void PreSaveChanges(DbContext dbContext, System.Data.Entity.EntityState state)
{
if (state == System.Data.Entity.EntityState.Deleted)
{
// since images have a cascade delete relationship, make sure the PreSaveChanges gets called
var childImages = new FinancialTransactionImageService(dbContext as RockContext).Queryable().Where(a => a.TransactionId == this.Id);
foreach (var image in childImages)
{
image.PreSaveChanges(dbContext, state);
}
}
}
/// <summary>
/// Pres the save.
/// </summary>
/// <param name="dbContext">The database context.</param>
/// <param name="entry"></param>
public override void PreSaveChanges(Rock.Data.DbContext dbContext, System.Data.Entity.Infrastructure.DbEntityEntry entry)
{
var rockContext = (RockContext)dbContext;
HistoryChangeList = new History.HistoryChangeList();
BatchHistoryChangeList = new Dictionary <int, History.HistoryChangeList> ();
switch (entry.State)
{
case System.Data.Entity.EntityState.Added:
{
HistoryChangeList.AddChange(History.HistoryVerb.Add, History.HistoryChangeType.Record, "Transaction");
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
History.EvaluateChange(HistoryChangeList, "Authorized Person", string.Empty, person);
History.EvaluateChange(HistoryChangeList, "Batch", string.Empty, History.GetValue <FinancialBatch>(Batch, BatchId, rockContext));
History.EvaluateChange(HistoryChangeList, "Gateway", string.Empty, History.GetValue <FinancialGateway>(FinancialGateway, FinancialGatewayId, rockContext));
History.EvaluateChange(HistoryChangeList, "Transaction Date/Time", (DateTime?)null, TransactionDateTime);
History.EvaluateChange(HistoryChangeList, "Transaction Code", string.Empty, TransactionCode);
History.EvaluateChange(HistoryChangeList, "Summary", string.Empty, Summary);
History.EvaluateChange(HistoryChangeList, "Type", (int?)null, TransactionTypeValue, TransactionTypeValueId);
History.EvaluateChange(HistoryChangeList, "Source", (int?)null, SourceTypeValue, SourceTypeValueId);
History.EvaluateChange(HistoryChangeList, "Scheduled Transaction Id", (int?)null, ScheduledTransactionId);
History.EvaluateChange(HistoryChangeList, "Processed By", string.Empty, History.GetValue <PersonAlias>(ProcessedByPersonAlias, ProcessedByPersonAliasId, rockContext));
History.EvaluateChange(HistoryChangeList, "Processed Date/Time", (DateTime?)null, ProcessedDateTime);
History.EvaluateChange(HistoryChangeList, "Status", string.Empty, Status);
History.EvaluateChange(HistoryChangeList, "Status Message", string.Empty, StatusMessage);
int?batchId = Batch != null ? Batch.Id : BatchId;
if (batchId.HasValue)
{
var batchChanges = new History.HistoryChangeList();
batchChanges.AddChange(History.HistoryVerb.Add, History.HistoryChangeType.Record, "Transaction").SetNewValue($"{this.TotalAmount.FormatAsCurrency()} for {person}");
BatchHistoryChangeList.Add(batchId.Value, batchChanges);
}
break;
}
case System.Data.Entity.EntityState.Modified:
{
string origPerson = History.GetValue <PersonAlias>(null, entry.OriginalValues["AuthorizedPersonAliasId"].ToStringSafe().AsIntegerOrNull(), rockContext);
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
History.EvaluateChange(HistoryChangeList, "Authorized Person", origPerson, person);
int?origBatchId = entry.OriginalValues["BatchId"].ToStringSafe().AsIntegerOrNull();
int?batchId = Batch != null ? Batch.Id : BatchId;
if (!batchId.Equals(origBatchId))
{
string origBatch = History.GetValue <FinancialBatch>(null, origBatchId, rockContext);
string batch = History.GetValue <FinancialBatch>(Batch, BatchId, rockContext);
History.EvaluateChange(HistoryChangeList, "Batch", origBatch, batch);
}
int?origGatewayId = entry.OriginalValues["FinancialGatewayId"].ToStringSafe().AsIntegerOrNull();
if (!FinancialGatewayId.Equals(origGatewayId))
{
History.EvaluateChange(HistoryChangeList, "Gateway", History.GetValue <FinancialGateway>(null, origGatewayId, rockContext), History.GetValue <FinancialGateway>(FinancialGateway, FinancialGatewayId, rockContext));
}
History.EvaluateChange(HistoryChangeList, "Transaction Date/Time", entry.OriginalValues["TransactionDateTime"].ToStringSafe().AsDateTime(), TransactionDateTime);
History.EvaluateChange(HistoryChangeList, "Transaction Code", entry.OriginalValues["TransactionCode"].ToStringSafe(), TransactionCode);
History.EvaluateChange(HistoryChangeList, "Summary", entry.OriginalValues["Summary"].ToStringSafe(), Summary);
History.EvaluateChange(HistoryChangeList, "Type", entry.OriginalValues["TransactionTypeValueId"].ToStringSafe().AsIntegerOrNull(), TransactionTypeValue, TransactionTypeValueId);
History.EvaluateChange(HistoryChangeList, "Source", entry.OriginalValues["SourceTypeValueId"].ToStringSafe().AsIntegerOrNull(), SourceTypeValue, SourceTypeValueId);
History.EvaluateChange(HistoryChangeList, "Scheduled Transaction Id", entry.OriginalValues["ScheduledTransactionId"].ToStringSafe().AsIntegerOrNull(), ScheduledTransactionId);
History.EvaluateChange(HistoryChangeList, "Processed By", entry.OriginalValues["ProcessedByPersonAliasId"].ToStringSafe().AsIntegerOrNull(), ProcessedByPersonAlias, ProcessedByPersonAliasId, rockContext);
History.EvaluateChange(HistoryChangeList, "Processed Date/Time", entry.OriginalValues["ProcessedDateTime"].ToStringSafe().AsDateTime(), ProcessedDateTime);
History.EvaluateChange(HistoryChangeList, "Status", entry.OriginalValues["Status"].ToStringSafe(), Status);
History.EvaluateChange(HistoryChangeList, "Status Message", entry.OriginalValues["StatusMessage"].ToStringSafe(), StatusMessage);
if (!batchId.Equals(origBatchId))
{
var batchChanges = new History.HistoryChangeList();
if (origBatchId.HasValue)
{
batchChanges.AddChange(History.HistoryVerb.Delete, History.HistoryChangeType.Record, "Transaction").SetOldValue($"{this.TotalAmount.FormatAsCurrency()} for {person}");
}
if (batchId.HasValue)
{
batchChanges.AddChange(History.HistoryVerb.Add, History.HistoryChangeType.Record, "Transaction").SetNewValue($"{this.TotalAmount.FormatAsCurrency()} for {person}");
}
BatchHistoryChangeList.Add(batchId.Value, batchChanges);
}
else
{
if (batchId.HasValue)
{
var batchChanges = new History.HistoryChangeList();
batchChanges.AddChange(History.HistoryVerb.Modify, History.HistoryChangeType.Record, $"Transaction Id:{Id}");
BatchHistoryChangeList.Add(batchId.Value, batchChanges);
}
}
break;
}
case System.Data.Entity.EntityState.Deleted:
{
HistoryChangeList.AddChange(History.HistoryVerb.Delete, History.HistoryChangeType.Record, "Transaction");
int?batchId = Batch != null ? Batch.Id : BatchId;
if (batchId.HasValue)
{
string batch = History.GetValue <FinancialBatch>(Batch, BatchId, rockContext);
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
var batchChanges = new History.HistoryChangeList();
batchChanges.AddChange(History.HistoryVerb.Delete, History.HistoryChangeType.Record, "Transaction").SetOldValue($"{this.TotalAmount.FormatAsCurrency()} for {person}");
BatchHistoryChangeList.Add(batchId.Value, batchChanges);
}
// since images have a cascade delete relationship, make sure the PreSaveChanges gets called
var childImages = new FinancialTransactionImageService(dbContext as RockContext).Queryable().Where(a => a.TransactionId == this.Id);
foreach (var image in childImages)
{
image.PreSaveChanges(dbContext, entry.State);
}
break;
}
}
base.PreSaveChanges(dbContext, entry);
}
/// <summary>
/// Pres the save.
/// </summary>
/// <param name="dbContext">The database context.</param>
/// <param name="entry"></param>
public override void PreSaveChanges(Rock.Data.DbContext dbContext, System.Data.Entity.Infrastructure.DbEntityEntry entry)
{
var rockContext = (RockContext)dbContext;
HistoryChanges = new List <string>();
BatchHistoryChanges = new Dictionary <int, List <string> >();
switch (entry.State)
{
case System.Data.Entity.EntityState.Added:
{
HistoryChanges.Add("Created Transaction");
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
History.EvaluateChange(HistoryChanges, "Authorized Person", string.Empty, person);
History.EvaluateChange(HistoryChanges, "Batch", string.Empty, History.GetValue <FinancialBatch>(Batch, BatchId, rockContext));
History.EvaluateChange(HistoryChanges, "Gateway", string.Empty, History.GetValue <FinancialGateway>(FinancialGateway, FinancialGatewayId, rockContext));
History.EvaluateChange(HistoryChanges, "Transaction Date/Time", (DateTime?)null, TransactionDateTime);
History.EvaluateChange(HistoryChanges, "Transaction Code", string.Empty, TransactionCode);
History.EvaluateChange(HistoryChanges, "Summary", string.Empty, Summary);
History.EvaluateChange(HistoryChanges, "Type", (int?)null, TransactionTypeValue, TransactionTypeValueId);
History.EvaluateChange(HistoryChanges, "Source", (int?)null, SourceTypeValue, SourceTypeValueId);
History.EvaluateChange(HistoryChanges, "Scheduled Transaction Id", (int?)null, ScheduledTransactionId);
History.EvaluateChange(HistoryChanges, "Processed By", string.Empty, History.GetValue <PersonAlias>(ProcessedByPersonAlias, ProcessedByPersonAliasId, rockContext));
History.EvaluateChange(HistoryChanges, "Processed Date/Time", (DateTime?)null, ProcessedDateTime);
History.EvaluateChange(HistoryChanges, "Status", string.Empty, Status);
History.EvaluateChange(HistoryChanges, "Status Message", string.Empty, StatusMessage);
int?batchId = Batch != null ? Batch.Id : BatchId;
if (batchId.HasValue)
{
BatchHistoryChanges.Add(batchId.Value, new List <string> {
string.Format("Added <span class='field-name'>{0:C2}</span> transaction for <span class='field-value'>{1}</span>.", this.TotalAmount, person)
});
}
break;
}
case System.Data.Entity.EntityState.Modified:
{
string origPerson = History.GetValue <PersonAlias>(null, entry.OriginalValues["AuthorizedPersonAliasId"].ToStringSafe().AsIntegerOrNull(), rockContext);
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
History.EvaluateChange(HistoryChanges, "Authorized Person", origPerson, person);
int?origBatchId = entry.OriginalValues["BatchId"].ToStringSafe().AsIntegerOrNull();
int?batchId = Batch != null ? Batch.Id : BatchId;
if (!batchId.Equals(origBatchId))
{
string origBatch = History.GetValue <FinancialBatch>(null, origBatchId, rockContext);
string batch = History.GetValue <FinancialBatch>(Batch, BatchId, rockContext);
History.EvaluateChange(HistoryChanges, "Batch", origBatch, batch);
}
int?origGatewayId = entry.OriginalValues["FinancialGatewayId"].ToStringSafe().AsIntegerOrNull();
if (!FinancialGatewayId.Equals(origGatewayId))
{
History.EvaluateChange(HistoryChanges, "Gateway", History.GetValue <FinancialGateway>(null, origGatewayId, rockContext), History.GetValue <FinancialGateway>(FinancialGateway, FinancialGatewayId, rockContext));
}
History.EvaluateChange(HistoryChanges, "Transaction Date/Time", entry.OriginalValues["TransactionDateTime"].ToStringSafe().AsDateTime(), TransactionDateTime);
History.EvaluateChange(HistoryChanges, "Transaction Code", entry.OriginalValues["TransactionCode"].ToStringSafe(), TransactionCode);
History.EvaluateChange(HistoryChanges, "Summary", entry.OriginalValues["Summary"].ToStringSafe(), Summary);
History.EvaluateChange(HistoryChanges, "Type", entry.OriginalValues["TransactionTypeValueId"].ToStringSafe().AsIntegerOrNull(), TransactionTypeValue, TransactionTypeValueId);
History.EvaluateChange(HistoryChanges, "Source", entry.OriginalValues["SourceTypeValueId"].ToStringSafe().AsIntegerOrNull(), SourceTypeValue, SourceTypeValueId);
History.EvaluateChange(HistoryChanges, "Scheduled Transaction Id", entry.OriginalValues["ScheduledTransactionId"].ToStringSafe().AsIntegerOrNull(), ScheduledTransactionId);
History.EvaluateChange(HistoryChanges, "Processed By", entry.OriginalValues["ProcessedByPersonAliasId"].ToStringSafe().AsIntegerOrNull(), ProcessedByPersonAlias, ProcessedByPersonAliasId, rockContext);
History.EvaluateChange(HistoryChanges, "Processed Date/Time", entry.OriginalValues["ProcessedDateTime"].ToStringSafe().AsDateTime(), ProcessedDateTime);
History.EvaluateChange(HistoryChanges, "Status", entry.OriginalValues["Status"].ToStringSafe(), Status);
History.EvaluateChange(HistoryChanges, "Status Message", entry.OriginalValues["StatusMessage"].ToStringSafe(), StatusMessage);
if (!batchId.Equals(origBatchId))
{
if (origBatchId.HasValue)
{
BatchHistoryChanges.Add(origBatchId.Value, new List <string> {
string.Format("Removed <span class='field-name'>{0:C2}</span> transaction for <span class='field-value'>{1}</span>.", this.TotalAmount, person)
});
}
if (batchId.HasValue)
{
BatchHistoryChanges.Add(batchId.Value, new List <string> {
string.Format("Added <span class='field-name'>{0:C2}</span> transaction for <span class='field-value'>{1}</span>.", this.TotalAmount, person)
});
}
}
else
{
if (batchId.HasValue)
{
BatchHistoryChanges.Add(batchId.Value, new List <string> {
string.Format("Updated <span class='field-name'>Transaction</span> ID: <span class='field-value'>{0}</span>.", Id)
});
}
}
break;
}
case System.Data.Entity.EntityState.Deleted:
{
HistoryChanges.Add("Deleted Transaction");
int?batchId = Batch != null ? Batch.Id : BatchId;
if (batchId.HasValue)
{
string batch = History.GetValue <FinancialBatch>(Batch, BatchId, rockContext);
string person = History.GetValue <PersonAlias>(AuthorizedPersonAlias, AuthorizedPersonAliasId, rockContext);
BatchHistoryChanges.Add(batchId.Value, new List <string> {
string.Format("Deleted <span class='field-name'>{0:C2}</span> transaction for <span class='field-value'>{1}</span>.", this.TotalAmount, person)
});
}
// since images have a cascade delete relationship, make sure the PreSaveChanges gets called
var childImages = new FinancialTransactionImageService(dbContext as RockContext).Queryable().Where(a => a.TransactionId == this.Id);
foreach (var image in childImages)
{
image.PreSaveChanges(dbContext, entry.State);
}
break;
}
}
base.PreSaveChanges(dbContext, entry);
}
/// <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 && batchId.HasValue )
{
txn = new FinancialTransaction();
txnService.Add( txn );
txn.BatchId = batchId.Value;
}
if ( txn != null )
{
txn.AuthorizedPersonId = ppAuthorizedPerson.PersonId;
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;
}
}
foreach ( var txnImage in TransactionImagesState )
{
if ( !txnImage.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 = editorTxnDetail.Amount;
txnDetail.Summary = editorTxnDetail.Summary;
}
rockContext.SaveChanges();
// Remove any images that do not have a binary file
foreach ( var txnImage in TransactionImagesState.Where( i => i.BinaryFileId == 0 ).ToList() )
{
TransactionImagesState.Remove( txnImage );
}
// Delete any transaction images that were removed
var txnImagesInDB = txnImageService.Queryable().Where( a => a.TransactionId.Equals( txn.Id ) ).ToList();
var deletedImages = from txnImage in txnImagesInDB
where !TransactionImagesState.Select( d => d.Guid ).Contains( txnImage.Guid )
select txnImage;
deletedImages.ToList().ForEach( txnImage =>
{
txnImageService.Delete( txnImage );
} );
rockContext.SaveChanges();
// Save Transaction Images
foreach ( var editorTxnImage in TransactionImagesState )
{
// Add or Update the activity type
var txnImage = txn.Images.FirstOrDefault( d => d.Guid.Equals( editorTxnImage.Guid ) );
if ( txnImage == null )
{
txnImage = new FinancialTransactionImage();
txnImage.Guid = editorTxnImage.Guid;
txn.Images.Add( txnImage );
}
txnImage.BinaryFileId = editorTxnImage.BinaryFileId;
txnImage.TransactionImageTypeValueId = editorTxnImage.TransactionImageTypeValueId;
}
rockContext.SaveChanges();
// Make sure updated binary files are not temporary
var savedBinaryFileIds = txn.Images.Select( i => i.BinaryFileId ).ToList();
foreach ( var binaryFile in binaryFileService.Queryable().Where( f => savedBinaryFileIds.Contains( f.Id ) ) )
{
binaryFile.IsTemporary = false;
}
// Delete any orphaned images
var orphanedBinaryFileIds = BinaryFileIds.Where( f => !savedBinaryFileIds.Contains( f ) );
foreach ( var binaryFile in binaryFileService.Queryable().Where( f => orphanedBinaryFileIds.Contains( f.Id ) ) )
{
binaryFileService.Delete( binaryFile );
}
rockContext.SaveChanges();
} );
// Requery the batch to support EF navigation properties
var savedTxn = GetTransaction( txn.Id );
ShowReadOnlyDetails( savedTxn );
}
}
/// <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 );
}
}
/// <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();
var changes = new List<string>();
if ( txnId.HasValue )
{
txn = txnService.Get( txnId.Value );
}
if ( txn == null )
{
txn = new FinancialTransaction();
txnService.Add( txn );
txn.BatchId = batchId;
changes.Add( "Created transaction" );
}
if ( txn != null )
{
if ( txn.FinancialPaymentDetail == null )
{
txn.FinancialPaymentDetail = new FinancialPaymentDetail();
}
string newPerson = ppAuthorizedPerson.PersonName;
if ( batchId.HasValue )
{
if ( !txn.AuthorizedPersonAliasId.Equals( ppAuthorizedPerson.PersonAliasId ) )
{
string prevPerson = ( txn.AuthorizedPersonAlias != null && txn.AuthorizedPersonAlias.Person != null ) ?
txn.AuthorizedPersonAlias.Person.FullName : string.Empty;
History.EvaluateChange( changes, "Person", prevPerson, newPerson );
}
History.EvaluateChange( changes, "Date/Time", txn.TransactionDateTime, dtTransactionDateTime.SelectedDateTime );
History.EvaluateChange( changes, "Type", GetDefinedValue( txn.TransactionTypeValueId ), GetDefinedValue( ddlTransactionType.SelectedValue.AsInteger() ) );
History.EvaluateChange( changes, "Source", GetDefinedValue( txn.SourceTypeValueId ), GetDefinedValue( ddlSourceType.SelectedValueAsInt() ) );
if ( !txn.FinancialGatewayId.Equals( gpPaymentGateway.SelectedValueAsInt() ) )
{
History.EvaluateChange( changes, "Gateway", GetFinancialGatewayName( txn.FinancialGatewayId, rockContext ), GetFinancialGatewayName( gpPaymentGateway.SelectedValueAsInt(), rockContext ) );
}
History.EvaluateChange( changes, "Transaction Code", txn.TransactionCode, tbTransactionCode.Text );
History.EvaluateChange( changes, "Currency Type", GetDefinedValue( txn.FinancialPaymentDetail.CurrencyTypeValueId ), GetDefinedValue( ddlCurrencyType.SelectedValueAsInt() ) );
History.EvaluateChange( changes, "Credit Card Type", GetDefinedValue( txn.FinancialPaymentDetail.CreditCardTypeValueId ), GetDefinedValue( ddlCreditCardType.SelectedValueAsInt() ) );
History.EvaluateChange( changes, "Summary", txn.Summary, tbSummary.Text );
History.EvaluateChange( changes, "Is Refund", ( txn.RefundDetails != null ), cbIsRefund.Checked );
}
txn.AuthorizedPersonAliasId = ppAuthorizedPerson.PersonAliasId;
txn.TransactionDateTime = dtTransactionDateTime.SelectedDateTime;
txn.TransactionTypeValueId = ddlTransactionType.SelectedValue.AsInteger();
txn.SourceTypeValueId = ddlSourceType.SelectedValueAsInt();
txn.FinancialGatewayId = gpPaymentGateway.SelectedValueAsInt();
txn.TransactionCode = tbTransactionCode.Text;
txn.FinancialPaymentDetail.CurrencyTypeValueId = ddlCurrencyType.SelectedValueAsInt();
txn.FinancialPaymentDetail.CreditCardTypeValueId = ddlCreditCardType.SelectedValueAsInt();
txn.Summary = tbSummary.Text;
decimal totalAmount = TransactionDetailsState.Select( d => d.Amount ).ToList().Sum();
if ( cbIsRefund.Checked && totalAmount > 0 )
{
nbErrorMessage.Title = "Incorrect Refund Amount";
nbErrorMessage.Text = "<p>A refund should have a negative amount. Please unselect the refund option, or change amounts to be negative values.</p>";
nbErrorMessage.Visible = true;
return;
}
if ( cbIsRefund.Checked )
{
if ( txn.RefundDetails != null )
{
txn.RefundDetails = new FinancialTransactionRefund();
}
txn.RefundDetails.RefundReasonValueId = ddlRefundReasonEdit.SelectedValueAsId();
txn.RefundDetails.RefundReasonSummary = tbRefundSummaryEdit.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 =>
{
if ( batchId.HasValue )
{
History.EvaluateChange( changes, txnDetail.Account != null ? txnDetail.Account.Name : "Unknown", txnDetail.Amount.FormatAsCurrency(), string.Empty );
}
txnDetailService.Delete( txnDetail );
} );
// Save Transaction Details
foreach ( var editorTxnDetail in TransactionDetailsState )
{
string oldAccountName = string.Empty;
string newAccountName = string.Empty;
decimal oldAmount = 0.0M;
decimal newAmount = 0.0M;
// Add or Update the activity type
var txnDetail = txn.TransactionDetails.FirstOrDefault( d => d.Guid.Equals( editorTxnDetail.Guid ) );
if ( txnDetail != null )
{
oldAccountName = AccountName( txnDetail.AccountId );
oldAmount = txnDetail.Amount;
}
else
{
txnDetail = new FinancialTransactionDetail();
txnDetail.Guid = editorTxnDetail.Guid;
txn.TransactionDetails.Add( txnDetail );
}
newAccountName = AccountName( editorTxnDetail.AccountId );
newAmount = UseSimpleAccountMode ? tbSingleAccountAmount.Text.AsDecimal() : editorTxnDetail.Amount;
if ( batchId.HasValue )
{
if ( string.IsNullOrWhiteSpace(oldAccountName) )
{
History.EvaluateChange( changes, newAccountName, string.Empty, newAmount.FormatAsCurrency() );
}
else
{
if ( oldAccountName == newAccountName )
{
if ( oldAmount != newAmount )
{
History.EvaluateChange( changes, oldAccountName, oldAmount.FormatAsCurrency(), newAmount.FormatAsCurrency() );
}
}
else
{
History.EvaluateChange( changes, oldAccountName, oldAmount.FormatAsCurrency(), string.Empty );
History.EvaluateChange( changes, newAccountName, string.Empty, newAmount.FormatAsCurrency() );
}
}
}
txnDetail.AccountId = editorTxnDetail.AccountId;
txnDetail.Amount = newAmount;
txnDetail.Summary = editorTxnDetail.Summary;
if ( editorTxnDetail.AttributeValues != null )
{
txnDetail.LoadAttributes();
txnDetail.AttributeValues = editorTxnDetail.AttributeValues;
rockContext.SaveChanges();
txnDetail.SaveAttributeValues( rockContext );
}
}
// 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 ) ) )
{
changes.Add( "Removed Image" );
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 )
{
changes.Add( "Added Image" );
txnImage = new FinancialTransactionImage();
txnImage.TransactionId = txn.Id;
txn.Images.Add( txnImage );
}
else
{
if ( txnImage.BinaryFileId != binaryFileId )
{
changes.Add( "Updated Image" );
}
}
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 );
}
// Update any attributes
txn.LoadAttributes(rockContext);
txn.FinancialPaymentDetail.LoadAttributes(rockContext);
Helper.GetEditValues(phAttributeEdits, txn);
Helper.GetEditValues(phPaymentAttributeEdits, txn.FinancialPaymentDetail);
// If the transaction is associated with a batch, update that batch's history
if ( batchId.HasValue )
{
HistoryService.SaveChanges(
rockContext,
typeof( FinancialBatch ),
Rock.SystemGuid.Category.HISTORY_FINANCIAL_TRANSACTION.AsGuid(),
batchId.Value,
changes,
!string.IsNullOrWhiteSpace( newPerson ) ? newPerson : string.Format( "Transaction Id:{0}", txn.Id ),
typeof( FinancialTransaction ),
txn.Id
);
}
rockContext.SaveChanges();
txn.SaveAttributeValues(rockContext);
txn.FinancialPaymentDetail.SaveAttributeValues(rockContext);
} );
// 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.FinancialPaymentDetail.CurrencyTypeValueId;
Session["NewTxnDefault_CreditCardType"] = txn.FinancialPaymentDetail.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 );
if ( savedTxn != null )
{
savedTxn.LoadAttributes();
savedTxn.FinancialPaymentDetail.LoadAttributes();
ShowReadOnlyDetails( savedTxn );
}
}
}
/// <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 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>
/// 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() );
}
