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