/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var queryable = new FinancialTransactionService().Queryable();
// Set up the selection filter
if (_batch != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
queryable = queryable.Where(t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id);
}
else
{
// otherwise set the selection based on filter settings
if (_person != null)
{
queryable = queryable.Where(t => t.AuthorizedPersonId == _person.Id);
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = rFilter.GetUserPreference("Date Range");
if (drp.LowerValue.HasValue)
{
queryable = queryable.Where(t => t.TransactionDateTime >= drp.LowerValue.Value);
}
if (drp.UpperValue.HasValue)
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays(1);
queryable = queryable.Where(t => t.TransactionDateTime < upperDate);
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = rFilter.GetUserPreference("Amount Range");
if (nre.LowerValue.HasValue)
{
queryable = queryable.Where(t => t.Amount >= nre.LowerValue.Value);
}
if (nre.UpperValue.HasValue)
{
queryable = queryable.Where(t => t.Amount <= nre.UpperValue.Value);
}
// Transaction Code
string transactionCode = rFilter.GetUserPreference("Transaction Code");
if (!string.IsNullOrWhiteSpace(transactionCode))
{
queryable = queryable.Where(t => t.TransactionCode == transactionCode.Trim());
}
// Account Id
int accountId = int.MinValue;
if (int.TryParse(rFilter.GetUserPreference("Account"), out accountId))
{
queryable = queryable.Where(t => t.TransactionDetails.Any(d => d.AccountId == accountId));
}
// Transaction Type
int transactionTypeId = int.MinValue;
if (int.TryParse(rFilter.GetUserPreference("Transaction Type"), out transactionTypeId))
{
queryable = queryable.Where(t => t.TransactionTypeValueId == transactionTypeId);
}
// Currency Type
int currencyTypeId = int.MinValue;
if (int.TryParse(rFilter.GetUserPreference("Currency Type"), out currencyTypeId))
{
queryable = queryable.Where(t => t.CurrencyTypeValueId == currencyTypeId);
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if (int.TryParse(rFilter.GetUserPreference("Credit Card Type"), out creditCardTypeId))
{
queryable = queryable.Where(t => t.CreditCardTypeValueId == creditCardTypeId);
}
// Source Type
int sourceTypeId = int.MinValue;
if (int.TryParse(rFilter.GetUserPreference("Source Type"), out sourceTypeId))
{
queryable = queryable.Where(t => t.SourceTypeValueId == sourceTypeId);
}
}
SortProperty sortProperty = rGridTransactions.SortProperty;
if (sortProperty != null)
{
queryable = queryable.Sort(sortProperty);
}
else
{
queryable = queryable.OrderBy(t => t.TransactionDateTime);
}
rGridTransactions.DataSource = queryable.AsNoTracking().ToList();
rGridTransactions.DataBind();
}
/// <summary>
/// Binds the payments grid.
/// </summary>
private void BindPaymentsGrid()
{
int?instanceId = PageParameter("RegistrationInstanceId").AsIntegerOrNull();
if (instanceId.HasValue)
{
using (var rockContext = new RockContext())
{
// If configured for a registration and registration is null, return
int registrationEntityTypeId = EntityTypeCache.Read(typeof(Rock.Model.Registration)).Id;
// Get all the registrations for this instance
PaymentRegistrations = new RegistrationService(rockContext)
.Queryable("PersonAlias.Person,Registrants.PersonAlias.Person").AsNoTracking()
.Where(r =>
r.RegistrationInstanceId == instanceId.Value &&
!r.IsTemporary)
.ToList();
// Get the Registration Ids
var registrationIds = PaymentRegistrations
.Select(r => r.Id)
.ToList();
// Get all the transactions relate to these registrations
var qry = new FinancialTransactionService(rockContext)
.Queryable().AsNoTracking()
.Where(t => t.TransactionDetails
.Any(d =>
d.EntityTypeId.HasValue &&
d.EntityTypeId.Value == registrationEntityTypeId &&
d.EntityId.HasValue &&
registrationIds.Contains(d.EntityId.Value)));
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = fPayments.GetUserPreference("Date Range");
if (drp.LowerValue.HasValue)
{
qry = qry.Where(t => t.TransactionDateTime >= drp.LowerValue.Value);
}
if (drp.UpperValue.HasValue)
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays(1);
qry = qry.Where(t => t.TransactionDateTime < upperDate);
}
//
// Filter by currency type.
//
var currencyTypes = fPayments.GetUserPreference("Currency Type").SplitDelimitedValues().AsIntegerList();
if (currencyTypes.Any())
{
qry = qry.Where(t => t.FinancialPaymentDetail.CurrencyTypeValueId.HasValue && currencyTypes.Contains(t.FinancialPaymentDetail.CurrencyTypeValueId.Value));
}
SortProperty sortProperty = gPayments.SortProperty;
if (sortProperty != null)
{
if (sortProperty.Property == "TotalAmount")
{
if (sortProperty.Direction == SortDirection.Ascending)
{
qry = qry.OrderBy(t => t.TransactionDetails.Sum(d => ( decimal? )d.Amount) ?? 0.00M);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDetails.Sum(d => ( decimal? )d.Amount) ?? 0.0M);
}
}
else
{
qry = qry.Sort(sortProperty);
}
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDateTime).ThenByDescending(t => t.Id);
}
gPayments.SetLinqDataSource(qry.AsNoTracking());
gPayments.DataBind();
}
}
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
_currencyTypes = new Dictionary <int, string>();
_creditCardTypes = new Dictionary <int, string>();
// If configured for a registration and registration is null, return
int registrationEntityTypeId = EntityTypeCache.Read(typeof(Rock.Model.Registration)).Id;
if (ContextTypesRequired.Any(e => e.Id == registrationEntityTypeId) && _registration == null)
{
return;
}
// If configured for a person and person is null, return
int personEntityTypeId = EntityTypeCache.Read("Rock.Model.Person").Id;
if (ContextTypesRequired.Any(e => e.Id == personEntityTypeId) && _person == null)
{
return;
}
// If configured for a batch and batch is null, return
int batchEntityTypeId = EntityTypeCache.Read("Rock.Model.FinancialBatch").Id;
if (ContextTypesRequired.Any(e => e.Id == batchEntityTypeId) && _batch == null)
{
return;
}
// If configured for a batch and batch is null, return
int scheduledTxnEntityTypeId = EntityTypeCache.Read("Rock.Model.FinancialScheduledTransaction").Id;
if (ContextTypesRequired.Any(e => e.Id == scheduledTxnEntityTypeId) && _scheduledTxn == null)
{
return;
}
// Qry
var rockContext = new RockContext();
var qry = new FinancialTransactionService(rockContext).Queryable();
// Transaction Types
var txnTypes = GetAttributeValue("TransactionTypes").SplitDelimitedValues().AsGuidList();
if (txnTypes.Any())
{
qry = qry.Where(t => txnTypes.Contains(t.TransactionTypeValue.Guid));
}
// Set up the selection filter
if (_batch != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
qry = qry.Where(t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id);
// If the batch is closed, do not allow any editing of the transactions
if (_batch.Status != BatchStatus.Closed && _canEdit)
{
gTransactions.IsDeleteEnabled = true;
}
else
{
gTransactions.IsDeleteEnabled = false;
}
}
else if (_scheduledTxn != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
qry = qry.Where(t => t.ScheduledTransactionId.HasValue && t.ScheduledTransactionId.Value == _scheduledTxn.Id);
gTransactions.IsDeleteEnabled = false;
}
else if (_registration != null)
{
qry = qry
.Where(t => t.TransactionDetails
.Any(d =>
d.EntityTypeId.HasValue &&
d.EntityTypeId.Value == registrationEntityTypeId &&
d.EntityId.HasValue &&
d.EntityId.Value == _registration.Id));
gTransactions.IsDeleteEnabled = false;
}
else // Person
{
// otherwise set the selection based on filter settings
if (_person != null)
{
// get the transactions for the person or all the members in the person's giving group (Family)
qry = qry.Where(t => t.AuthorizedPersonAlias.Person.GivingId == _person.GivingId);
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = gfTransactions.GetUserPreference("Date Range");
if (drp.LowerValue.HasValue)
{
qry = qry.Where(t => t.TransactionDateTime >= drp.LowerValue.Value);
}
if (drp.UpperValue.HasValue)
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays(1);
qry = qry.Where(t => t.TransactionDateTime < upperDate);
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = gfTransactions.GetUserPreference("Amount Range");
if (nre.LowerValue.HasValue)
{
qry = qry.Where(t => t.TransactionDetails.Sum(d => d.Amount) >= nre.LowerValue.Value);
}
if (nre.UpperValue.HasValue)
{
qry = qry.Where(t => t.TransactionDetails.Sum(d => d.Amount) <= nre.UpperValue.Value);
}
// Transaction Code
string transactionCode = gfTransactions.GetUserPreference("Transaction Code");
if (!string.IsNullOrWhiteSpace(transactionCode))
{
qry = qry.Where(t => t.TransactionCode == transactionCode.Trim());
}
// Account Id
var accountIds = (gfTransactions.GetUserPreference("Account") ?? "").SplitDelimitedValues().AsIntegerList().Where(a => a > 0).ToList();
{
if (accountIds.Any())
{
qry = qry.Where(t => t.TransactionDetails.Any(d => accountIds.Contains(d.AccountId) || (d.Account.ParentAccountId.HasValue && accountIds.Contains(d.Account.ParentAccountId.Value))));
}
}
// Transaction Type
int transactionTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Transaction Type"), out transactionTypeId))
{
qry = qry.Where(t => t.TransactionTypeValueId == transactionTypeId);
}
// Currency Type
int currencyTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Currency Type"), out currencyTypeId))
{
qry = qry.Where(t => t.FinancialPaymentDetail != null && t.FinancialPaymentDetail.CurrencyTypeValueId == currencyTypeId);
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Credit Card Type"), out creditCardTypeId))
{
qry = qry.Where(t => t.FinancialPaymentDetail != null && t.FinancialPaymentDetail.CreditCardTypeValueId == creditCardTypeId);
}
// Source Type
int sourceTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Source Type"), out sourceTypeId))
{
qry = qry.Where(t => t.SourceTypeValueId == sourceTypeId);
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if (sortProperty != null)
{
if (sortProperty.Property == "TotalAmount")
{
if (sortProperty.Direction == SortDirection.Ascending)
{
qry = qry.OrderBy(t => t.TransactionDetails.Sum(d => (decimal?)d.Amount) ?? 0.00M);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDetails.Sum(d => (decimal?)d.Amount) ?? 0.0M);
}
}
else
{
qry = qry.Sort(sortProperty);
}
}
else
{
// Default sort by Id if the transations are seen via the batch,
// otherwise sort by descending date time.
if (ContextTypesRequired.Any(e => e.Id == batchEntityTypeId))
{
qry = qry.OrderBy(t => t.Id);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDateTime).ThenByDescending(t => t.Id);
}
}
gTransactions.SetLinqDataSource(qry.AsNoTracking());
gTransactions.DataBind();
if (_batch == null &&
_scheduledTxn == null &&
_registration == null &&
_person == null)
{
pnlSummary.Visible = true;
// No context - show account summary
var qryTransactionDetails = qry.SelectMany(a => a.TransactionDetails);
var accountSummaryQry = qryTransactionDetails.GroupBy(a => a.Account).Select(a => new
{
a.Key.Name,
a.Key.Order,
TotalAmount = (decimal?)a.Sum(d => d.Amount)
}).OrderBy(a => a.Order);
var summaryList = accountSummaryQry.ToList();
var grandTotalAmount = (summaryList.Count > 0) ? summaryList.Sum(a => a.TotalAmount ?? 0) : 0;
string currencyFormat = GlobalAttributesCache.Value("CurrencySymbol") + "{0:n}";
lGrandTotal.Text = string.Format(currencyFormat, grandTotalAmount);
rptAccountSummary.DataSource = summaryList.Select(a => new { a.Name, TotalAmount = string.Format(currencyFormat, a.TotalAmount) }).ToList();
rptAccountSummary.DataBind();
}
else
{
pnlSummary.Visible = false;
}
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
_currencyTypes = new Dictionary <int, string>();
_creditCardTypes = new Dictionary <int, string>();
// If configured for a person and person is null, return
int personEntityTypeId = EntityTypeCache.Read("Rock.Model.Person").Id;
if (ContextTypesRequired.Any(e => e.Id == personEntityTypeId) && _person == null)
{
return;
}
// If configured for a batch and batch is null, return
int batchEntityTypeId = EntityTypeCache.Read("Rock.Model.FinancialBatch").Id;
if (ContextTypesRequired.Any(e => e.Id == batchEntityTypeId) && _batch == null)
{
return;
}
// If configured for a batch and batch is null, return
int scheduledTxnEntityTypeId = EntityTypeCache.Read("Rock.Model.FinancialScheduledTransaction").Id;
if (ContextTypesRequired.Any(e => e.Id == scheduledTxnEntityTypeId) && _scheduledTxn == null)
{
return;
}
// Qry
var qry = new FinancialTransactionService(new RockContext())
.Queryable("AuthorizedPersonAlias.Person,ProcessedByPersonAlias.Person");
// Set up the selection filter
if (_batch != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
qry = qry.Where(t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id);
// If the batch is closed, do not allow any editing of the transactions
if (_batch.Status != BatchStatus.Closed && _canEdit)
{
gTransactions.IsDeleteEnabled = true;
}
else
{
gTransactions.IsDeleteEnabled = false;
}
}
else if (_scheduledTxn != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
qry = qry.Where(t => t.ScheduledTransactionId.HasValue && t.ScheduledTransactionId.Value == _scheduledTxn.Id);
gTransactions.IsDeleteEnabled = false;
}
else // Person
{
// otherwise set the selection based on filter settings
if (_person != null)
{
qry = qry.Where(t => t.AuthorizedPersonAlias.PersonId == _person.Id);
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = gfTransactions.GetUserPreference("Date Range");
if (drp.LowerValue.HasValue)
{
qry = qry.Where(t => t.TransactionDateTime >= drp.LowerValue.Value);
}
if (drp.UpperValue.HasValue)
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays(1);
qry = qry.Where(t => t.TransactionDateTime < upperDate);
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = gfTransactions.GetUserPreference("Amount Range");
if (nre.LowerValue.HasValue)
{
qry = qry.Where(t => t.TransactionDetails.Sum(d => d.Amount) >= nre.LowerValue.Value);
}
if (nre.UpperValue.HasValue)
{
qry = qry.Where(t => t.TransactionDetails.Sum(d => d.Amount) <= nre.UpperValue.Value);
}
// Transaction Code
string transactionCode = gfTransactions.GetUserPreference("Transaction Code");
if (!string.IsNullOrWhiteSpace(transactionCode))
{
qry = qry.Where(t => t.TransactionCode == transactionCode.Trim());
}
// Account Id
int accountId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Account"), out accountId))
{
qry = qry.Where(t => t.TransactionDetails.Any(d => d.AccountId == accountId));
}
// Transaction Type
int transactionTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Transaction Type"), out transactionTypeId))
{
qry = qry.Where(t => t.TransactionTypeValueId == transactionTypeId);
}
// Currency Type
int currencyTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Currency Type"), out currencyTypeId))
{
qry = qry.Where(t => t.CurrencyTypeValueId == currencyTypeId);
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Credit Card Type"), out creditCardTypeId))
{
qry = qry.Where(t => t.CreditCardTypeValueId == creditCardTypeId);
}
// Source Type
int sourceTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Source Type"), out sourceTypeId))
{
qry = qry.Where(t => t.SourceTypeValueId == sourceTypeId);
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if (sortProperty != null)
{
if (sortProperty.Property == "TotalAmount")
{
if (sortProperty.Direction == SortDirection.Ascending)
{
qry = qry.OrderBy(t => t.TransactionDetails.Sum(d => (decimal?)d.Amount) ?? 0.00M);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDetails.Sum(d => (decimal?)d.Amount) ?? 0.0M);
}
}
else
{
qry = qry.Sort(sortProperty);
}
}
else
{
// Default sort by Id if the transations are seen via the batch,
// otherwise sort by descending date time.
if (ContextTypesRequired.Any(e => e.Id == batchEntityTypeId))
{
qry = qry.OrderBy(t => t.Id);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDateTime).ThenByDescending(t => t.Id);
}
}
// Row Limit
int?rowLimit = gfTransactions.GetUserPreference("Row Limit").AsIntegerOrNull();
if (rowLimit.HasValue)
{
qry = qry.Take(rowLimit.Value);
}
gTransactions.DataSource = qry.AsNoTracking().ToList();
gTransactions.DataBind();
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var queryable = new FinancialTransactionService(new RockContext()).Queryable();
// Set up the selection filter
if (_batch != null)
{
// If transactions are for a batch, the filter is hidden so only check the batch id
queryable = queryable.Where(t => t.BatchId.HasValue && t.BatchId.Value == _batch.Id);
// If the batch is closed, do not allow any editing of the transactions
if (_batch.Status != BatchStatus.Open && _canConfigure)
{
gTransactions.Actions.ShowAdd = false;
gTransactions.IsDeleteEnabled = false;
}
else
{
gTransactions.Actions.ShowAdd = true;
gTransactions.IsDeleteEnabled = true;
}
}
else if (!string.IsNullOrWhiteSpace(PageParameter("financialBatchId")) && _batch == null)
{
// this makes sure the grid will show no transactions when you're adding a new financial batch.
queryable = queryable.Where(t => t.BatchId.HasValue && t.BatchId.Value == 0);
}
else
{
// otherwise set the selection based on filter settings
if (_person != null)
{
queryable = queryable.Where(t => t.AuthorizedPersonId == _person.Id);
}
// Date Range
var drp = new DateRangePicker();
drp.DelimitedValues = gfTransactions.GetUserPreference("Date Range");
if (drp.LowerValue.HasValue)
{
queryable = queryable.Where(t => t.TransactionDateTime >= drp.LowerValue.Value);
}
if (drp.UpperValue.HasValue)
{
DateTime upperDate = drp.UpperValue.Value.Date.AddDays(1);
queryable = queryable.Where(t => t.TransactionDateTime < upperDate);
}
// Amount Range
var nre = new NumberRangeEditor();
nre.DelimitedValues = gfTransactions.GetUserPreference("Amount Range");
if (nre.LowerValue.HasValue)
{
queryable = queryable.Where(t => t.TransactionDetails.Sum(d => d.Amount) >= nre.LowerValue.Value);
}
if (nre.UpperValue.HasValue)
{
queryable = queryable.Where(t => t.TransactionDetails.Sum(d => d.Amount) <= nre.UpperValue.Value);
}
// Transaction Code
string transactionCode = gfTransactions.GetUserPreference("Transaction Code");
if (!string.IsNullOrWhiteSpace(transactionCode))
{
queryable = queryable.Where(t => t.TransactionCode == transactionCode.Trim());
}
// Account Id
int accountId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Account"), out accountId))
{
queryable = queryable.Where(t => t.TransactionDetails.Any(d => d.AccountId == accountId));
}
// Transaction Type
int transactionTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Transaction Type"), out transactionTypeId))
{
queryable = queryable.Where(t => t.TransactionTypeValueId == transactionTypeId);
}
// Currency Type
int currencyTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Currency Type"), out currencyTypeId))
{
queryable = queryable.Where(t => t.CurrencyTypeValueId == currencyTypeId);
}
// Credit Card Type
int creditCardTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Credit Card Type"), out creditCardTypeId))
{
queryable = queryable.Where(t => t.CreditCardTypeValueId == creditCardTypeId);
}
// Source Type
int sourceTypeId = int.MinValue;
if (int.TryParse(gfTransactions.GetUserPreference("Source Type"), out sourceTypeId))
{
queryable = queryable.Where(t => t.SourceTypeValueId == sourceTypeId);
}
}
SortProperty sortProperty = gTransactions.SortProperty;
if (sortProperty != null)
{
if (sortProperty.Property == "TotalAmount")
{
if (sortProperty.Direction == SortDirection.Ascending)
{
queryable = queryable.OrderBy(t => t.TransactionDetails.Sum(d => d.Amount));
}
else
{
queryable = queryable.OrderByDescending(t => t.TransactionDetails.Sum(d => d.Amount));
}
}
else
{
queryable = queryable.Sort(sortProperty);
}
}
else
{
queryable = queryable.OrderBy(t => t.TransactionDateTime);
}
gTransactions.DataSource = queryable.AsNoTracking().ToList();
gTransactions.DataBind();
}
/// <summary>
/// Binds the payments grid.
/// </summary>
private void BindPaymentsGrid()
{
int?instanceId = this.RegistrationInstanceId;
if (instanceId.HasValue)
{
using (var rockContext = new RockContext())
{
var currencyTypes = new Dictionary <int, string>();
var creditCardTypes = new Dictionary <int, string>();
// If configured for a registration and registration is null, return
int registrationEntityTypeId = EntityTypeCache.Get(typeof(Rock.Model.Registration)).Id;
// Get all the registrations for this instance
_paymentRegistrations = new RegistrationService(rockContext)
.Queryable("PersonAlias.Person,Registrants.PersonAlias.Person").AsNoTracking()
.Where(r =>
r.RegistrationInstanceId == instanceId.Value &&
!r.IsTemporary)
.ToList();
// Get the Registration Ids
var registrationIds = _paymentRegistrations
.Select(r => r.Id)
.ToList();
// Get all the transactions relate to these registrations
var qry = new FinancialTransactionService(rockContext)
.Queryable().AsNoTracking()
.Where(t => t.TransactionDetails
.Any(d =>
d.EntityTypeId.HasValue &&
d.EntityTypeId.Value == registrationEntityTypeId &&
d.EntityId.HasValue &&
registrationIds.Contains(d.EntityId.Value)));
// Date Range
var dateRange = SlidingDateRangePicker.CalculateDateRangeFromDelimitedValues(sdrpPaymentDateRange.DelimitedValues);
if (dateRange.Start.HasValue)
{
qry = qry.Where(r =>
r.TransactionDateTime >= dateRange.Start.Value);
}
if (dateRange.End.HasValue)
{
qry = qry.Where(r =>
r.TransactionDateTime < dateRange.End.Value);
}
SortProperty sortProperty = gPayments.SortProperty;
if (sortProperty != null)
{
if (sortProperty.Property == "TotalAmount")
{
if (sortProperty.Direction == SortDirection.Ascending)
{
qry = qry.OrderBy(t => t.TransactionDetails.Sum(d => ( decimal? )d.Amount) ?? 0.00M);
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDetails.Sum(d => ( decimal? )d.Amount) ?? 0.0M);
}
}
else
{
qry = qry.Sort(sortProperty);
}
}
else
{
qry = qry.OrderByDescending(t => t.TransactionDateTime).ThenByDescending(t => t.Id);
}
gPayments.SetLinqDataSource(qry.AsNoTracking());
gPayments.DataBind();
}
}
}
