private void InitializeManualCode() { // show this dialog in center of screen this.StartPosition = FormStartPosition.CenterScreen; FTypeTable = (PTypeTable)TDataCache.TMPartner.GetCacheablePartnerTable( TCacheablePartnerTablesEnum.PartnerTypeList); for (int i = 0; i < FTypeTable.Rows.Count; i++) { PTypeRow row = (PTypeRow)FTypeTable.Rows[i]; if (!row.ValidType) { row.TypeDescription += MCommonResourcestrings.StrGenericInactiveCode; } } FTypeTable.AcceptChanges(); grdTypes.AddTextColumn(Catalog.GetString("Type Code"), FTypeTable.Columns[PTypeTable.GetTypeCodeDBName()]); grdTypes.AddTextColumn(Catalog.GetString("Description"), FTypeTable.Columns[PTypeTable.GetTypeDescriptionDBName()]); DataView myDataView = FTypeTable.DefaultView; myDataView.AllowNew = false; grdTypes.DataSource = new DevAge.ComponentModel.BoundDataView(myDataView); }
private void PopulateReceivingFieldList() { string CheckedMember = "CHECKED"; string DisplayMember = "Field Name"; string ValueMember = "Field Key"; FFieldTable = TRemote.MFinance.Reporting.WebConnectors.GetReceivingFields(FLedgerNumber, out DisplayMember, out ValueMember); DataColumn FirstColumn = new DataColumn(CheckedMember, typeof(bool)); FirstColumn.DefaultValue = false; FFieldTable.Columns.Add(FirstColumn); clbFields.Columns.Clear(); clbFields.AddCheckBoxColumn("", FFieldTable.Columns[CheckedMember], 17, false); clbFields.AddTextColumn(Catalog.GetString("Field Key"), FFieldTable.Columns[ValueMember], 100); clbFields.AddTextColumn(Catalog.GetString("Field Name"), FFieldTable.Columns[DisplayMember], 200); clbFields.DataBindGrid(FFieldTable, ValueMember, CheckedMember, ValueMember, false, true, false); FTypeTable = TDataCache.TMPartner.GetCacheablePartnerTable(TCacheablePartnerTablesEnum.PartnerTypeList); DataColumn CheckedColumn = new DataColumn(CheckedMember, typeof(bool)); CheckedColumn.DefaultValue = false; FTypeTable.Columns.Add(CheckedColumn); clbTypes.Columns.Clear(); clbTypes.AddCheckBoxColumn("", FTypeTable.Columns[CheckedMember], 17); clbTypes.AddTextColumn(Catalog.GetString("Partner Type"), FTypeTable.Columns[PTypeTable.GetTypeCodeDBName()], 280); clbTypes.DataBindGrid(FTypeTable, PTypeTable.GetTypeCodeDBName(), CheckedMember, PTypeTable.GetTypeCodeDBName(), false, true, false); }
private void InitializeManualCode() { string CheckedMember = "CHECKED"; string DisplayMember = PTypeTable.GetTypeDescriptionDBName(); string ValueMember = PTypeTable.GetTypeCodeDBName(); DataTable Table = TDataCache.TMPartner.GetCacheablePartnerTable(TCacheablePartnerTablesEnum.PartnerTypeList); DataView view = new DataView(Table); // TODO view.RowFilter = only active types? view.Sort = ValueMember; DataTable NewTable = view.ToTable(true, new string[] { ValueMember, DisplayMember }); NewTable.Columns.Add(new DataColumn(CheckedMember, typeof(bool))); clbIncludeSpecialTypes.SpecialKeys = ((SourceGrid.GridSpecialKeys)((((((SourceGrid.GridSpecialKeys.Arrows | SourceGrid.GridSpecialKeys.PageDownUp) | SourceGrid.GridSpecialKeys.Enter) | SourceGrid.GridSpecialKeys.Escape) | SourceGrid.GridSpecialKeys.Control) | SourceGrid.GridSpecialKeys.Shift))); //clbIncludeSpecialTypes.SelectionMode = SourceGrid.GridSelectionMode.Row; clbIncludeSpecialTypes.Columns.Clear(); clbIncludeSpecialTypes.AddCheckBoxColumn("", NewTable.Columns[CheckedMember], 17, false); clbIncludeSpecialTypes.AddTextColumn(Catalog.GetString("Type Code"), NewTable.Columns[ValueMember]); clbIncludeSpecialTypes.AddTextColumn(Catalog.GetString("Type Description"), NewTable.Columns[DisplayMember]); clbIncludeSpecialTypes.DataBindGrid(NewTable, ValueMember, CheckedMember, ValueMember, false, true, false); }
private void InitializeManualCode() { // show this dialog in center of screen this.StartPosition = FormStartPosition.CenterScreen; FTypeTable = (PTypeTable)TDataCache.TMPartner.GetCacheablePartnerTable( TCacheablePartnerTablesEnum.PartnerTypeList); grdTypes.AddTextColumn(Catalog.GetString("Type Code"), FTypeTable.Columns[PTypeTable.GetTypeCodeDBName()]); grdTypes.AddTextColumn(Catalog.GetString("Description"), FTypeTable.Columns[PTypeTable.GetTypeDescriptionDBName()]); DataView myDataView = FTypeTable.DefaultView; myDataView.AllowNew = false; grdTypes.DataSource = new DevAge.ComponentModel.BoundDataView(myDataView); }
private void grdTypes_InitialiseData(TFrmPetraReportingUtils APetraUtilsObject) { // Get list of commitment statuses FTypesTable = (PTypeTable)TDataCache.TMPartner.GetCacheablePartnerTable( TCacheablePartnerTablesEnum.PartnerTypeList); grdTypes.Columns.Clear(); grdTypes.AddTextColumn("Type", FTypesTable.Columns[PTypeTable.GetTypeCodeDBName()]); FTypesTable.DefaultView.AllowNew = false; FTypesTable.DefaultView.AllowDelete = false; for (int Counter = FTypesTable.Rows.Count - 1; Counter >= 0; --Counter) { String TypeCode = (String)FTypesTable.Rows[Counter][PTypeTable.GetTypeCodeDBName()]; // allow ORGANIZATION SPECIFIC TypeCode String[] DefaultWorkerTypes = TAppSettingsManager.GetValue("DEFAULTWORKERTYPES_STARTINGWITH", "WORKER;EX-WORKER;ASSOC", false).Split(new char[] { ';' }); bool typeInList = false; foreach (string allowedType in DefaultWorkerTypes) { if (TypeCode.StartsWith(allowedType)) { typeInList = true; } } if (!typeInList) { FTypesTable.Rows.RemoveAt(Counter); } } grdTypes.DataSource = new DevAge.ComponentModel.BoundDataView(FTypesTable.DefaultView); grdTypes.AutoSizeCells(); grdTypes.Selection.EnableMultiSelection = true; SelectTypesChanged(null, null); chkAnniversariesCheckedChanged(null, null); }
public static PTypeTable GetChildrenStatusOptions() { TDBTransaction t = new TDBTransaction(); TDataBase db = DBAccess.Connect("FindChildrenStatusOptions"); string sql = "SELECT p_type_code_c, p_type_description_c " + "FROM PUB_p_type " + "WHERE p_valid_type_l = 1 AND p_category_code_c = 'SPONSORED_CHILD_STATUS'"; PTypeTable result = new PTypeTable(); db.ReadTransaction(ref t, delegate { db.SelectDT(result, sql, t); }); db.CloseDBConnection(); return(result); }
/// <summary> /// todoComment /// </summary> public void FillTempPartnerTypesTable() { DataTable SelectedPartnerTypeTable; DataView SelectedPartnerTypeTableDV; DataView UnselectedPartnerTypeTableDV; DataRow TheNewRow; Int16 RowCounter; String TypeDescription; Int32 TypeDescriptionInCachePosition; // TODO 2 oChristianK cList Sorting : Sort both the checked and not checked List items so that invalid Types are sorted to the end of both lists, respectively. FPartnerTypesGridTable.Rows.Clear(); FPartnerTypesGridTable.AcceptChanges(); // Sort data SelectedPartnerTypeTable = FMainDS.PPartnerType; SelectedPartnerTypeTableDV = SelectedPartnerTypeTable.DefaultView; SelectedPartnerTypeTableDV.Sort = PTypeTable.GetTypeCodeDBName(); UnselectedPartnerTypeTableDV = FDataCache_PartnerTypeListTable.DefaultView; UnselectedPartnerTypeTableDV.Sort = PTypeTable.GetTypeCodeDBName(); // first add Special Types which are already selected for partner for (RowCounter = 0; RowCounter <= SelectedPartnerTypeTableDV.Count - 1; RowCounter += 1) { #region Determine Type Description TypeDescriptionInCachePosition = FDataCache_PartnerTypeListDV.Find(SelectedPartnerTypeTableDV[RowCounter][PTypeTable.GetTypeCodeDBName()]); if (TypeDescriptionInCachePosition != -1) { TypeDescription = FDataCache_PartnerTypeListDV[TypeDescriptionInCachePosition][PTypeTable.GetTypeDescriptionDBName()].ToString(); // If this Type is inactive, show it. if (!Convert.ToBoolean(FDataCache_PartnerTypeListDV[TypeDescriptionInCachePosition][PTypeTable.GetValidTypeDBName()])) { TypeDescription = TypeDescription + MCommonResourcestrings.StrGenericInactiveCode; } } else { TypeDescription = ""; } #endregion TheNewRow = FPartnerTypesGridTable.NewRow(); TheNewRow["Checked"] = (System.Object)true; TheNewRow["TypeCode"] = SelectedPartnerTypeTableDV[RowCounter][PTypeTable.GetTypeCodeDBName()]; TheNewRow["TypeDescription"] = TypeDescription; FPartnerTypesGridTable.Rows.Add(TheNewRow); } // second add the rest of the Special Types in db for (RowCounter = 0; RowCounter <= UnselectedPartnerTypeTableDV.Count - 1; RowCounter += 1) { // only add row if it has not already been added as a checked row if (SelectedPartnerTypeTableDV.Find( new object[] { UnselectedPartnerTypeTableDV[RowCounter][PTypeTable.GetTypeCodeDBName()] }) == -1) { #region Determine Type Description TypeDescription = UnselectedPartnerTypeTableDV[RowCounter][PTypeTable.GetTypeDescriptionDBName()].ToString(); // If this Type is inactive, show it. if (!Convert.ToBoolean(UnselectedPartnerTypeTableDV[RowCounter][PTypeTable.GetValidTypeDBName()])) { TypeDescription = TypeDescription + MCommonResourcestrings.StrGenericInactiveCode; } #endregion TheNewRow = FPartnerTypesGridTable.NewRow(); TheNewRow["Checked"] = (System.Object)false; TheNewRow["TypeCode"] = UnselectedPartnerTypeTableDV[RowCounter][PTypeTable.GetTypeCodeDBName()]; TheNewRow["TypeDescription"] = TypeDescription; FPartnerTypesGridTable.Rows.Add(TheNewRow); } } }
/// <summary> /// todoComment /// </summary> public void LoadTypes() { FDataCache_PartnerTypeListTable = (PTypeTable)TDataCache.TMPartner.GetCacheablePartnerTable(TCacheablePartnerTablesEnum.PartnerTypeList); FDataCache_PartnerTypeListDV = FDataCache_PartnerTypeListTable.DefaultView; FDataCache_PartnerTypeListDV.Sort = PTypeTable.GetTypeCodeDBName(); }
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); PTypeAccess.LoadAll(MainDS, 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); string DonorAddress, DonorEmailAddress, DonorPhoneNumber; GetDonorContactDetails(recurrGiftRow.DonorKey, out DonorAddress, out DonorEmailAddress, out DonorPhoneNumber); gdr.DonorName = donorRow.PartnerShortName; gdr.DonorAddress = DonorAddress; gdr.DonorEmailAddress = DonorEmailAddress; gdr.DonorPhoneNumber = DonorPhoneNumber; 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 partnertype in MainDS.PPartnerType.Rows) { MainDS.PType.DefaultView.RowFilter = String.Format("{0} = '{1}'", PTypeTable.GetTypeCodeDBName(), partnertype.TypeCode); if (MainDS.PType.DefaultView.Count == 1) { PTypeRow type = (PTypeRow)MainDS.PType.DefaultView[0].Row; if (type.CategoryCode == "SPONSORED_CHILD_STATUS") { isSponsoredChild = true; ASponsorshipStatus = type.TypeCode; } } } if (!isSponsoredChild) { return(new SponsorshipTDS()); } return(MainDS); }
private void grdTypes_ReadControls(TRptCalculator ACalc, TReportActionEnum AReportAction) { //param_partnertypelist if (chkSelectTypes.Checked) { String SelectedTypes = ""; for (int Counter = 0; Counter < grdTypes.SelectedDataRows.Length; ++Counter) { SelectedTypes = SelectedTypes + (String)((DataRowView)grdTypes.SelectedDataRows[Counter]).Row[FTypesTable.Columns[PTypeTable.GetTypeCodeDBName()] ] + ","; } // remove the last , if (SelectedTypes.Length > 0) { SelectedTypes = SelectedTypes.Substring(0, SelectedTypes.Length - 1); } ACalc.AddParameter("param_typecode", SelectedTypes); } else { ACalc.AddParameter("param_partnertypelist", "false"); } /* // "Include family members" removed because it doesn't work properly * if (chkIncludeFamily.Checked) * { * // Allow sorting of multiple levels * // if the option "Family members" is used, then the report will * // generate a result with multiple levels * ACalc.AddParameter("param_sort_multiple_levels", "true"); * } */ /* // "Sort" options removed because it doesn't work properly * * String SortColumns = ACalc.GetParameters().Get("param_sortby_readable").ToString(); * * if (SortColumns.Contains("Date of Birth")) * { * // Replace sorting of "Date of Birth" with "Date Of Birth This Year" * String SortingColumns = ACalc.GetParameters().Get("param_sortby_columns").ToString(); * * StringCollection SortingColumn = StringHelper.StrSplit(SortingColumns, ","); * * foreach (String StrColumn in SortingColumn) * { * int currentColumn = Convert.ToInt32(StrColumn); * * String ColumnName = ACalc.GetParameters().Get("param_calculation", currentColumn, -1, eParameterFit.eExact).ToString(); * * if (ColumnName == "Date of Birth") * { * ACalc.AddParameter("param_calculation", "Date Of Birth This Year", currentColumn); * break; * } * } * } */ }
private void ImportPartnerType(TDBTransaction ATransaction) { PPartnerTypeRow PartnerTypeRow = FMainDS.PPartnerType.NewRowTyped(); PartnerTypeRow.PartnerKey = FPartnerKey; PartnerTypeRow.TypeCode = ReadString(); PartnerTypeRow.ValidFrom = ReadNullableDate(); PartnerTypeRow.ValidUntil = ReadNullableDate(); if (FTypeTable == null) { FTypeTable = PTypeAccess.LoadAll(StringHelper.StrSplit(PTypeTable.GetTypeCodeDBName(), ","), ATransaction); } // ignore types that are not in the database. avoid constraint violation if (!FIgnorePartner && (FTypeTable.Rows.Find(PartnerTypeRow.TypeCode) != null)) { PPartnerTypeAccess.AddOrModifyRecord(PartnerTypeRow.PartnerKey, PartnerTypeRow.TypeCode, FMainDS.PPartnerType, PartnerTypeRow, FDoNotOverwrite, ATransaction); } }