/// <summary>
/// Delete data from current recurring gift batch
/// </summary>
/// <param name="ABatchNumber"></param>
public void DeleteRecurringBatchGiftData(Int32 ABatchNumber)
{
DataView RecurringGiftDetailView = new DataView(FMainDS.ARecurringGiftDetail);
RecurringGiftDetailView.RowFilter = String.Format("{0}={1}",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
ABatchNumber);
RecurringGiftDetailView.Sort = String.Format("{0} DESC, {1} DESC",
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
ARecurringGiftDetailTable.GetDetailNumberDBName());
foreach (DataRowView dr in RecurringGiftDetailView)
{
ARecurringGiftDetailRow gdr = (ARecurringGiftDetailRow)dr.Row;
dr.Delete();
}
DataView RecurringGiftView = new DataView(FMainDS.ARecurringGift);
RecurringGiftView.RowFilter = String.Format("{0}={1}",
ARecurringGiftTable.GetBatchNumberDBName(),
ABatchNumber);
RecurringGiftView.Sort = String.Format("{0} DESC",
ARecurringGiftTable.GetGiftTransactionNumberDBName());
foreach (DataRowView dr in RecurringGiftView)
{
dr.Delete();
}
}
/// <summary>
/// Update all donor names in gift details table
/// </summary>
/// <param name="ABatchNumber"></param>
private void UpdateAllDonorNames(Int32 ABatchNumber)
{
Dictionary <Int32, Int64> GiftsDict = new Dictionary <Int32, Int64>();
Dictionary <Int64, string> DonorsDict = new Dictionary <Int64, string>();
DataView GiftDV = new DataView(FMainDS.ARecurringGift);
GiftDV.RowFilter = string.Format("{0}={1}",
ARecurringGiftTable.GetBatchNumberDBName(),
ABatchNumber);
GiftDV.Sort = string.Format("{0} ASC", ARecurringGiftTable.GetGiftTransactionNumberDBName());
foreach (DataRowView drv in GiftDV)
{
ARecurringGiftRow gr = (ARecurringGiftRow)drv.Row;
Int64 donorKey = gr.DonorKey;
GiftsDict.Add(gr.GiftTransactionNumber, donorKey);
if (!DonorsDict.ContainsKey(donorKey))
{
if (donorKey != 0)
{
PPartnerRow pr = RetrieveDonorRow(donorKey);
if (pr != null)
{
DonorsDict.Add(donorKey, pr.PartnerShortName);
}
}
else
{
DonorsDict.Add(0, "");
}
}
}
//Add donor info to gift details
DataView GiftDetailDV = new DataView(FMainDS.ARecurringGiftDetail);
GiftDetailDV.RowFilter = string.Format("{0}={1}",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
ABatchNumber);
GiftDetailDV.Sort = string.Format("{0} ASC", ARecurringGiftDetailTable.GetGiftTransactionNumberDBName());
foreach (DataRowView drv in GiftDetailDV)
{
GiftBatchTDSARecurringGiftDetailRow giftDetail = (GiftBatchTDSARecurringGiftDetailRow)drv.Row;
Int64 donorKey = GiftsDict[giftDetail.GiftTransactionNumber];
giftDetail.DonorKey = donorKey;
giftDetail.DonorName = DonorsDict[donorKey];
}
}
private void SetBatchLastGiftNumber()
{
DataView dv = new DataView(FMainDS.ARecurringGift);
dv.RowFilter = String.Format("{0}={1}",
ARecurringGiftTable.GetBatchNumberDBName(),
FBatchNumber);
dv.Sort = String.Format("{0} DESC",
ARecurringGiftTable.GetGiftTransactionNumberDBName());
dv.RowStateFilter = DataViewRowState.CurrentRows;
if (dv.Count > 0)
{
ARecurringGiftRow transRow = (ARecurringGiftRow)dv[0].Row;
FBatchRow.LastGiftNumber = transRow.GiftTransactionNumber;
}
else
{
FBatchRow.LastGiftNumber = 0;
}
}
public static SponsorshipTDS GetChildDetails(Int64 APartnerKey,
Int32 ALedgerNumber,
bool AWithPhoto,
out string ASponsorshipStatus)
{
SponsorshipTDS MainDS = new SponsorshipTDS();
TDBTransaction Transaction = new TDBTransaction();
DBAccess.ReadTransaction(ref Transaction,
delegate
{
PPartnerAccess.LoadByPrimaryKey(MainDS, APartnerKey, Transaction);
PFamilyAccess.LoadByPrimaryKey(MainDS, APartnerKey, Transaction);
PPartnerTypeAccess.LoadViaPPartner(MainDS, APartnerKey, Transaction);
PPartnerCommentAccess.LoadViaPPartner(MainDS, APartnerKey, Transaction);
PPartnerReminderAccess.LoadViaPPartner(MainDS, APartnerKey, Transaction);
if (!AWithPhoto && (MainDS.PFamily.Rows.Count == 1))
{
MainDS.PFamily[0].Photo = "";
}
int SponsorshipBatchNumber = GetRecurringGiftBatchForSponsorship(ALedgerNumber, Transaction);
if (SponsorshipBatchNumber > -1)
{
ARecurringGiftBatchAccess.LoadByPrimaryKey(MainDS, ALedgerNumber, SponsorshipBatchNumber, Transaction);
ARecurringGiftAccess.LoadViaARecurringGiftBatch(MainDS, ALedgerNumber, SponsorshipBatchNumber, Transaction);
ARecurringGiftDetailAccess.LoadViaARecurringGiftBatch(MainDS, ALedgerNumber, SponsorshipBatchNumber, Transaction);
GiftBatchTDS GiftDS = new GiftBatchTDS();
TGiftTransactionWebConnector.LoadGiftDonorRelatedData(GiftDS, true, ALedgerNumber, SponsorshipBatchNumber, Transaction);
for (int i = 0; i < MainDS.ARecurringGiftDetail.Count;)
{
SponsorshipTDSARecurringGiftDetailRow gdr = MainDS.ARecurringGiftDetail[i];
// drop all recurring gift details, that are not related to this child (RecipientKey)
if (gdr.RecipientKey != APartnerKey)
{
MainDS.ARecurringGiftDetail.Rows.RemoveAt(i);
}
else
{
i++;
// set the donor key from the appropriate recurring gift
MainDS.ARecurringGift.DefaultView.RowFilter = String.Format("{0} = {1}",
ARecurringGiftTable.GetGiftTransactionNumberDBName(),
gdr.GiftTransactionNumber);
// there should be only one row
foreach (DataRowView drv in MainDS.ARecurringGift.DefaultView)
{
ARecurringGiftRow recurrGiftRow = (ARecurringGiftRow)drv.Row;
gdr.DonorKey = recurrGiftRow.DonorKey;
PPartnerRow donorRow = (PPartnerRow)GiftDS.DonorPartners.Rows.Find(recurrGiftRow.DonorKey);
gdr.DonorName = donorRow.PartnerShortName;
gdr.CurrencyCode = MainDS.ARecurringGiftBatch[0].CurrencyCode;
}
}
}
// drop all unrelated gift rows, that don't have a detail for this child
for (int i = 0; i < MainDS.ARecurringGift.Count;)
{
ARecurringGiftRow gr = MainDS.ARecurringGift[0];
MainDS.ARecurringGiftDetail.DefaultView.RowFilter = String.Format("{0} = {1}",
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
gr.GiftTransactionNumber);
if (MainDS.ARecurringGiftDetail.DefaultView.Count == 0)
{
MainDS.ARecurringGift.Rows.RemoveAt(i);
}
else
{
i++;
}
}
}
});
bool isSponsoredChild = false;
ASponsorshipStatus = "[N/A]";
foreach (PPartnerTypeRow type in MainDS.PPartnerType.Rows)
{
if (type.TypeCode == "CHILDREN_HOME" || type.TypeCode == "HOME_BASED" || type.TypeCode == "BOARDING_SCHOOL" || type.TypeCode == "PREVIOUS_CHILD" || type.TypeCode == "CHILD_DIED")
{
isSponsoredChild = true;
}
ASponsorshipStatus = type.TypeCode;
}
if (!isSponsoredChild)
{
return(new SponsorshipTDS());
}
return(MainDS);
}
private bool OnDeleteRowManual(GiftBatchTDSARecurringGiftDetailRow ARowToDelete, ref string ACompletionMessage)
{
//TODO: Make this like deleton on GL Transactions form
// e.g. pass copy to delete method on server...
//GiftBatchTDS TempDS = (GiftBatchTDS)FMainDS.Copy();
//TempDS.Merge(FMainDS);
bool DeletionSuccessful = false;
ACompletionMessage = string.Empty;
if (FBatchRow == null)
{
FBatchRow = GetRecurringBatchRow();
}
if (ARowToDelete == null)
{
return(false);
}
int CurrentBatchNo = ARowToDelete.BatchNumber;
bool RowToDeleteIsNew = (ARowToDelete.RowState == DataRowState.Added);
int CurrentRowIndex = GetSelectedRowIndex();
TFrmRecurringGiftBatch FMyForm = (TFrmRecurringGiftBatch)this.ParentForm;
GiftBatchTDS BackupMainDS = null;
int SelectedDetailNumber = ARowToDelete.DetailNumber;
int RecurringGiftToDeleteTransNo = 0;
string FilterAllRecurringGiftsOfBatch = String.Empty;
string FilterAllRecurringGiftDetailsOfBatch = String.Empty;
int DetailRowCount = FGiftDetailView.Count;
try
{
this.Cursor = Cursors.WaitCursor;
//Specify current action
FMyForm.FCurrentGiftBatchAction = Logic.TExtraGiftBatchChecks.GiftBatchAction.DELETINGTRANS;
//Speeds up deletion of larger gift sets
FMainDS.EnforceConstraints = false;
// temporarily disable New Donor Warning
FMyForm.NewDonorWarning = false;
//Backup the Dataset for reversion purposes
BackupMainDS = (GiftBatchTDS)FMainDS.GetChangesTyped(false);
//Don't run an inactive fields check on this batch
FMyForm.GetBatchControl().UpdateRecurringBatchDictionary(CurrentBatchNo);
//Delete current row
ARowToDelete.RejectChanges();
if (!RowToDeleteIsNew)
{
ShowDetails(ARowToDelete);
}
ARowToDelete.Delete();
//If there existed (before the delete row above) more than one detail row, then no need to delete Recurring Gift header row
if (DetailRowCount > 1)
{
ACompletionMessage = Catalog.GetString("Recurring Gift Detail row deleted successfully!");
FGiftSelectedForDeletionFlag = false;
foreach (DataRowView rv in FGiftDetailView)
{
GiftBatchTDSARecurringGiftDetailRow row = (GiftBatchTDSARecurringGiftDetailRow)rv.Row;
if (row.DetailNumber > SelectedDetailNumber)
{
row.DetailNumber--;
}
}
FGift.LastDetailNumber--;
}
else
{
ACompletionMessage = Catalog.GetString("Recurring Gift deleted successfully!");
RecurringGiftToDeleteTransNo = FGift.GiftTransactionNumber;
// Reduce all Recurring Gift Detail row Transaction numbers by 1 if they are greater then Recurring Gift to be deleted
FilterAllRecurringGiftDetailsOfBatch = String.Format("{0}={1} And {2}>{3}",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
FBatchNumber,
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
RecurringGiftToDeleteTransNo);
DataView RecurringGiftDetailView = new DataView(FMainDS.ARecurringGiftDetail);
RecurringGiftDetailView.RowFilter = FilterAllRecurringGiftDetailsOfBatch;
RecurringGiftDetailView.Sort = String.Format("{0} ASC", ARecurringGiftDetailTable.GetGiftTransactionNumberDBName());
foreach (DataRowView rv in RecurringGiftDetailView)
{
GiftBatchTDSARecurringGiftDetailRow row = (GiftBatchTDSARecurringGiftDetailRow)rv.Row;
row.GiftTransactionNumber--;
}
//Cannot delete the Recurring Gift row, just copy the data of rows above down by 1 row
// and then mark the top row for deletion
//In other words, bubble the Recurring Gift row to be deleted to the top
FilterAllRecurringGiftsOfBatch = String.Format("{0}={1} And {2}>={3}",
ARecurringGiftTable.GetBatchNumberDBName(),
FBatchNumber,
ARecurringGiftTable.GetGiftTransactionNumberDBName(),
RecurringGiftToDeleteTransNo);
DataView RecurringGiftView = new DataView(FMainDS.ARecurringGift);
RecurringGiftView.RowFilter = FilterAllRecurringGiftsOfBatch;
RecurringGiftView.Sort = String.Format("{0} ASC", ARecurringGiftTable.GetGiftTransactionNumberDBName());
ARecurringGiftRow RecurringGiftRowToReceive = null;
ARecurringGiftRow RecurringGiftRowToCopyDown = null;
ARecurringGiftRow RecurringGiftRowCurrent = null;
int currentRecurringGiftTransNo = 0;
foreach (DataRowView gv in RecurringGiftView)
{
RecurringGiftRowCurrent = (ARecurringGiftRow)gv.Row;
currentRecurringGiftTransNo = RecurringGiftRowCurrent.GiftTransactionNumber;
if (currentRecurringGiftTransNo > RecurringGiftToDeleteTransNo)
{
RecurringGiftRowToCopyDown = RecurringGiftRowCurrent;
//Copy column values down
for (int j = 3; j < RecurringGiftRowToCopyDown.Table.Columns.Count; j++)
{
//Update all columns except the pk fields that remain the same
if (!RecurringGiftRowToCopyDown.Table.Columns[j].ColumnName.EndsWith("_text"))
{
RecurringGiftRowToReceive[j] = RecurringGiftRowToCopyDown[j];
}
}
}
if (currentRecurringGiftTransNo == FBatchRow.LastGiftNumber)
{
//Mark last record for deletion
RecurringGiftRowCurrent.ChargeStatus = MFinanceConstants.MARKED_FOR_DELETION;
}
//Will always be previous row
RecurringGiftRowToReceive = RecurringGiftRowCurrent;
}
FPreviouslySelectedDetailRow = null;
FGiftSelectedForDeletionFlag = true;
FBatchRow.LastGiftNumber--;
}
//Save and check for inactive values and ex-workers and anonymous gifts
// in other unsaved Batches
FPetraUtilsObject.SetChangedFlag();
if (!FMyForm.SaveChangesManual(Logic.TExtraGiftBatchChecks.GiftBatchAction.DELETINGTRANS, false, false))
{
FMyForm.GetBatchControl().UpdateRecurringBatchDictionary();
MessageBox.Show(Catalog.GetString("The gift detail has been deleted but the changes are not saved!"),
Catalog.GetString("Deletion Warning"),
MessageBoxButtons.OK,
MessageBoxIcon.Warning);
ACompletionMessage = string.Empty;
if (FGiftSelectedForDeletionFlag)
{
FGiftSelectedForDeletionFlag = false;
SetBatchLastGiftNumber();
UpdateControlsProtection();
}
UpdateTotals();
return(false);
}
//Clear current batch's gift data and reload from server
RefreshRecurringBatchGiftData(FBatchNumber, true);
DeletionSuccessful = true;
}
catch (Exception ex)
{
//Revert to previous state
RevertDataSet(FMainDS, BackupMainDS, CurrentRowIndex);
TLogging.LogException(ex, Utilities.GetMethodSignature());
throw;
}
finally
{
FMyForm.NewDonorWarning = true;
FMainDS.EnforceConstraints = true;
FMyForm.FCurrentGiftBatchAction = Logic.TExtraGiftBatchChecks.GiftBatchAction.NONE;
this.Cursor = Cursors.Default;
}
SetGiftDetailDefaultView();
FFilterAndFindObject.ApplyFilter();
UpdateRecordNumberDisplay();
return(DeletionSuccessful);
}
private bool OnDeleteRowManual(GiftBatchTDSARecurringGiftDetailRow ARowToDelete, ref string ACompletionMessage)
{
bool DeletionSuccessful = false;
ACompletionMessage = string.Empty;
if (ARowToDelete == null)
{
return(DeletionSuccessful);
}
bool RowToDeleteIsNew = (ARowToDelete.RowState == DataRowState.Added);
if (!RowToDeleteIsNew)
{
try
{
// temporarily disable New Donor Warning
((TFrmRecurringGiftBatch)this.ParentForm).NewDonorWarning = false;
//Return modified row to last saved state to avoid validation failures
ARowToDelete.RejectChanges();
ShowDetails(ARowToDelete);
if (!((TFrmRecurringGiftBatch)this.ParentForm).SaveChanges())
{
MessageBox.Show(Catalog.GetString("Error in trying to save prior to deleting current Gift detail!"),
Catalog.GetString("Deletion Error"),
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return(DeletionSuccessful);
}
}
finally
{
((TFrmRecurringGiftBatch)this.ParentForm).NewDonorWarning = true;
}
}
//Backup the Dataset for reversion purposes
GiftBatchTDS BackupMainDS = (GiftBatchTDS)FMainDS.Copy();
BackupMainDS.Merge(FMainDS);
//To be used later....Pass copy to delete method.
//RecurringGiftBatchTDS TempDS = (RecurringGiftBatchTDS)FMainDS.Copy();
//TempDS.Merge(FMainDS);
int SelectedDetailNumber = ARowToDelete.DetailNumber;
int RecurringGiftToDeleteTransNo = 0;
string FilterAllRecurringGiftsOfBatch = String.Empty;
string FilterAllRecurringGiftDetailsOfBatch = String.Empty;
int DetailRowCount = FGiftDetailView.Count;
try
{
this.Cursor = Cursors.WaitCursor;
//Speeds up deletion of larger Recurring Gift sets
FMainDS.EnforceConstraints = false;
//Delete current detail row
ARowToDelete.Delete();
//If there existed (before the delete row above) more than one detail row, then no need to delete Recurring Gift header row
if (DetailRowCount > 1)
{
ACompletionMessage = Catalog.GetString("Recurring Gift Detail row deleted successfully!");
FGiftSelectedForDeletion = false;
foreach (DataRowView rv in FGiftDetailView)
{
GiftBatchTDSARecurringGiftDetailRow row = (GiftBatchTDSARecurringGiftDetailRow)rv.Row;
if (row.DetailNumber > SelectedDetailNumber)
{
row.DetailNumber--;
}
}
FGift.LastDetailNumber--;
FPetraUtilsObject.SetChangedFlag();
}
else
{
ACompletionMessage = Catalog.GetString("Recurring Gift deleted successfully!");
RecurringGiftToDeleteTransNo = FGift.GiftTransactionNumber;
// Reduce all Recurring Gift Detail row Transaction numbers by 1 if they are greater then Recurring Gift to be deleted
FilterAllRecurringGiftDetailsOfBatch = String.Format("{0}={1} And {2}>{3}",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
FBatchNumber,
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
RecurringGiftToDeleteTransNo);
DataView RecurringGiftDetailView = new DataView(FMainDS.ARecurringGiftDetail);
RecurringGiftDetailView.RowFilter = FilterAllRecurringGiftDetailsOfBatch;
RecurringGiftDetailView.Sort = String.Format("{0} ASC", ARecurringGiftDetailTable.GetGiftTransactionNumberDBName());
foreach (DataRowView rv in RecurringGiftDetailView)
{
GiftBatchTDSARecurringGiftDetailRow row = (GiftBatchTDSARecurringGiftDetailRow)rv.Row;
row.GiftTransactionNumber--;
}
//Cannot delete the Recurring Gift row, just copy the data of rows above down by 1 row
// and then mark the top row for deletion
//In other words, bubble the Recurring Gift row to be deleted to the top
FilterAllRecurringGiftsOfBatch = String.Format("{0}={1} And {2}>={3}",
ARecurringGiftTable.GetBatchNumberDBName(),
FBatchNumber,
ARecurringGiftTable.GetGiftTransactionNumberDBName(),
RecurringGiftToDeleteTransNo);
DataView RecurringGiftView = new DataView(FMainDS.ARecurringGift);
RecurringGiftView.RowFilter = FilterAllRecurringGiftsOfBatch;
RecurringGiftView.Sort = String.Format("{0} ASC", ARecurringGiftTable.GetGiftTransactionNumberDBName());
ARecurringGiftRow RecurringGiftRowToReceive = null;
ARecurringGiftRow RecurringGiftRowToCopyDown = null;
ARecurringGiftRow RecurringGiftRowCurrent = null;
int currentRecurringGiftTransNo = 0;
foreach (DataRowView gv in RecurringGiftView)
{
RecurringGiftRowCurrent = (ARecurringGiftRow)gv.Row;
currentRecurringGiftTransNo = RecurringGiftRowCurrent.GiftTransactionNumber;
if (currentRecurringGiftTransNo > RecurringGiftToDeleteTransNo)
{
RecurringGiftRowToCopyDown = RecurringGiftRowCurrent;
//Copy column values down
for (int j = 3; j < RecurringGiftRowToCopyDown.Table.Columns.Count; j++)
{
//Update all columns except the pk fields that remain the same
if (!RecurringGiftRowToCopyDown.Table.Columns[j].ColumnName.EndsWith("_text"))
{
RecurringGiftRowToReceive[j] = RecurringGiftRowToCopyDown[j];
}
}
}
if (currentRecurringGiftTransNo == FBatchRow.LastGiftNumber)
{
//Mark last record for deletion
RecurringGiftRowCurrent.ChargeStatus = MFinanceConstants.MARKED_FOR_DELETION;
}
//Will always be previous row
RecurringGiftRowToReceive = RecurringGiftRowCurrent;
}
FPreviouslySelectedDetailRow = null;
FPetraUtilsObject.SetChangedFlag();
FGiftSelectedForDeletion = true;
FBatchRow.LastGiftNumber--;
}
//Try to save changes
if (((TFrmRecurringGiftBatch)this.ParentForm).SaveChangesManual())
{
//Clear current batch's Recurring Gift data and reload from server
RefreshCurrentRecurringBatchGiftData(FBatchNumber, true);
}
else
{
throw new Exception("Unable to save after deleting a Recurring Gift!");
}
DeletionSuccessful = true;
}
catch (Exception ex)
{
//Revert to previous state
RevertDataSet(FMainDS, BackupMainDS);
TLogging.LogException(ex, Utilities.GetMethodSignature());
throw;
}
finally
{
FMainDS.EnforceConstraints = true;
SetGiftDetailDefaultView();
FFilterAndFindObject.ApplyFilter();
this.Cursor = Cursors.Default;
}
UpdateRecordNumberDisplay();
return(DeletionSuccessful);
}
/// <summary>
/// Get Unsaved Recurring Batch Rows in a list
/// </summary>
/// <param name="ABatchToInclude">If > 0 then include in list even if unchanged</param>
/// <returns></returns>
public List <ARecurringGiftBatchRow> GetUnsavedBatchRowsList(int ABatchToInclude = 0)
{
List <ARecurringGiftBatchRow> RetVal = new List <ARecurringGiftBatchRow>();
List <int> BatchesWithChangesList = new List <int>();
string BatchesWithChangesString = string.Empty;
DataView GiftBatchesDV = new DataView(FMainDS.ARecurringGiftBatch);
GiftBatchesDV.Sort = ARecurringGiftBatchTable.GetBatchNumberDBName() + " ASC";
DataView GiftDV = new DataView(FMainDS.ARecurringGift);
DataView GiftDetailsDV = new DataView(FMainDS.ARecurringGiftDetail);
GiftDV.Sort = String.Format("{0} ASC, {1} ASC",
ARecurringGiftTable.GetBatchNumberDBName(),
ARecurringGiftTable.GetGiftTransactionNumberDBName());
GiftDetailsDV.Sort = String.Format("{0} ASC, {1} ASC, {2} ASC",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
ARecurringGiftDetailTable.GetDetailNumberDBName());
//Add the batch number(s) of changed gift rows
foreach (DataRowView dRV in GiftDV)
{
ARecurringGiftRow gR = (ARecurringGiftRow)dRV.Row;
if (!BatchesWithChangesList.Contains(gR.BatchNumber) &&
(gR.RowState != DataRowState.Unchanged))
{
BatchesWithChangesList.Add(gR.BatchNumber);
}
}
//Generate string of all batches found with changes
if (BatchesWithChangesList.Count > 0)
{
BatchesWithChangesString = String.Join(",", BatchesWithChangesList);
//Add any other batch number(s) of changed gift details
GiftDetailsDV.RowFilter = String.Format("{0} NOT IN ({1})",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
BatchesWithChangesString);
}
foreach (DataRowView dRV in GiftDetailsDV)
{
ARecurringGiftDetailRow gDR = (ARecurringGiftDetailRow)dRV.Row;
if (!BatchesWithChangesList.Contains(gDR.BatchNumber) &&
(gDR.RowState != DataRowState.Unchanged))
{
BatchesWithChangesList.Add(gDR.BatchNumber);
}
}
BatchesWithChangesList.Sort();
//Get batch rows
foreach (DataRowView dRV in GiftBatchesDV)
{
ARecurringGiftBatchRow giftBatchRow = (ARecurringGiftBatchRow)dRV.Row;
if ((giftBatchRow.BatchNumber == ABatchToInclude) ||
BatchesWithChangesList.Contains(giftBatchRow.BatchNumber) ||
(giftBatchRow.RowState != DataRowState.Unchanged))
{
RetVal.Add(giftBatchRow);
}
}
return(RetVal);
}
/// <summary>
/// Undo all changes to the specified batch ready to delete it.
/// This avoids unecessary validation errors when deleting.
/// </summary>
/// <param name="ABatchToDelete"></param>
/// <param name="ARedisplay"></param>
public void PrepareBatchDataForDeleting(Int32 ABatchToDelete, bool ARedisplay)
{
//This code will only be called when the Batch tab is active.
DataView GiftBatchDV = new DataView(FMainDS.ARecurringGiftBatch);
DataView GiftDV = new DataView(FMainDS.ARecurringGift);
DataView GiftDetailDV = new DataView(FMainDS.ARecurringGiftDetail);
GiftBatchDV.RowFilter = String.Format("{0}={1}",
ARecurringGiftBatchTable.GetBatchNumberDBName(),
ABatchToDelete);
GiftDV.RowFilter = String.Format("{0}={1}",
AGiftTable.GetBatchNumberDBName(),
ABatchToDelete);
GiftDetailDV.RowFilter = String.Format("{0}={1}",
AGiftDetailTable.GetBatchNumberDBName(),
ABatchToDelete);
//Work from lowest level up
if (GiftDetailDV.Count > 0)
{
GiftDetailDV.Sort = String.Format("{0}, {1}",
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
ARecurringGiftDetailTable.GetDetailNumberDBName());
foreach (DataRowView drv in GiftDetailDV)
{
ARecurringGiftDetailRow gDR = (ARecurringGiftDetailRow)drv.Row;
if (gDR.RowState == DataRowState.Added)
{
//Do nothing
}
else if (gDR.RowState != DataRowState.Unchanged)
{
gDR.RejectChanges();
}
}
}
if (GiftDV.Count > 0)
{
GiftDV.Sort = String.Format("{0}", ARecurringGiftTable.GetGiftTransactionNumberDBName());
foreach (DataRowView drv in GiftDV)
{
ARecurringGiftRow gR = (ARecurringGiftRow)drv.Row;
if (gR.RowState == DataRowState.Added)
{
//Do nothing
}
else if (gR.RowState != DataRowState.Unchanged)
{
gR.RejectChanges();
}
}
}
if (GiftBatchDV.Count > 0)
{
ARecurringGiftBatchRow gB = (ARecurringGiftBatchRow)GiftBatchDV[0].Row;
//No need to check for Added state as new batches are always saved
// on creation
if (gB.RowState != DataRowState.Unchanged)
{
gB.RejectChanges();
}
if (ARedisplay)
{
ShowDetails(gB);
}
}
if (GiftDetailDV.Count == 0)
{
//Load all related data for batch ready to delete
FMainDS.Merge(TRemote.MFinance.Gift.WebConnectors.LoadRecurringGiftTransactionsForBatch(FLedgerNumber, ABatchToDelete));
}
}
/// <summary>
/// Clear the gift data of the current batch without marking records for delete
/// </summary>
private bool RefreshRecurringBatchGiftData(Int32 ABatchNumber,
bool AAcceptChanges = false,
bool AHandleDataSetBackup = false)
{
bool RetVal = false;
//Copy and backup the current dataset
GiftBatchTDS BackupDS = null;
GiftBatchTDS TempDS = (GiftBatchTDS)FMainDS.Copy();
TempDS.Merge(FMainDS);
if (AHandleDataSetBackup)
{
BackupDS = (GiftBatchTDS)FMainDS.GetChangesTyped(false);
}
try
{
this.Cursor = Cursors.WaitCursor;
//Remove current batch gift data
DataView giftDetailView = new DataView(TempDS.ARecurringGiftDetail);
giftDetailView.RowFilter = String.Format("{0}={1}",
ARecurringGiftDetailTable.GetBatchNumberDBName(),
ABatchNumber);
giftDetailView.Sort = String.Format("{0} DESC, {1} DESC",
ARecurringGiftDetailTable.GetGiftTransactionNumberDBName(),
ARecurringGiftDetailTable.GetDetailNumberDBName());
foreach (DataRowView dr in giftDetailView)
{
dr.Delete();
}
DataView giftView = new DataView(TempDS.ARecurringGift);
giftView.RowFilter = String.Format("{0}={1}",
ARecurringGiftTable.GetBatchNumberDBName(),
ABatchNumber);
giftView.Sort = String.Format("{0} DESC",
ARecurringGiftTable.GetGiftTransactionNumberDBName());
foreach (DataRowView dr in giftView)
{
dr.Delete();
}
TempDS.AcceptChanges();
//Clear all gift data from Main dataset gift tables
FMainDS.ARecurringGiftDetail.Clear();
FMainDS.ARecurringGift.Clear();
//Bring data back in from other batches if it exists
if (TempDS.ARecurringGift.Count > 0)
{
FMainDS.ARecurringGift.Merge(TempDS.ARecurringGift);
FMainDS.ARecurringGiftDetail.Merge(TempDS.ARecurringGiftDetail);
}
FMainDS.Merge(TRemote.MFinance.Gift.WebConnectors.LoadRecurringGiftTransactionsForBatch(FLedgerNumber, ABatchNumber));
if (AAcceptChanges)
{
FMainDS.AcceptChanges();
}
RetVal = true;
}
catch (Exception ex)
{
//If not revert on error then calling method will
if (AHandleDataSetBackup)
{
RevertDataSet(FMainDS, BackupDS);
}
TLogging.LogException(ex, Utilities.GetMethodSignature());
throw;
}
finally
{
this.Cursor = Cursors.Default;
}
return(RetVal);
}
