/// <summary> /// Binds the grid. /// </summary> private void BindGrid() { TransactionSearchValue searchValue = GetSearchValue(); SortProperty sortProperty = rGridTransactions.SortProperty; var transactionService = new FinancialTransactionService(); var queryable = transactionService.Get(searchValue); if (_batch != null) { queryable = queryable.Where(t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id); } if (_person != null) { queryable = queryable.Where(t => t.AuthorizedPersonId == _person.Id); } if (sortProperty != null) { queryable = queryable.Sort(sortProperty); } else { queryable = queryable.OrderBy(t => t.TransactionDateTime); } rGridTransactions.DataSource = queryable.ToList(); rGridTransactions.DataBind(); }
private void BindGrid() { TransactionSearchValue searchValue = GetSearchValue(); var transactionService = new FinancialTransactionService(); grdTransactions.DataSource = transactionService.Get(searchValue).ToList(); grdTransactions.DataBind(); }
/// <summary> /// Gets the search value. /// </summary> /// <returns></returns> private TransactionSearchValue GetSearchValue() { TransactionSearchValue searchValue = new TransactionSearchValue(); decimal?fromAmountRange = null; if (!String.IsNullOrEmpty(txtFromAmount.Text)) { fromAmountRange = Decimal.Parse(txtFromAmount.Text); } decimal?toAmountRange = null; if (!String.IsNullOrEmpty(txtToAmount.Text)) { toAmountRange = Decimal.Parse(txtToAmount.Text); } searchValue.AmountRange = new RangeValue <decimal?>(fromAmountRange, toAmountRange); DateTime?fromTransactionDate = dtStartDate.SelectedDate; DateTime?toTransactionDate = dtEndDate.SelectedDate; searchValue.DateRange = new RangeValue <DateTime?>(dtStartDate.SelectedDate, dtEndDate.SelectedDate); if (!string.IsNullOrEmpty(txtTransactionCode.Text)) { searchValue.TransactionCode = txtTransactionCode.Text; } if (ddlAccount.SelectedValue != Rock.Constants.All.IdValue) { searchValue.AccountId = ddlAccount.SelectedValueAsInt(); } if (ddlTransactionType.SelectedValue != Rock.Constants.All.IdValue) { searchValue.TransactionTypeValueId = ddlTransactionType.SelectedValueAsInt(); } if (ddlCurrencyType.SelectedValue != Rock.Constants.All.IdValue) { searchValue.CurrencyTypeValueId = ddlCurrencyType.SelectedValueAsInt(); } if (ddlCreditCardType.SelectedValue != Rock.Constants.All.IdValue) { searchValue.CreditCardTypeValueId = ddlCreditCardType.SelectedValueAsInt(); } if (ddlSourceType.SelectedValue != Rock.Constants.All.IdValue) { searchValue.SourceTypeValueId = ddlSourceType.SelectedValueAsInt(); } return(searchValue); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && _canConfigure) { Rock.Web.UI.Page.AddScriptLink(this.Page, "~/scripts/Kendo/kendo.core.min.js"); LoadDropDowns(); BindGrid(); } btnSearch.Click += delegate { TransactionSearchValue searchValue = GetSearchValue(); var searchResults = transactionService.GetTransactionBySearch(searchValue); grdTransactions.DataSource = searchResults.ToList(); grdTransactions.DataBind(); }; }
private TransactionSearchValue GetSearchValue() { TransactionSearchValue searchValue = new TransactionSearchValue(); decimal?fromAmountRange = null; if (!String.IsNullOrEmpty(txtFromAmount.Text)) { fromAmountRange = Decimal.Parse(txtFromAmount.Text); } decimal?toAmountRange = null; if (!String.IsNullOrEmpty(txtToAmount.Text)) { toAmountRange = Decimal.Parse(txtToAmount.Text); } searchValue.AmountRange = new RangeValue <decimal?>(fromAmountRange, toAmountRange); if (ddlCreditCardType.SelectedValue != "-1") { searchValue.CreditCardType = definedValueService.Get(int.Parse(ddlCreditCardType.SelectedValue)); } if (ddlCurrencyType.SelectedValue != "-1") { searchValue.CurrencyType = definedValueService.Get(int.Parse(ddlCurrencyType.SelectedValue)); } DateTime?fromTransactionDate = null; if (!String.IsNullOrEmpty(txtFromDate.Text)) { fromTransactionDate = DateTime.Parse(txtFromDate.Text); } DateTime?toTransactionDate = null; if (!String.IsNullOrEmpty(txtToDate.Text)) { toTransactionDate = DateTime.Parse(txtToDate.Text); } searchValue.DateRange = new RangeValue <DateTime?>(fromTransactionDate, toTransactionDate); if (ddlFundType.SelectedValue != "-1") { searchValue.Fund = fundService.Get(int.Parse(ddlFundType.SelectedValue)); } searchValue.TransactionCode = txtTransactionCode.Text; searchValue.SourceType = definedValueService.Get(int.Parse(ddlSourceType.SelectedValue)); return(searchValue); }
/// <summary> /// Binds the grid. /// </summary> private void BindGrid() { TransactionSearchValue searchValue = GetSearchValue(); SortProperty sortProperty = rGridTransactions.SortProperty; var transactionService = new FinancialTransactionService(); var queryable = transactionService.Get(searchValue); if (sortProperty != null) { queryable = queryable.Sort(sortProperty); } else { queryable = queryable.OrderBy(t => t.TransactionDateTime); } rGridTransactions.DataSource = queryable.ToList(); rGridTransactions.DataBind(); }
private TransactionSearchValue GetSearchValue() { TransactionSearchValue searchValue = new TransactionSearchValue(); decimal?fromAmountRange = null; if (!String.IsNullOrEmpty(txtFromAmount.Text)) { fromAmountRange = Decimal.Parse(txtFromAmount.Text); } decimal?toAmountRange = null; if (!String.IsNullOrEmpty(txtToAmount.Text)) { toAmountRange = Decimal.Parse(txtToAmount.Text); } searchValue.AmountRange = new RangeValue <decimal?>(fromAmountRange, toAmountRange); if (ddlCreditCardType.SelectedValue != All.Id.ToString()) { searchValue.CreditCardTypeValueId = int.Parse(ddlCreditCardType.SelectedValue); } if (ddlCurrencyType.SelectedValue != All.Id.ToString()) { searchValue.CurrencyTypeValueId = int.Parse(ddlCurrencyType.SelectedValue); } DateTime?fromTransactionDate = dtStartDate.SelectedDate; DateTime?toTransactionDate = dtEndDate.SelectedDate; searchValue.DateRange = new RangeValue <DateTime?>(fromTransactionDate, toTransactionDate); if (ddlFundType.SelectedValue != "-1") { searchValue.FundId = int.Parse(ddlFundType.SelectedValue); } searchValue.TransactionCode = txtTransactionCode.Text; searchValue.SourceTypeValueId = int.Parse(ddlSourceType.SelectedValue); return(searchValue); }