/// <summary>
/// Checks if the Publication that is selected in a ComboBox is valid. If it isn't valid,
/// a warning is shown to the user, asking the user as to whether the user still wants to use
/// this Publication for the Subscription that the user is working with.
/// </summary>
/// <param name="APublicationComboBox">ComboBox containing Publications.</param>
public static void CheckPublicationComboValidValue(TCmbAutoPopulated APublicationComboBox)
{
DataTable DataCachePublicationListTable;
PPublicationRow TmpRow;
string SelectedPublication;
if (APublicationComboBox == null)
{
throw new ArgumentNullException("APublicationComboBox must not be null");
}
SelectedPublication = APublicationComboBox.GetSelectedString();
if (!String.IsNullOrWhiteSpace(SelectedPublication))
{
DataCachePublicationListTable = TDataCache.TMPartner.GetCacheableSubscriptionsTable(TCacheableSubscriptionsTablesEnum.PublicationList);
TmpRow = (PPublicationRow)DataCachePublicationListTable.Rows.Find(
new Object[] { SelectedPublication });
if (TmpRow != null)
{
if (!TmpRow.ValidPublication)
{
if (MessageBox.Show(
Catalog.GetString(String.Format("Please note that Publication\r\n\r\n {0}\r\n\r\n" +
"is no longer available." + "\r\n\r\n" +
"Would you still like to use it for a Subscription?",
APublicationComboBox.GetSelectedString())),
Catalog.GetString("Publication Selection"),
MessageBoxButtons.YesNo, MessageBoxIcon.Question,
MessageBoxDefaultButton.Button2) == DialogResult.No)
{
APublicationComboBox.cmbCombobox.SelectedIndex = -1;
}
}
}
}
}
public void TestComboboxEmptyDescriptionBug()
{
TCmbAutoPopulated cmb = new TCmbAutoPopulated();
DataTable detailTable = TDataCache.TMFinance.GetCacheableFinanceTable(TCacheableFinanceTablesEnum.MotivationList, FLedgerNumber);
Assert.AreNotEqual(0, detailTable.Rows.Count, "There should be a motivation detail in the cached table");
cmb.Name = "TestCombobox";
cmb.InitialiseUserControl(detailTable,
AMotivationDetailTable.GetMotivationDetailCodeDBName(),
AMotivationDetailTable.GetMotivationDetailDescDBName(),
null);
cmb.AppearanceSetup(new int[] { -1, 150 }, -1);
Form TestForm = new Form();
TestForm.Controls.Add(cmb);
TestForm.Show();
cmb.SelectedIndex = 1;
Assert.AreEqual(cmb.GetSelectedString(), "KEYMIN");
Assert.AreEqual(cmb.GetSelectedDescription(), "Key Ministry Gift");
cmb.SelectedIndex = 0;
Assert.AreEqual(cmb.GetSelectedString(), "FIELD");
Assert.AreEqual(cmb.GetSelectedDescription(), "Field Gift");
}
private void RefreshAnalysisAttributesGrid(TCmbAutoPopulated ACombo, GLBatchTDS ADS)
{
TSgrdDataGridPaged Grid = null;
int TransactionNumber = 0;
if (ACombo.Name == cmbFromAccountCode.Name)
{
Grid = grdFromAnalAttributes;
TransactionNumber = FJournal.LastTransactionNumber + 1;
}
else
{
Grid = grdToAnalAttributes;
TransactionNumber = FCurrentTransactionNumber;
}
//Empty the grid
ADS.ATransAnalAttrib.DefaultView.RowFilter = "1=2";
FPSAttributesRow = null;
if (!TRemote.MFinance.Setup.WebConnectors.AccountHasAnalysisAttributes(FLedgerNumber, ACombo.GetSelectedString(),
true))
{
if (Grid.Enabled)
{
Grid.Enabled = false;
}
return;
}
else
{
if (!Grid.Enabled)
{
Grid.Enabled = true;
}
}
FAnalysisAttributesLogic.SetTransAnalAttributeDefaultView(ADS, true, TransactionNumber);
Grid.DataSource = new DevAge.ComponentModel.BoundDataView(ADS.ATransAnalAttrib.DefaultView);
if (Grid.Rows.Count > 1)
{
Grid.SelectRowWithoutFocus(1);
AnalysisAttributesGrid_RowSelected(Grid, null);
}
}
/// <summary>
/// ResetMotivationDetailCodeFilter
/// </summary>
private static void ResetMotivationDetailCodeFilter(TCmbAutoPopulated ACmbMotivationDetailCode,
ref string AMotivationDetail,
bool AActiveOnly)
{
if ((ACmbMotivationDetailCode.Count == 0) && (ACmbMotivationDetailCode.Filter != null)
&& (!ACmbMotivationDetailCode.Filter.Contains("1 = 2")))
{
AMotivationDetail = string.Empty;
ACmbMotivationDetailCode.RefreshLabel();
if (AActiveOnly)
{
//This is needed as the code in TFinanceControls.ChangeFilterMotivationDetailList looks for presence of the active only prefix
ACmbMotivationDetailCode.Filter = AMotivationDetailTable.GetMotivationStatusDBName() + " = true And 1 = 2";
}
else
{
ACmbMotivationDetailCode.Filter = "1 = 2";
}
return;
}
if (ACmbMotivationDetailCode.Count > 0)
{
AMotivationDetail = ACmbMotivationDetailCode.GetSelectedString();
}
if (AActiveOnly)
{
ACmbMotivationDetailCode.Filter = AMotivationDetailTable.GetMotivationStatusDBName() + " = true";
}
else
{
ACmbMotivationDetailCode.Filter = string.Empty;
}
ACmbMotivationDetailCode.SetSelectedString(AMotivationDetail);
ACmbMotivationDetailCode.RefreshLabel();
}
/// <summary>
/// Call when the motivation group changes
/// </summary>
public static void OnMotivationGroupChanged(GiftBatchTDSAGiftDetailRow AGiftBatchDetail,
GiftBatchTDS AMainDS,
Int32 ALedgerNumber,
TFrmPetraEditUtils APetraUtilsObject,
TCmbAutoPopulated ACmbKeyMinistries,
TCmbAutoPopulated ACmbMotivationGroupCode,
ref TCmbAutoPopulated ACmbMotivationDetailCode,
TtxtAutoPopulatedButtonLabel ATxtDetailRecipientKey,
Int64 ARecipientKey,
TtxtAutoPopulatedButtonLabel AtxtDetailRecipientLedgerNumber,
TextBox ATxtDetailCostCentreCode,
TextBox ATxtDetailAccountCode,
TextBox ATxtDetailRecipientKeyMinistry,
CheckBox AChkDetailTaxDeductible,
TextBox ATxtDeductibleAccount,
ref string AMotivationGroup,
ref string AMotivationDetail,
ref bool AMotivationDetailChangedFlag,
bool AActiveOnly,
bool ACreatingNewGiftFlag,
bool ARecipientKeyChangingFlag,
bool AInEditModeFlag,
bool ABatchUnpostedFlag,
bool ATaxDeductiblePercentageEnabledFlag,
out bool ADoTaxUpdate)
{
if (!ABatchUnpostedFlag || APetraUtilsObject.SuppressChangeDetection || !AInEditModeFlag || ATxtDetailRecipientKeyMinistry.Visible)
{
ADoTaxUpdate = false;
return;
}
AMotivationGroup = ACmbMotivationGroupCode.GetSelectedString();
if (!ARecipientKeyChangingFlag)
{
AMotivationDetail = string.Empty;
}
ApplyMotivationDetailCodeFilter(AGiftBatchDetail,
AMainDS,
ALedgerNumber,
APetraUtilsObject,
ACmbKeyMinistries,
ref ACmbMotivationDetailCode,
ATxtDetailRecipientKey,
ARecipientKey,
AtxtDetailRecipientLedgerNumber,
ATxtDetailCostCentreCode,
ATxtDetailAccountCode,
ATxtDetailRecipientKeyMinistry,
AChkDetailTaxDeductible,
ATxtDeductibleAccount,
AMotivationGroup,
ref AMotivationDetail,
ref AMotivationDetailChangedFlag,
AActiveOnly,
ARecipientKeyChangingFlag,
ACreatingNewGiftFlag,
AInEditModeFlag,
ABatchUnpostedFlag,
ATaxDeductiblePercentageEnabledFlag,
out ADoTaxUpdate);
}
/// <summary>
/// Call when the recipient key changes
/// </summary>
public static void OnRecipientKeyChanged(Int64 APartnerKey,
String APartnerShortName,
bool AValidSelection,
GiftBatchTDSAGiftDetailRow ACurrentDetailRow,
GiftBatchTDS AMainDS,
Int32 ALedgerNumber,
TFrmPetraEditUtils APetraUtilsObject,
ref TCmbAutoPopulated ACmbKeyMinistries,
TCmbAutoPopulated ACmbMotivationGroupCode,
TCmbAutoPopulated ACmbMotivationDetailCode,
TtxtAutoPopulatedButtonLabel ATxtDetailRecipientKey,
TtxtAutoPopulatedButtonLabel AtxtDetailRecipientLedgerNumber,
TextBox ATxtDetailCostCentreCode,
TextBox ATxtDetailAccountCode,
TextBox ATxtDetailRecipientKeyMinistry,
CheckBox AChkDetailTaxDeductible,
TextBox ATxtDeductibleAccount,
ref string AMotivationGroup,
ref string AMotivationDetail,
bool AShowingDetailsFlag,
ref bool ARecipientKeyChangingFlag,
bool AInKeyMinistryChangingFlag,
bool AInEditModeFlag,
bool ABatchUnpostedFlag,
bool AMotivationDetailChangedFlag,
bool ATaxDeductiblePercentageEnabledFlag,
bool ACreatingNewGiftFlag,
bool AActiveOnly,
out bool ADoValidateGiftDestination,
out bool ADoTaxUpdate)
{
ADoValidateGiftDestination = false;
ADoTaxUpdate = false;
if (ARecipientKeyChangingFlag || APetraUtilsObject.SuppressChangeDetection || AShowingDetailsFlag)
{
return;
}
ARecipientKeyChangingFlag = true;
ATxtDetailRecipientKeyMinistry.Text = string.Empty;
try
{
ACurrentDetailRow.RecipientKey = APartnerKey;
ACurrentDetailRow.RecipientDescription = APartnerShortName;
// do not want to update motivation comboboxes if recipient key is being changed due to a new gift or the motivation detail being changed
if (!AMotivationDetailChangedFlag && !ACreatingNewGiftFlag
&& TRemote.MFinance.Gift.WebConnectors.GetMotivationGroupAndDetail(APartnerKey, ref AMotivationGroup, ref AMotivationDetail))
{
if (AMotivationGroup != ACmbMotivationGroupCode.GetSelectedString())
{
// note - this will also update the Motivation Detail
ACmbMotivationGroupCode.SetSelectedString(AMotivationGroup);
}
if (AMotivationDetail != ACmbMotivationDetailCode.GetSelectedString())
{
ACmbMotivationDetailCode.SetSelectedString(AMotivationDetail);
}
ACurrentDetailRow.MotivationGroupCode = AMotivationGroup;
ACurrentDetailRow.MotivationDetailCode = AMotivationDetail;
}
APetraUtilsObject.SuppressChangeDetection = true;
//Set RecipientLedgerNumber
if (APartnerKey > 0)
{
ACurrentDetailRow.RecipientLedgerNumber = TRemote.MFinance.Gift.WebConnectors.GetRecipientFundNumber(APartnerKey,
ACurrentDetailRow.DateEntered);
}
else
{
ACurrentDetailRow.RecipientLedgerNumber = 0;
}
if (!AInKeyMinistryChangingFlag)
{
GetRecipientData(ACurrentDetailRow,
APartnerKey,
ref ACmbKeyMinistries,
ATxtDetailRecipientKey,
ref AtxtDetailRecipientLedgerNumber,
AMotivationDetailChangedFlag);
ADoValidateGiftDestination = true;
}
if (APartnerKey > 0)
{
RetrieveRecipientCostCentreCode(ACurrentDetailRow, ATxtDetailCostCentreCode);
}
else
{
UpdateRecipientKeyText(APartnerKey, ACurrentDetailRow, AMotivationGroup, AMotivationDetail);
RetrieveMotivationDetailCostCentreCode(AMainDS, ALedgerNumber, ATxtDetailCostCentreCode, AMotivationGroup, AMotivationDetail);
}
if (ATaxDeductiblePercentageEnabledFlag)
{
ADoTaxUpdate = true;
}
}
finally
{
ARecipientKeyChangingFlag = false;
ReconcileKeyMinistryFromCombo(ACurrentDetailRow,
ACmbKeyMinistries,
ATxtDetailRecipientKeyMinistry,
AInEditModeFlag,
ABatchUnpostedFlag);
APetraUtilsObject.SuppressChangeDetection = false;
}
}
/// <summary>
/// Call when the Motivation Detail changes
/// </summary>
public static void OnMotivationDetailChanged(GiftBatchTDSAGiftDetailRow ACurrentDetailRow,
GiftBatchTDS AMainDS,
Int32 ALedgerNumber,
TFrmPetraEditUtils APetraUtilsObject,
TCmbAutoPopulated ACmbKeyMinistries,
TCmbAutoPopulated ACmbMotivationDetailCode,
TtxtAutoPopulatedButtonLabel ATxtDetailRecipientKey,
Int64 ARecipientKey,
TtxtAutoPopulatedButtonLabel AtxtDetailRecipientLedgerNumber,
TextBox ATxtDetailCostCentreCode,
TextBox ATxtDetailAccountCode,
TextBox ATxtDetailRecipientKeyMinistry,
CheckBox AChkDetailTaxDeductible,
TextBox ATxtDeductibleAccount,
string AMotivationGroup,
ref string AMotivationDetail,
ref bool AMotivationDetailChangedFlag,
bool ARecipientKeyChangingFlag,
bool ACreatingNewGiftFlag,
bool AInEditModeFlag,
bool ABatchUnpostedFlag,
bool ATaxDeductiblePercentageEnabledFlag,
bool AAutoPopulatingGift,
out bool ADoTaxUpdate,
out string AAutoPopComment)
{
ADoTaxUpdate = false;
AAutoPopComment = null;
if (!ABatchUnpostedFlag || !AInEditModeFlag || ATxtDetailRecipientKeyMinistry.Visible)
{
return;
}
Int64 MotivationRecipientKey = 0;
AMotivationDetail = ACmbMotivationDetailCode.GetSelectedString();
if (AMotivationDetail.Length > 0)
{
AMotivationDetailRow motivationDetail = (AMotivationDetailRow)AMainDS.AMotivationDetail.Rows.Find(
new object[] { ALedgerNumber, AMotivationGroup, AMotivationDetail });
ACmbMotivationDetailCode.RefreshLabel();
if (motivationDetail != null)
{
RetrieveMotivationDetailAccountCode(motivationDetail,
ATxtDetailAccountCode,
ATxtDeductibleAccount,
ATaxDeductiblePercentageEnabledFlag);
MotivationRecipientKey = motivationDetail.RecipientKey;
// if motivation detail autopopulation is set to true
if (motivationDetail.Autopopdesc)
{
AAutoPopComment = motivationDetail.MotivationDetailDesc;
}
// set tax deductible checkbox if motivation detail has been changed by the user (i.e. not a row change)
if (!APetraUtilsObject.SuppressChangeDetection || ARecipientKeyChangingFlag)
{
AChkDetailTaxDeductible.Checked = motivationDetail.TaxDeductible;
}
if (ATaxDeductiblePercentageEnabledFlag)
{
if (string.IsNullOrEmpty(motivationDetail.TaxDeductibleAccount))
{
MessageBox.Show(Catalog.GetString("This Motivation Detail does not have an associated Tax Deductible Account. " +
"This can be added in Finance / Setup / Motivation Details.\n\n" +
"Unless this is changed it will be impossible to assign a Tax Deductible Percentage to this gift."),
Catalog.GetString("Incomplete Motivation Detail"), MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
ADoTaxUpdate = true;
}
}
else
{
AChkDetailTaxDeductible.Checked = false;
}
}
if (!ACreatingNewGiftFlag && !AAutoPopulatingGift && (MotivationRecipientKey > 0))
{
AMotivationDetailChangedFlag = true;
PopulateKeyMinistry(ACurrentDetailRow,
ACmbKeyMinistries,
ATxtDetailRecipientKey,
AtxtDetailRecipientLedgerNumber,
AMotivationDetailChangedFlag,
MotivationRecipientKey);
AMotivationDetailChangedFlag = false;
}
else if (ARecipientKey == 0)
{
UpdateRecipientKeyText(0, ACurrentDetailRow, AMotivationGroup, AMotivationDetail);
}
if (ARecipientKey == 0)
{
RetrieveMotivationDetailCostCentreCode(AMainDS, ALedgerNumber, ATxtDetailCostCentreCode, AMotivationGroup, AMotivationDetail);
}
else
{
string NewCCCode = TRemote.MFinance.Gift.WebConnectors.RetrieveCostCentreCodeForRecipient(ALedgerNumber,
ARecipientKey,
ACurrentDetailRow.RecipientLedgerNumber,
ACurrentDetailRow.DateEntered,
AMotivationGroup,
AMotivationDetail);
if (ATxtDetailCostCentreCode.Text != NewCCCode)
{
ATxtDetailCostCentreCode.Text = NewCCCode;
}
}
}