private void _Saving(object sender, Blackbaud.AppFx.UIModeling.Core.SavingEventArgs e) { if (this.Mode == Blackbaud.AppFx.UIModeling.Core.DataFormMode.Add) //Check this while adding only { if (RELATIONSHIPCODEID.Value == Guid.Parse("437C723A-AA22-49B9-977E-96E389D21A6A")) //Self { DataListLoadRequest request = new DataListLoadRequest { DataListID = new Guid("5a96ea16-83bc-4dcc-a2a5-a66f4065de0a"), ContextRecordID = this.ContextRecordId, SecurityContext = this.GetRequestSecurityContext() }; AppFxWebService svc = new AppFxWebService(this.GetRequestContext()); var reply = svc.DataListLoad(request); foreach (DataListResultRow row in reply.Rows) { if (row.Values[5] != null && row.Values[5].ToLower().Equals("self")) { SaveFailed(); break; } } } } }
private ItemInfo GetItemInfo(AppFxWebService appFxService, ClientAppInfoHeader header, string itemName, string sourceInfo) { ItemInfo itemInfo = new ItemInfo(); // Retrieve item info from 'Catalog Browser List' datalist so we can determine how we want to load it DataListLoadRequest listLoadReq = new DataListLoadRequest(); listLoadReq.ClientAppInfo = header; listLoadReq.DataListID = new Guid("91907a4f-14a3-4433-b780-a030c01ca452"); // Catalog Browser List // Create params with SOURCE set to the source from the msbuild item metadata listLoadReq.Parameters = new DataFormItem(); listLoadReq.Parameters.Values = new DataFormFieldValue[] { new DataFormFieldValue() { ID = "SOURCE", Value = sourceInfo } }; // Let any exceptions from this bubble upwards DataListLoadReply listLoadReply = null; listLoadReply = appFxService.DataListLoad(listLoadReq); // Loading a few constants for clarity's sake int itemSourceColNum = 3; int itemIdColNum = 5; int itemResourceNameColNum = 8; int itemTypeCodeColNum = 14; // Look for the item we're supposed to load in the datalist results DataListResultRow rowToLoad = listLoadReply.Rows.Where(r => r.Values[itemResourceNameColNum].Equals(itemName, StringComparison.InvariantCultureIgnoreCase)).Select(r => r).FirstOrDefault(); if (rowToLoad == null) { throw new Exception(string.Format("Did not find '{0}' in items loaded from '{1}'.", itemName, sourceInfo)); } int tmpItemTypeCode = int.MinValue; if (!int.TryParse(rowToLoad.Values[itemTypeCodeColNum], out tmpItemTypeCode)) { throw new Exception(string.Format("Failed to parse item type code from '{0}'", rowToLoad.Values[itemTypeCodeColNum])); } itemInfo.ItemTypeCode = tmpItemTypeCode; itemInfo.ItemId = new Guid(rowToLoad.Values[itemIdColNum]); itemInfo.ItemName = rowToLoad.Values[itemResourceNameColNum]; itemInfo.ItemSource = rowToLoad.Values[itemSourceColNum]; return(itemInfo); }
private MoM.DataLists.WebsiteSponsorshipCheckoutSourceRepsDataListRow[] GetHeardAboutUsSubRows() { MoM.DataLists.WebsiteSponsorshipCheckoutSourceRepsDataListRow[] rows = BBSession.TryItem <MoM.DataLists.WebsiteSponsorshipCheckoutSourceRepsDataListRow[]>(c_HEARDABOUTUSSUBROWS); if (rows == null) { DataListLoadRequest request = MoM.DataLists.WebsiteSponsorshipCheckoutSourceRepsDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.ContextRecordID = this.API.Users.CurrentUser.BackOfficeGuid.ToString(); rows = MoM.DataLists.WebsiteSponsorshipCheckoutSourceRepsDataList.GetRows(this.API.AppFxWebServiceProvider, request); BBSession.Add(c_HEARDABOUTUSSUBROWS, rows); } return(rows); }
/// <summary> /// Populate ddlConstituentNoteType drop down with all active constituent note types /// </summary> private void PopulateConstituentNoteTypes() { DataListLoadRequest request = CodeTableEntryList.CreateRequest(this.API.AppFxWebServiceProvider); request.ContextRecordID = "e2373a71-2f76-4beb-bcf9-58740ae32320"; // Constituent Note Code Table CodeTableEntryListRow[] codeTableItems; CodeTableEntryListFilterData codeTableFilter = new CodeTableEntryListFilterData(); codeTableFilter.INCLUDEINACTIVE = false; codeTableItems = CodeTableEntryList.GetRows(this.API.AppFxWebServiceProvider, request); this.ddlConstituentNoteType.Items.Clear(); this.ddlConstituentNoteType.DataTextField = "DESCRIPTION"; this.ddlConstituentNoteType.DataValueField = "ID"; this.ddlConstituentNoteType.DataSource = codeTableItems; this.ddlConstituentNoteType.DataBind(); }
private void populateHearAbout() { DataListLoadRequest request = Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.DataListID = new Guid("37fe2ce9-1889-49b9-86fe-75cbd3af0af1"); request.ContextRecordID = this.API.Users.CurrentUser.BackOfficeGuid.ToString(); Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataListRow[] rows = Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataList.GetRows(this.API.AppFxWebServiceProvider, request); this.cmbHearAbout.Items.Clear(); this.cmbHearAbout.Items.Add(new ListItem("-- Select --", "")); foreach (Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataListRow row in rows) { ListItem item = new ListItem(row.SOURCEDESC, row.SOURCEDESC); item.Attributes.Add("data", row.ADDITIONALINFORMATIONCAPTION); this.cmbHearAbout.Items.Add(new ListItem(row.SOURCEDESC, row.SOURCEDESC)); } }
private void bindPayments(string id, string childName, string imageURL) { this.mvMain.SetActiveView(this.viewPayments); DataListLoadRequest request = RecurringGiftInstallmentHistoryDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.DataListID = new Guid("384fedc7-25b7-4cde-873c-dc26f48178ae"); //"4d326172-d5d5-4966-a91c-0c0d2b02b155"); request.ContextRecordID = id; OCM.BBISWebParts.WebsiteSponsorshipPaymentsDataListRow[] rows = OCM.BBISWebParts.WebsiteSponsorshipPaymentsDataList.GetRows(this.API.AppFxWebServiceProvider, request); //RecurringGiftInstallmentHistoryDataListRow[] rows = RecurringGiftInstallmentHistoryDataList.GetRows(this.API.AppFxWebServiceProvider, request); lblViewPaymentsFor.Text = "Viewing payments for " + childName; imgPayments.ImageUrl = imageURL; DataTable dt = new DataTable(); dt.Columns.Add("DATE"); dt.Columns.Add("AMOUNT"); dt.Columns.Add("ACTIVITYTYPE"); dt.Columns.Add("DATESORT"); foreach (OCM.BBISWebParts.WebsiteSponsorshipPaymentsDataListRow row in rows) //foreach (RecurringGiftInstallmentHistoryDataListRow row in rows) { if ((row.ACTIVITYTYPE != "Payment") || (row.AMOUNT <= 0)) { continue; } DataRow dr = dt.NewRow(); dr["DATE"] = row.DATE.Value.ToString("MMMM dd, yyyy"); dr["AMOUNT"] = row.AMOUNT.ToString("c"); dr["ACTIVITYTYPE"] = row.ACTIVITYTYPE; //dr["DATESORT"] = row.DATE.Value.ToString ("yyyyMMdd"); dt.Rows.Add(dr); } DataView dv = dt.DefaultView; //dv.Sort = "DATESORT desc"; this.gvPayments.DataSource = dv.ToTable(); this.gvPayments.DataBind(); //this.gvPayments.Sort("DATE", SortDirection.Descending); }
private void showHideHearAbout() { DataListLoadRequest request = Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.DataListID = new Guid("37fe2ce9-1889-49b9-86fe-75cbd3af0af1"); request.ContextRecordID = this.API.Users.CurrentUser.BackOfficeGuid.ToString(); Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataListRow[] rows = Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataList.GetRows(this.API.AppFxWebServiceProvider, request); foreach (Blackbaud.CustomFx.ChildSponsorship.CrmObjects.DataLists.NOTUSED.WebsiteSponsorshipCheckoutSourceDataListRow row in rows) { if (row.SOURCEDESC == this.cmbHearAbout.SelectedValue) { this.lblHearAbout.Text = row.ADDITIONALINFORMATIONCAPTION; this.trHearAbout.Visible = row.HASADDITIONALINFORMATION; // !String.IsNullOrWhiteSpace(row.ADDITIONALINFORMATIONCAPTION); break; } } }
/// <summary> /// Populate ddlDesignationBBIS and ddlDesignationCRM with all active designations /// They both use the same datalist, just different fields for the ids. /// </summary> private void PopulateDesignations() { DataListLoadRequest request = DesignationsWithBBNCIDDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.ContextRecordID = "abc"; // This isn't used in the datalist but it cannot be empty. DesignationsWithBBNCIDDataListRow[] designationItems; designationItems = DesignationsWithBBNCIDDataList.GetRows(this.API.AppFxWebServiceProvider, request); this.ddlDesignationBBIS.Items.Clear(); this.ddlDesignationBBIS.DataTextField = "DESIGNATIONNAME"; this.ddlDesignationBBIS.DataValueField = "BBNCID"; this.ddlDesignationBBIS.DataSource = designationItems; this.ddlDesignationBBIS.DataBind(); this.ddlDesignationCRM.Items.Clear(); this.ddlDesignationCRM.DataTextField = "DESIGNATIONNAME"; this.ddlDesignationCRM.DataValueField = "DESIGNATIONID"; this.ddlDesignationCRM.DataSource = designationItems; this.ddlDesignationCRM.DataBind(); }
private void bindPayments(string id) { this.mvMain.SetActiveView(this.viewPayments); DataListLoadRequest request = RecurringGiftInstallmentHistoryDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.DataListID = new Guid("4d326172-d5d5-4966-a91c-0c0d2b02b155"); request.ContextRecordID = id; RecurringGiftInstallmentHistoryDataListRow[] rows = RecurringGiftInstallmentHistoryDataList.GetRows(this.API.AppFxWebServiceProvider, request); DataTable dt = new DataTable(); dt.Columns.Add("ACTIVITYTYPE"); dt.Columns.Add("AMOUNT"); dt.Columns.Add("BALANCE"); dt.Columns.Add("DATE"); foreach (RecurringGiftInstallmentHistoryDataListRow row in rows) { if (row.ACTIVITYTYPE == "Installment") { continue; } DataRow dr = dt.NewRow(); dr["ACTIVITYTYPE"] = row.ACTIVITYTYPE; dr["AMOUNT"] = row.AMOUNT.ToString("c"); dr["BALANCE"] = row.BALANCE; dr["DATE"] = row.DATE.Value.ToShortDateString(); dt.Rows.Add(dr); } this.gvPayments.DataSource = dt; this.gvPayments.DataBind(); }
private void bindCommitments() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Commitment"); dt.Columns.Add("Amount"); dt.Columns.Add("AutoPay"); dt.Columns.Add("Frequency"); DataListLoadRequest request = SponsorshipDataList.CreateRequest(this.API.AppFxWebServiceProvider); request.DataListID = new Guid("b87f9b24-91e9-40c2-b54a-f6fbcc09f6f0"); if (Request.QueryString["Id"] != null) // Why is this here?? { request.ContextRecordID = Convert.ToString(Request.QueryString["Id"]); } else { request.ContextRecordID = this.API.Users.CurrentUser.BackOfficeGuid.ToString(); } SponsorshipDataListRow[] rows = SponsorshipDataList.GetRows(this.API.AppFxWebServiceProvider, request); foreach (SponsorshipDataListRow row in rows) { DataFormLoadRequest sponsorshipRequest = SponsorshipPaymentViewForm.CreateRequest(this.API.AppFxWebServiceProvider); sponsorshipRequest.FormID = new Guid("aeed02c3-ddba-41bc-8e7c-341c77068875"); sponsorshipRequest.ContextRecordID = row.SPONSORSHIPID.ToString(); sponsorshipRequest.RecordID = row.SPONSORSHIPID.ToString(); SponsorshipPaymentViewFormData data = SponsorshipPaymentViewForm.LoadData(this.API.AppFxWebServiceProvider, sponsorshipRequest); DataFormLoadRequest paymentRequest = RevenuePaymentDetailsByTransactionViewForm.CreateRequest(this.API.AppFxWebServiceProvider); paymentRequest.FormID = new Guid("bafca6f5-4cdb-4173-aece-113713d38bfb"); paymentRequest.ContextRecordID = row.REVENUEID.ToString(); paymentRequest.RecordID = row.REVENUEID.ToString(); RevenuePaymentDetailsByTransactionViewFormData paymentData = RevenuePaymentDetailsByTransactionViewForm.LoadData(this.API.AppFxWebServiceProvider, paymentRequest); DataRow dr = dt.NewRow(); dr["Commitment"] = row.NAME + " (" + row.COMMITMENTID + ")"; if (data.BASEAMOUNT.HasValue) { dr["Amount"] = data.BASEAMOUNT.Value.ToString("c"); } dr["Frequency"] = data.FREQUENCY; dr["AutoPay"] = paymentData.AUTOPAY.Value ? "Yes" : "No"; dr["Id"] = row.REVENUEID.ToString(); dt.Rows.Add(dr); } DataListLoadRequest giftRequest = ConstituentExpandedRevenueHistoryList.CreateRequest(this.API.AppFxWebServiceProvider); giftRequest.DataListID = new Guid("4c2acb2c-a819-4092-a599-e43102824b1e"); giftRequest.ContextRecordID = this.API.Users.CurrentUser.BackOfficeGuid.ToString(); ConstituentExpandedRevenueHistoryListFilterData filter = new ConstituentExpandedRevenueHistoryListFilterData(); filter.TRANSACTIONTYPEOPTIONCODE_IDVALUE = Blackbaud.AppFx.Fundraising.Catalog.WebApiClient.DataLists.Constituent.ConstituentExpandedRevenueHistoryListEnums.TRANSACTIONTYPEOPTIONCODE.Recurring_Gifts; ConstituentExpandedRevenueHistoryListRow[] giftRows = ConstituentExpandedRevenueHistoryList.GetRows(this.API.AppFxWebServiceProvider, giftRequest); foreach (ConstituentExpandedRevenueHistoryListRow row in giftRows) { if (row.TRANSACTIONTYPECODE != "Recurring gift") { continue; } if (row.REVENUETYPE == "Sponsorship") { continue; } DataRow dr = dt.NewRow(); DataFormLoadRequest sponsorshipRequest = RevenueTransactionProfileViewForm.CreateRequest(this.API.AppFxWebServiceProvider); sponsorshipRequest.FormID = new Guid("74f1a311-2ed9-4c0b-b666-9bf318748d9b"); sponsorshipRequest.ContextRecordID = row.REVENUEID.ToString(); sponsorshipRequest.RecordID = row.REVENUEID.ToString(); RevenueTransactionProfileViewFormData data = RevenueTransactionProfileViewForm.LoadData(this.API.AppFxWebServiceProvider, sponsorshipRequest); DataFormLoadRequest paymentRequest = RevenuePaymentDetailsByTransactionViewForm.CreateRequest(this.API.AppFxWebServiceProvider); paymentRequest.FormID = new Guid("bafca6f5-4cdb-4173-aece-113713d38bfb"); paymentRequest.ContextRecordID = row.REVENUEID.ToString(); paymentRequest.RecordID = row.REVENUEID.ToString(); RevenuePaymentDetailsByTransactionViewFormData paymentData = RevenuePaymentDetailsByTransactionViewForm.LoadData(this.API.AppFxWebServiceProvider, paymentRequest); dr["Commitment"] = row.DETAIL; dr["Amount"] = row.AMOUNT.ToString("c"); dr["Frequency"] = data.FREQUENCY; dr["AutoPay"] = paymentData.AUTOPAY.Value ? "Yes" : "No"; dr["Id"] = row.REVENUEID.ToString(); dt.Rows.Add(dr); } this.gvCommitments.DataSource = dt; this.gvCommitments.DataBind(); }
private void RefreshAdditionalRelationships() { //this.RELATIONSHIPS.Value.Clear(); DataListLoadRequest req = new DataListLoadRequest(); req.DataListID = new Guid("9FB22DDF-1B9E-4FBF-875A-CB7E18CBB755"); req.Parameters = new DataFormItem(); // Guid guid1; // Guid guid2; //if (this._constitHasHousehold) // { // guid1 = new Guid(this.ContextRecordId); // guid2 = this.RECIPROCALUMHSID.Value; // } //else //{ // guid1 = this.RELATEDINDIVIDUAL.Value; // guid2 = new Guid(this.ContextRecordId); //} //req.Parameters.SetValue("HOUSEHOLDCONSTITUENTID", (object)guid1); //req.Parameters.SetValue("ADDITIONALCONSTITUENTID", (object)guid2); req.SecurityContext = this.GetRequestSecurityContext(); DataListLoadReply dataListLoadReply = new AppFxWebService(this.GetRequestContext()).DataListLoad(req); if (dataListLoadReply == null || Enumerable.Count <DataListResultRow>((IEnumerable <DataListResultRow>)dataListLoadReply.Rows) <= 0) { return; } DataListResultRow[] dataListResultRowArray = dataListLoadReply.Rows; int index = 0; while (index < dataListResultRowArray.Length) { DataListResultRow dataListResultRow = dataListResultRowArray[index]; UMHSRelationshipAddFormUIModel relationshipsuiModel = new UMHSRelationshipAddFormUIModel(); Guid guid3 = new Guid(dataListResultRow.Values[0]); int num = Conversions.ToInteger(dataListResultRow.Values[1]); string str1 = dataListResultRow.Values[2]; string str2 = dataListResultRow.Values[3]; string str3 = dataListResultRow.Values[4]; string str4 = dataListResultRow.Values[5]; Guid relationshipTypeCodeID = dataListResultRow.Values[6] == null ? Guid.Empty : new Guid(dataListResultRow.Values[6]); Guid reciprocalTypeCodeID = dataListResultRow.Values[7] == null ? Guid.Empty : new Guid(dataListResultRow.Values[7]); //relationshipsuiModel.RECIPROCALCONSTITUENTID.Value = guid3; //relationshipsuiModel.RECIPROCALCONSTITUENTID.Value = guid2; relationshipsuiModel.RECIPROCALUMHSID.Value = guid3; //relationshipsuiModel.RECIPROCALUMHSID.Value = guid2; //relationshipsuiModel.UMHSTYPE.Value = num; if (string.IsNullOrEmpty(str4)) //**It shoudl be RECIPROCALPATIENTNAME { relationshipsuiModel.PATIENTNAME.Value = string.Format((IFormatProvider)CultureInfo.CurrentCulture, "Individual is the", new object[2] { (object)str1, (object)ConstituentHelper.MakeStringPossessive(str3) }); } else { //shoudl be RECIPROCALPATIENTNAME instead of PATIENTNAME here relationshipsuiModel.PATIENTNAME.Value = string.Format((IFormatProvider)CultureInfo.CurrentCulture, "Individual is the", (object)str1, (object)ConstituentHelper.MakeStringPossessive(str2), (object)str4, (object)ConstituentHelper.MakeStringPossessive(str3)); } relationshipsuiModel.PATIENTNAME.Value = string.Format((IFormatProvider)CultureInfo.CurrentCulture, "Individual is the", new object[1] { (object)str3 }); relationshipsuiModel.PATIENTNAME.Enabled = false; relationshipsuiModel.PATIENTNAME.Enabled = false; //should be RECIPROCALPATIENTNAME relationshipsuiModel.SetExistingRelationship(relationshipTypeCodeID, reciprocalTypeCodeID); // this.RELATIONSHIPS.Value.Add(relationshipsuiModel); checked { ++index; } } }