/// <summary>
/// Handles the Loaded event of the Page control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void Page_Loaded(object sender, RoutedEventArgs e)
{
FinancialTransactionImage frontTranImage = FinancialTransaction.Images.FirstOrDefault(a => a.TransactionImageTypeValueId.Equals(TransactionImageTypeValueFront.Id));
FinancialTransactionImage backTranImage = FinancialTransaction.Images.FirstOrDefault(a => a.TransactionImageTypeValueId.Equals(TransactionImageTypeValueBack.Id));
if (frontTranImage != null)
{
BitmapImage bitmapImage = new BitmapImage();
bitmapImage.BeginInit();
bitmapImage.StreamSource = new MemoryStream(frontTranImage.BinaryFile.Data.Content);
bitmapImage.EndInit();
imgFront.Source = bitmapImage;
}
else
{
imgFront.Source = null;
}
if (backTranImage != null)
{
BitmapImage bitmapImage = new BitmapImage();
bitmapImage.BeginInit();
bitmapImage.StreamSource = new MemoryStream(backTranImage.BinaryFile.Data.Content);
bitmapImage.EndInit();
imgBack.Source = bitmapImage;
}
else
{
imgBack.Source = null;
}
}
/// <summary>
/// Saves the specified item.
/// </summary>
/// <param name="item">The item.</param>
/// <param name="personId">The person identifier.</param>
/// <returns></returns>
public override bool Save( FinancialTransactionImage item, int? personId )
{
// ensure that the BinaryFile.IsTemporary flag is set to false for any BinaryFiles that are associated with this record
BinaryFileService binaryFileService = new BinaryFileService( this.RockContext );
var binaryFile = binaryFileService.Get( item.BinaryFileId );
if ( binaryFile != null && binaryFile.IsTemporary )
{
binaryFile.IsTemporary = false;
}
return base.Save( item, personId );
}
/// <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>
/// Saves the files.
/// </summary>
/// <param name="newFileList">The new file list.</param>
/// <param name="storageProvider">The storage provider.</param>
private static void SaveFiles(Dictionary <int, Rock.Model.BinaryFile> newFileList, ProviderComponent storageProvider)
{
var rockContext = new RockContext();
rockContext.WrapTransaction(() =>
{
rockContext.BinaryFiles.AddRange(newFileList.Values);
rockContext.SaveChanges();
foreach (var entry in newFileList)
{
if (entry.Value != null)
{
if (storageProvider != null)
{
storageProvider.SaveContent(entry.Value);
entry.Value.Path = storageProvider.GetPath(entry.Value);
}
else
{
LogException("Binary File Import", string.Format("Could not load provider {0}.", storageProvider.ToString()));
}
}
// associate the image with the right transaction
var transactionImage = new FinancialTransactionImage
{
TransactionId = entry.Key,
BinaryFileId = entry.Value.Id,
Order = 0
};
rockContext.FinancialTransactions.FirstOrDefault(t => t.Id == entry.Key)
.Images.Add(transactionImage);
}
rockContext.SaveChanges(DisableAuditing);
});
}
/// <summary>
/// Saves the image.
/// </summary>
/// <param name="binaryfileTypeId">The binaryfile type identifier.</param>
/// <param name="fileName">Name of the file.</param>
/// <param name="base64String">The base64 string.</param>
/// <returns></returns>
private void SaveImage(FinancialTransaction txn, string base64String, int binaryfileTypeId, string fileName)
{
if (!string.IsNullOrWhiteSpace(base64String))
{
using (var rockContext = new RockContext())
{
BinaryFile binaryFile = new BinaryFile();
binaryFile.Guid = Guid.NewGuid();
binaryFile.IsTemporary = true;
binaryFile.BinaryFileTypeId = binaryfileTypeId;
binaryFile.MimeType = "image/tiff";
binaryFile.FileName = fileName;
binaryFile.ContentStream = new MemoryStream(Convert.FromBase64String(base64String));
var binaryFileService = new BinaryFileService(rockContext);
binaryFileService.Add(binaryFile);
rockContext.SaveChanges();
var transactionImage = new FinancialTransactionImage();
transactionImage.BinaryFileId = binaryFile.Id;
txn.Images.Add(transactionImage);
}
}
}
/// <summary>
/// Saves the files.
/// </summary>
/// <param name="newFileList">The new file list.</param>
private static void SaveFiles( Dictionary<int, Rock.Model.BinaryFile> newFileList, ProviderComponent storageProvider )
{
if ( storageProvider == null )
{
LogException( "Binary File Import", string.Format( "Could not load provider {0}.", storageProvider.ToString() ) );
return;
}
var rockContext = new RockContext();
rockContext.WrapTransaction( () =>
{
foreach ( var entry in newFileList )
{
if ( entry.Value != null )
{
storageProvider.SaveContent( entry.Value );
entry.Value.Path = storageProvider.GetPath( entry.Value );
}
}
rockContext.BinaryFiles.AddRange( newFileList.Values );
rockContext.SaveChanges();
foreach ( var entry in newFileList )
{
// associate the image with the right transaction
var transactionImage = new FinancialTransactionImage();
transactionImage.TransactionId = entry.Key;
transactionImage.BinaryFileId = entry.Value.Id;
transactionImage.Order = 0;
rockContext.FinancialTransactions.FirstOrDefault( t => t.Id == entry.Key )
.Images.Add( transactionImage );
}
rockContext.SaveChanges( DisableAuditing );
} );
}
/// <summary>
/// Creates the giving records for the given parameters.
/// </summary>
/// <param name="personGuid">The person unique identifier.</param>
/// <param name="startingDate">The starting date.</param>
/// <param name="endDate">The end date.</param>
/// <param name="frequency">The frequency (onetime, weekly, monthly).</param>
/// <param name="percentGive">The percent give.</param>
/// <param name="growRatePercent">The grow rate percent.</param>
/// <param name="growFrequencyWeeks">The grow frequency weeks.</param>
/// <param name="specialGiftPercent">The special gift percent.</param>
/// <param name="accountAmountDict">The account amount dictionary.</param>
/// <param name="circularImageList">A circular linked list of imageUrls to use for the fake contribution checks.</param>
/// <param name="rockContexe">A rock context.</param>
private void CreateGiving( Guid personGuid, DateTime startingDate, DateTime endDate, Frequency frequency, int percentGive, int growRatePercent, int growFrequencyWeeks, int specialGiftPercent, Dictionary<int, decimal> accountAmountDict, LinkedList<string> circularImageList, RockContext rockContext )
{
int weekNumber = 0;
DateTime monthly = startingDate;
var currencyTypeCheck = DefinedValueCache.Read( Rock.SystemGuid.DefinedValue.CURRENCY_TYPE_CHECK.AsGuid() );
var imageUrlNode = circularImageList.First ?? null;
// foreach weekend or monthly between the starting and ending date...
for ( DateTime date = startingDate; date <= endDate; date = frequency == Frequency.weekly ? date.AddDays( 7 ) : frequency == Frequency.monthly ? date.AddMonths( 1 ) : endDate.AddDays(1) )
{
weekNumber = (int)(date - startingDate).TotalDays / 7;
// increase by growRatePercent every growFrequencyWeeks
if ( growFrequencyWeeks != 0 && growRatePercent != 0 && weekNumber !=0 && weekNumber % growFrequencyWeeks == 0 )
{
var copy = accountAmountDict.ToDictionary( entry => entry.Key, entry => entry.Value );
foreach ( var item in accountAmountDict )
{
decimal amount = Math.Round( ( item.Value * 0.01M ) + item.Value, 0 );
copy[item.Key] = amount;
}
accountAmountDict = copy;
}
// randomized skip/missed weeks
int summerFactor = ( 7 <= date.Month && date.Month <= 9 ) ? summerPercentFactor : 0;
if ( _random.Next( 0, 100 ) > percentGive - summerFactor )
{
continue; // skip this week
}
FinancialBatch batch;
if ( _contributionBatches.ContainsKey( date ) )
{
batch = _contributionBatches[date];
}
else
{
batch = new FinancialBatch {
Id = 0,
Guid = Guid.NewGuid(),
BatchStartDateTime = date,
BatchEndDateTime = date,
Status = BatchStatus.Closed,
ControlAmount = 0,
Name = string.Format( "SampleData{0}", date.ToJavascriptMilliseconds() ),
CreatedByPersonAliasId = CurrentPerson.PrimaryAliasId };
_contributionBatches.Add( date, batch );
}
// Set up the new transaction
FinancialTransaction financialTransaction = new FinancialTransaction
{
TransactionTypeValueId = _transactionTypeContributionId,
Guid = Guid.NewGuid(),
TransactionDateTime = date,
AuthorizedPersonAliasId = _peopleAliasDictionary[personGuid]
};
financialTransaction.FinancialPaymentDetail = new FinancialPaymentDetail();
financialTransaction.FinancialPaymentDetail.CurrencyTypeValueId = currencyTypeCheck.Id;
financialTransaction.FinancialPaymentDetail.Guid = Guid.NewGuid();
// Add a transaction detail record for each account they're donating to
foreach ( var item in accountAmountDict )
{
FinancialTransactionDetail transactionDetail = new FinancialTransactionDetail {
AccountId = item.Key,
Amount = item.Value,
Guid = Guid.NewGuid()
};
financialTransaction.TransactionDetails.Add( transactionDetail );
}
// Add the image to the transaction (if any)
if ( imageUrlNode != null )
{
FinancialTransactionImage transactionImage = new FinancialTransactionImage
{
BinaryFile = SaveImage( imageUrlNode.Value, _checkImageBinaryFileType, _checkImageBinaryFileTypeSettings, rockContext ),
Guid = Guid.NewGuid(),
};
financialTransaction.Images.Add( transactionImage );
imageUrlNode = imageUrlNode.Next ?? imageUrlNode.List.First;
}
// Update the batch with the new control amount
batch.ControlAmount += financialTransaction.TotalAmount;
batch.Transactions.Add( financialTransaction );
}
}
/// <summary>
/// Handles the DoWork event of the bwUploadScannedChecks control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DoWorkEventArgs"/> instance containing the event data.</param>
private void bwUploadScannedChecks_DoWork( object sender, DoWorkEventArgs e )
{
BackgroundWorker bw = sender as BackgroundWorker;
RockConfig rockConfig = RockConfig.Load();
RockRestClient client = new RockRestClient( rockConfig.RockBaseUrl );
client.Login( rockConfig.Username, rockConfig.Password );
AssemblyName assemblyName = Assembly.GetExecutingAssembly().GetName();
string appInfo = string.Format( "{0}, version: {1}", assemblyName.FullName, assemblyName.Version );
BinaryFileType binaryFileTypeContribution = client.GetDataByGuid<BinaryFileType>( "api/BinaryFileTypes", new Guid( Rock.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE ) );
DefinedValue currencyTypeValueCheck = client.GetDataByGuid<DefinedValue>( "api/DefinedValues", new Guid( Rock.SystemGuid.DefinedValue.CURRENCY_TYPE_CHECK ) );
DefinedValue transactionTypeValueContribution = client.GetDataByGuid<DefinedValue>( "api/DefinedValues", new Guid( Rock.SystemGuid.DefinedValue.TRANSACTION_TYPE_CONTRIBUTION ) );
DefinedValue transactionImageTypeValueFront = client.GetDataByGuid<DefinedValue>( "api/DefinedValues", new Guid( Rock.SystemGuid.DefinedValue.TRANSACTION_IMAGE_TYPE_CHECK_FRONT ) );
DefinedValue transactionImageTypeValueBack = client.GetDataByGuid<DefinedValue>( "api/DefinedValues", new Guid( Rock.SystemGuid.DefinedValue.TRANSACTION_IMAGE_TYPE_CHECK_BACK ) );
int totalCount = ScannedCheckList.Where( a => !a.Uploaded ).Count();
int position = 1;
foreach ( ScannedCheckInfo scannedCheckInfo in ScannedCheckList.Where( a => !a.Uploaded ) )
{
// upload image of front of check
BinaryFile binaryFileFront = new BinaryFile();
binaryFileFront.Guid = Guid.NewGuid();
binaryFileFront.FileName = string.Format( "{0}_{1}_{2}_front.png", scannedCheckInfo.RoutingNumber, scannedCheckInfo.MaskedAccountNumber, scannedCheckInfo.CheckNumber );
binaryFileFront.BinaryFileTypeId = binaryFileTypeContribution.Id;
binaryFileFront.IsSystem = false;
binaryFileFront.MimeType = "image/png";
client.PostData<BinaryFile>( "api/BinaryFiles/", binaryFileFront );
// upload image data content of front of check
binaryFileFront.Data = new BinaryFileData();
binaryFileFront.Data.Content = scannedCheckInfo.FrontImagePngBytes;
binaryFileFront.Data.Id = client.GetDataByGuid<BinaryFile>( "api/BinaryFiles/", binaryFileFront.Guid ).Id;
client.PostData<BinaryFileData>( "api/BinaryFileDatas/", binaryFileFront.Data );
// upload image of back of check (if it exists)
BinaryFile binaryFileBack = null;
if ( scannedCheckInfo.BackImageData != null )
{
binaryFileBack = new BinaryFile();
binaryFileBack.Guid = Guid.NewGuid();
binaryFileBack.FileName = string.Format( "{0}_{1}_{2}_back.png", scannedCheckInfo.RoutingNumber, scannedCheckInfo.MaskedAccountNumber, scannedCheckInfo.CheckNumber );
// upload image of back of check
binaryFileBack.BinaryFileTypeId = binaryFileTypeContribution.Id;
binaryFileBack.IsSystem = false;
binaryFileBack.MimeType = "image/png";
client.PostData<BinaryFile>( "api/BinaryFiles/", binaryFileBack );
// upload image data content of back of check
binaryFileBack.Data = new BinaryFileData();
binaryFileBack.Data.Content = scannedCheckInfo.BackImagePngBytes;
binaryFileBack.Data.Id = client.GetDataByGuid<BinaryFile>( "api/BinaryFiles/", binaryFileBack.Guid ).Id;
client.PostData<BinaryFileData>( "api/BinaryFileDatas/", binaryFileBack.Data );
}
int percentComplete = position++ * 100 / totalCount;
bw.ReportProgress( percentComplete );
FinancialTransactionScannedCheck financialTransactionScannedCheck = new FinancialTransactionScannedCheck();
financialTransactionScannedCheck.BatchId = SelectedFinancialBatch.Id;
financialTransactionScannedCheck.TransactionCode = string.Empty;
financialTransactionScannedCheck.Summary = string.Format( "Scanned Check from {0}", appInfo );
financialTransactionScannedCheck.Guid = Guid.NewGuid();
financialTransactionScannedCheck.TransactionDateTime = SelectedFinancialBatch.BatchStartDateTime;
financialTransactionScannedCheck.CurrencyTypeValueId = currencyTypeValueCheck.Id;
financialTransactionScannedCheck.CreditCardTypeValueId = null;
financialTransactionScannedCheck.SourceTypeValueId = null;
financialTransactionScannedCheck.AuthorizedPersonId = null;
financialTransactionScannedCheck.TransactionTypeValueId = transactionTypeValueContribution.Id;
// Rock server will encrypt CheckMicrPlainText to this since we can't have the DataEncryptionKey in a RestClient
financialTransactionScannedCheck.CheckMicrEncrypted = null;
financialTransactionScannedCheck.ScannedCheckMicr = string.Format( "{0}_{1}_{2}", scannedCheckInfo.RoutingNumber, scannedCheckInfo.AccountNumber, scannedCheckInfo.CheckNumber );
client.PostData<FinancialTransactionScannedCheck>( "api/FinancialTransactions/PostScanned", financialTransactionScannedCheck );
// get the FinancialTransaction back from server so that we can get it's Id
financialTransactionScannedCheck.Id = client.GetDataByGuid<FinancialTransaction>( "api/FinancialTransactions", financialTransactionScannedCheck.Guid ).Id;
// get the BinaryFiles back so that we can get their Ids
binaryFileFront.Id = client.GetDataByGuid<BinaryFile>( "api/BinaryFiles", binaryFileFront.Guid ).Id;
// upload FinancialTransactionImage records for front/back
FinancialTransactionImage financialTransactionImageFront = new FinancialTransactionImage();
financialTransactionImageFront.BinaryFileId = binaryFileFront.Id;
financialTransactionImageFront.TransactionId = financialTransactionScannedCheck.Id;
financialTransactionImageFront.TransactionImageTypeValueId = transactionImageTypeValueFront.Id;
client.PostData<FinancialTransactionImage>( "api/FinancialTransactionImages", financialTransactionImageFront );
if ( binaryFileBack != null )
{
// get the BinaryFiles back so that we can get their Ids
binaryFileBack.Id = client.GetDataByGuid<BinaryFile>( "api/BinaryFiles", binaryFileBack.Guid ).Id;
FinancialTransactionImage financialTransactionImageBack = new FinancialTransactionImage();
financialTransactionImageBack.BinaryFileId = binaryFileBack.Id;
financialTransactionImageBack.TransactionId = financialTransactionScannedCheck.Id;
financialTransactionImageBack.TransactionImageTypeValueId = transactionImageTypeValueBack.Id;
client.PostData<FinancialTransactionImage>( "api/FinancialTransactionImages", financialTransactionImageBack );
}
scannedCheckInfo.Uploaded = true;
}
}
/// <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 DoWork event of the bwUploadScannedChecks control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DoWorkEventArgs"/> instance containing the event data.</param>
private void bwUploadScannedChecks_DoWork( object sender, DoWorkEventArgs e )
{
BackgroundWorker bw = sender as BackgroundWorker;
RockConfig rockConfig = RockConfig.Load();
RockRestClient client = new RockRestClient( rockConfig.RockBaseUrl );
client.Login( rockConfig.Username, rockConfig.Password );
AssemblyName assemblyName = Assembly.GetExecutingAssembly().GetName();
string appInfo = string.Format( "{0}, version: {1}", assemblyName.Name, assemblyName.Version );
BinaryFileType binaryFileTypeContribution = client.GetDataByGuid<BinaryFileType>( "api/BinaryFileTypes", new Guid( Rock.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE ) );
DefinedValue transactionTypeValueContribution = client.GetDataByGuid<DefinedValue>( "api/DefinedValues", new Guid( Rock.SystemGuid.DefinedValue.TRANSACTION_TYPE_CONTRIBUTION ) );
int totalCount = ScannedDocList.Where( a => !a.Uploaded ).Count();
int position = 1;
foreach ( ScannedDocInfo scannedDocInfo in ScannedDocList.Where( a => !a.Uploaded ) )
{
// upload image of front of doc
string frontImageFileName = string.Format( "image1_{0}.png", RockDateTime.Now.ToString( "o" ).RemoveSpecialCharacters() );
int frontImageBinaryFileId = client.UploadBinaryFile( frontImageFileName, Rock.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE.AsGuid(), scannedDocInfo.FrontImagePngBytes, false );
// upload image of back of doc (if it exists)
int? backImageBinaryFileId = null;
if ( scannedDocInfo.BackImageData != null )
{
// upload image of back of doc
string backImageFileName = string.Format( "image2_{0}.png", RockDateTime.Now.ToString( "o" ).RemoveSpecialCharacters() );
backImageBinaryFileId = client.UploadBinaryFile( backImageFileName, Rock.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE.AsGuid(), scannedDocInfo.BackImagePngBytes, false );
}
int percentComplete = position++ * 100 / totalCount;
bw.ReportProgress( percentComplete );
FinancialTransaction financialTransactionScanned = new FinancialTransaction();
Guid transactionGuid = Guid.NewGuid();
financialTransactionScanned.BatchId = SelectedFinancialBatch.Id;
financialTransactionScanned.TransactionCode = string.Empty;
financialTransactionScanned.Summary = "Scanned from Check Scanner Utility";
financialTransactionScanned.Guid = transactionGuid;
financialTransactionScanned.TransactionDateTime = SelectedFinancialBatch.BatchStartDateTime;
financialTransactionScanned.CurrencyTypeValueId = scannedDocInfo.CurrencyTypeValue.Id;
financialTransactionScanned.SourceTypeValueId = scannedDocInfo.SourceTypeValue.Id;
financialTransactionScanned.TransactionTypeValueId = transactionTypeValueContribution.Id;
if ( scannedDocInfo.IsCheck )
{
FinancialTransactionScannedCheck financialTransactionScannedCheck = new FinancialTransactionScannedCheck();
// Rock server will encrypt CheckMicrPlainText to this since we can't have the DataEncryptionKey in a RestClient
financialTransactionScannedCheck.FinancialTransaction = financialTransactionScanned;
financialTransactionScannedCheck.ScannedCheckMicr = scannedDocInfo.ScannedCheckMicr;
client.PostData<FinancialTransactionScannedCheck>( "api/FinancialTransactions/PostScanned", financialTransactionScannedCheck );
}
else
{
client.PostData<FinancialTransaction>( "api/FinancialTransactions", financialTransactionScanned as FinancialTransaction );
}
// get the FinancialTransaction back from server so that we can get it's Id
int transactionId = client.GetIdFromGuid( "api/FinancialTransactions/", transactionGuid );
// upload FinancialTransactionImage records for front/back
FinancialTransactionImage financialTransactionImageFront = new FinancialTransactionImage();
financialTransactionImageFront.BinaryFileId = frontImageBinaryFileId;
financialTransactionImageFront.TransactionId = transactionId;
financialTransactionImageFront.Order = 0;
client.PostData<FinancialTransactionImage>( "api/FinancialTransactionImages", financialTransactionImageFront );
if ( backImageBinaryFileId.HasValue )
{
FinancialTransactionImage financialTransactionImageBack = new FinancialTransactionImage();
financialTransactionImageBack.BinaryFileId = backImageBinaryFileId.Value;
financialTransactionImageBack.TransactionId = transactionId;
financialTransactionImageBack.Order = 1;
client.PostData<FinancialTransactionImage>( "api/FinancialTransactionImages", financialTransactionImageBack );
}
scannedDocInfo.Uploaded = true;
scannedDocInfo.TransactionId = transactionId;
}
ScanningPage.ClearScannedDocHistory();
}
/// <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 DoWork event of the bwUploadScannedChecks control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DoWorkEventArgs"/> instance containing the event data.</param>
private void bwUploadScannedChecks_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker bw = sender as BackgroundWorker;
RockConfig rockConfig = RockConfig.Load();
RockRestClient client = new RockRestClient(rockConfig.RockBaseUrl);
client.Login(rockConfig.Username, rockConfig.Password);
AssemblyName assemblyName = Assembly.GetExecutingAssembly().GetName();
string appInfo = string.Format("{0}, version: {1}", assemblyName.FullName, assemblyName.Version);
BinaryFileType binaryFileTypeContribution = client.GetDataByGuid <BinaryFileType>("api/BinaryFileTypes", new Guid(Rock.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE));
DefinedValue currencyTypeValueCheck = client.GetDataByGuid <DefinedValue>("api/DefinedValues", new Guid(Rock.SystemGuid.DefinedValue.CURRENCY_TYPE_CHECK));
DefinedValue transactionTypeValueContribution = client.GetDataByGuid <DefinedValue>("api/DefinedValues", new Guid(Rock.SystemGuid.DefinedValue.TRANSACTION_TYPE_CONTRIBUTION));
DefinedValue transactionImageTypeValueFront = client.GetDataByGuid <DefinedValue>("api/DefinedValues", new Guid(Rock.SystemGuid.DefinedValue.TRANSACTION_IMAGE_TYPE_CHECK_FRONT));
DefinedValue transactionImageTypeValueBack = client.GetDataByGuid <DefinedValue>("api/DefinedValues", new Guid(Rock.SystemGuid.DefinedValue.TRANSACTION_IMAGE_TYPE_CHECK_BACK));
int totalCount = ScannedCheckList.Where(a => !a.Uploaded).Count();
int position = 1;
foreach (ScannedCheckInfo scannedCheckInfo in ScannedCheckList.Where(a => !a.Uploaded))
{
// upload image of front of check
BinaryFile binaryFileFront = new BinaryFile();
binaryFileFront.Guid = Guid.NewGuid();
binaryFileFront.FileName = string.Format("{0}_{1}_{2}_front.png", scannedCheckInfo.RoutingNumber, scannedCheckInfo.MaskedAccountNumber, scannedCheckInfo.CheckNumber);
binaryFileFront.BinaryFileTypeId = binaryFileTypeContribution.Id;
binaryFileFront.IsSystem = false;
binaryFileFront.MimeType = "image/png";
client.PostData <BinaryFile>("api/BinaryFiles/", binaryFileFront);
// upload image data content of front of check
binaryFileFront.Data = new BinaryFileData();
binaryFileFront.Data.Content = scannedCheckInfo.FrontImagePngBytes;
binaryFileFront.Data.Id = client.GetDataByGuid <BinaryFile>("api/BinaryFiles/", binaryFileFront.Guid).Id;
client.PostData <BinaryFileData>("api/BinaryFileDatas/", binaryFileFront.Data);
// upload image of back of check (if it exists)
BinaryFile binaryFileBack = null;
if (scannedCheckInfo.BackImageData != null)
{
binaryFileBack = new BinaryFile();
binaryFileBack.Guid = Guid.NewGuid();
binaryFileBack.FileName = string.Format("{0}_{1}_{2}_back.png", scannedCheckInfo.RoutingNumber, scannedCheckInfo.MaskedAccountNumber, scannedCheckInfo.CheckNumber);
// upload image of back of check
binaryFileBack.BinaryFileTypeId = binaryFileTypeContribution.Id;
binaryFileBack.IsSystem = false;
binaryFileBack.MimeType = "image/png";
client.PostData <BinaryFile>("api/BinaryFiles/", binaryFileBack);
// upload image data content of back of check
binaryFileBack.Data = new BinaryFileData();
binaryFileBack.Data.Content = scannedCheckInfo.BackImagePngBytes;
binaryFileBack.Data.Id = client.GetDataByGuid <BinaryFile>("api/BinaryFiles/", binaryFileBack.Guid).Id;
client.PostData <BinaryFileData>("api/BinaryFileDatas/", binaryFileBack.Data);
}
int percentComplete = position++ *100 / totalCount;
bw.ReportProgress(percentComplete);
FinancialTransactionScannedCheck financialTransactionScannedCheck = new FinancialTransactionScannedCheck();
financialTransactionScannedCheck.BatchId = SelectedFinancialBatchId;
financialTransactionScannedCheck.Amount = 0.00M;
financialTransactionScannedCheck.TransactionCode = string.Empty;
financialTransactionScannedCheck.Summary = string.Format("Scanned Check from {0}", appInfo);
financialTransactionScannedCheck.Guid = Guid.NewGuid();
financialTransactionScannedCheck.TransactionDateTime = DateTime.Now;
financialTransactionScannedCheck.CurrencyTypeValueId = currencyTypeValueCheck.Id;
financialTransactionScannedCheck.CreditCardTypeValueId = null;
financialTransactionScannedCheck.SourceTypeValueId = null;
financialTransactionScannedCheck.AuthorizedPersonId = this.LoggedInPerson.Id;
financialTransactionScannedCheck.TransactionTypeValueId = transactionTypeValueContribution.Id;
// Rock server will encrypt CheckMicrPlainText to this since we can't have the DataEncryptionKey in a RestClient
financialTransactionScannedCheck.CheckMicrEncrypted = null;
financialTransactionScannedCheck.ScannedCheckMicr = string.Format("{0}_{1}_{2}", scannedCheckInfo.RoutingNumber, scannedCheckInfo.AccountNumber, scannedCheckInfo.CheckNumber);
client.PostData <FinancialTransactionScannedCheck>("api/FinancialTransactions/PostScanned", financialTransactionScannedCheck);
// get the FinancialTransaction back from server so that we can get it's Id
financialTransactionScannedCheck.Id = client.GetDataByGuid <FinancialTransaction>("api/FinancialTransactions", financialTransactionScannedCheck.Guid).Id;
// get the BinaryFiles back so that we can get their Ids
binaryFileFront.Id = client.GetDataByGuid <BinaryFile>("api/BinaryFiles", binaryFileFront.Guid).Id;
// upload FinancialTransactionImage records for front/back
FinancialTransactionImage financialTransactionImageFront = new FinancialTransactionImage();
financialTransactionImageFront.BinaryFileId = binaryFileFront.Id;
financialTransactionImageFront.TransactionId = financialTransactionScannedCheck.Id;
financialTransactionImageFront.TransactionImageTypeValueId = transactionImageTypeValueFront.Id;
client.PostData <FinancialTransactionImage>("api/FinancialTransactionImages", financialTransactionImageFront);
if (binaryFileBack != null)
{
// get the BinaryFiles back so that we can get their Ids
binaryFileBack.Id = client.GetDataByGuid <BinaryFile>("api/BinaryFiles", binaryFileBack.Guid).Id;
FinancialTransactionImage financialTransactionImageBack = new FinancialTransactionImage();
financialTransactionImageBack.BinaryFileId = binaryFileBack.Id;
financialTransactionImageBack.TransactionId = financialTransactionScannedCheck.Id;
financialTransactionImageBack.TransactionImageTypeValueId = transactionImageTypeValueBack.Id;
client.PostData <FinancialTransactionImage>("api/FinancialTransactionImages", financialTransactionImageBack);
}
scannedCheckInfo.Uploaded = true;
}
}
/// <summary>
/// Uploads the scanned item.
/// </summary>
/// <param name="scannedDocInfo">The scanned document information.</param>
public static void UploadScannedItem(ScannedDocInfo scannedDocInfo)
{
RockRestClient client = EnsureUploadScanRestClient();
// upload image of front of doc (if was successfully scanned)
int?frontImageBinaryFileId = null;
if (scannedDocInfo.FrontImageData != null)
{
string frontImageFileName = string.Format("image1_{0}.png", DateTime.Now.ToString("o").RemoveSpecialCharacters());
frontImageBinaryFileId = client.UploadBinaryFile(frontImageFileName, Rock.Client.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE.AsGuid(), scannedDocInfo.FrontImagePngBytes, false);
}
// upload image of back of doc (if it exists)
int?backImageBinaryFileId = null;
if (scannedDocInfo.BackImageData != null)
{
// upload image of back of doc
string backImageFileName = string.Format("image2_{0}.png", DateTime.Now.ToString("o").RemoveSpecialCharacters());
backImageBinaryFileId = client.UploadBinaryFile(backImageFileName, Rock.Client.SystemGuid.BinaryFiletype.CONTRIBUTION_IMAGE.AsGuid(), scannedDocInfo.BackImagePngBytes, false);
}
FinancialPaymentDetail financialPaymentDetail = new FinancialPaymentDetail();
financialPaymentDetail.CurrencyTypeValueId = scannedDocInfo.CurrencyTypeValue.Id;
financialPaymentDetail.Guid = Guid.NewGuid();
var financialPaymentDetailId = client.PostData <FinancialPaymentDetail>("api/FinancialPaymentDetails", financialPaymentDetail).AsIntegerOrNull();
FinancialTransaction financialTransaction = new FinancialTransaction();
financialTransaction.BatchId = batchPage.SelectedFinancialBatch.Id;
financialTransaction.TransactionCode = string.Empty;
financialTransaction.Summary = string.Empty;
financialTransaction.Guid = Guid.NewGuid();
financialTransaction.TransactionDateTime = batchPage.SelectedFinancialBatch.BatchStartDateTime;
financialTransaction.FinancialPaymentDetailId = financialPaymentDetailId;
financialTransaction.SourceTypeValueId = scannedDocInfo.SourceTypeValue.Id;
financialTransaction.TransactionTypeValueId = transactionTypeValueContribution.Id;
var accounts = scannedDocInfo.AccountAmountCaptureList;
if (accounts != null)
{
var accountsWithValues = accounts.Where(a => a.Amount > 0).ToList();
if (accountsWithValues != null && accountsWithValues.Count() > 0)
{
AddFinancialTransactionDetailForEachAccount(accountsWithValues, financialTransaction);
}
}
int?uploadedTransactionId;
if (scannedDocInfo.IsCheck)
{
financialTransaction.TransactionCode = scannedDocInfo.CheckNumber;
financialTransaction.MICRStatus = scannedDocInfo.BadMicr ? MICRStatus.Fail : MICRStatus.Success;
FinancialTransactionScannedCheck financialTransactionScannedCheck = new FinancialTransactionScannedCheck();
// Rock server will encrypt CheckMicrPlainText to this since we can't have the DataEncryptionKey in a RestClient
financialTransactionScannedCheck.FinancialTransaction = financialTransaction;
financialTransactionScannedCheck.ScannedCheckMicrData = scannedDocInfo.ScannedCheckMicrData;
financialTransactionScannedCheck.ScannedCheckMicrParts = scannedDocInfo.ScannedCheckMicrParts;
uploadedTransactionId = client.PostData <FinancialTransactionScannedCheck>("api/FinancialTransactions/PostScanned", financialTransactionScannedCheck).AsIntegerOrNull();
}
else
{
//FinancialTransactionDetail
uploadedTransactionId = client.PostData <FinancialTransaction>("api/FinancialTransactions", financialTransaction as FinancialTransaction).AsIntegerOrNull();
}
// upload FinancialTransactionImage records for front/back
if (frontImageBinaryFileId.HasValue)
{
FinancialTransactionImage financialTransactionImageFront = new FinancialTransactionImage();
financialTransactionImageFront.BinaryFileId = frontImageBinaryFileId.Value;
financialTransactionImageFront.TransactionId = uploadedTransactionId.Value;
financialTransactionImageFront.Order = 0;
financialTransactionImageFront.Guid = Guid.NewGuid();
client.PostData <FinancialTransactionImage>("api/FinancialTransactionImages", financialTransactionImageFront);
}
if (backImageBinaryFileId.HasValue)
{
FinancialTransactionImage financialTransactionImageBack = new FinancialTransactionImage();
financialTransactionImageBack.BinaryFileId = backImageBinaryFileId.Value;
financialTransactionImageBack.TransactionId = uploadedTransactionId.Value;
financialTransactionImageBack.Order = 1;
financialTransactionImageBack.Guid = Guid.NewGuid();
client.PostData <FinancialTransactionImage>("api/FinancialTransactionImages", financialTransactionImageBack);
}
scannedDocInfo.TransactionId = uploadedTransactionId;
financialTransaction.Id = uploadedTransactionId ?? 0;
financialTransaction.CreatedDateTime = financialTransaction.CreatedDateTime ?? DateTime.Now;
batchPage.SelectedFinancialBatch.Transactions.Add(financialTransaction);
var transactionList = batchPage.grdBatchItems.DataContext as BindingList <FinancialTransaction>;
transactionList.Insert(0, financialTransaction);
ItemsUploaded++;
}
/// <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 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>
/// Gets the image record for a specific transaction image (type 50 and 52).
/// </summary>
/// <param name="fileFormat">The file format that contains the configuration to use.</param>
/// <param name="transaction">The transaction being deposited.</param>
/// <param name="image">The check image scanned by the scanning application.</param>
/// <param name="isFront">if set to <c>true</c> [is front].</param>
/// <returns>A collection of records.</returns>
protected virtual List <X937.Record> GetImageRecords(ImageCashLetterFileFormat fileFormat, FinancialTransaction transaction, FinancialTransactionImage image, bool isFront)
{
var routingNumber = Rock.Security.Encryption.DecryptString(GetAttributeValue(fileFormat, "RoutingNumber"));
var accountNumber = Rock.Security.Encryption.DecryptString(GetAttributeValue(fileFormat, "AccountNumber"));
//
// Get the Image View Detail record (type 50).
//
var detail = new X937.Records.ImageViewDetail
{
ImageIndicator = 1,
ImageCreatorRoutingNumber = routingNumber,
ImageCreatorDate = image.CreatedDateTime ?? DateTime.Now,
ImageViewFormatIndicator = 0,
CompressionAlgorithmIdentifier = 0,
SideIndicator = isFront ? 0 : 1,
ViewDescriptor = 0,
DigitalSignatureIndicator = 0
};
//
// Get the Image View Data record (type 51).
//
var data = new X937.Records.ImageViewData
{
InstitutionRoutingNumber = routingNumber,
BundleBusinessDate = DateTime.Now,
ClientInstitutionItemSequenceNumber = accountNumber,
ClippingOrigin = 0,
ImageData = image.BinaryFile.ContentStream.ReadBytesToEnd()
};
return(new List <X937.Record> {
detail, data
});
}
/// <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);
}
}
