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("4d326172-d5d5-4966-a91c-0c0d2b02b155"); request.ContextRecordID = id; 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 (RecurringGiftInstallmentHistoryDataListRow row in rows) { if (row.ACTIVITYTYPE != "Payment") { 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(); }