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; }
}
}
