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