public List <TransactionDTO> GetTransactions(TransactionSearchCriteriaDTO searchCriteria)
{
List <TransactionDTO> trans;
using (var dbctx = new ExpenseTrackerEntities())
{
dbctx.Configuration.ProxyCreationEnabled = false;
trans = dbctx.Transactions
.Where(t => t.TransactionDate >= searchCriteria.StartDate.Date &&
t.TransactionDate <= searchCriteria.EndDate)
.Include(t => t.TransactionCategory)
.OrderBy(t => t.TransactionDate)
.Select(t => new TransactionDTO
{
TransactionId = t.TransactionId,
TransactionAmount = t.TransactionAmount,
TransactionDate = t.TransactionDate,
TransactionNote = t.TransactionNote,
TransactionCategory = new TransactionCategoryDTO {
CategoryName = t.TransactionCategory.CategoryName
},
HasReceipts = t.TransactionReceipts.Any()
})
.ToList();
}
return(trans);
}
public List <TransactionDTO> GetTransactions(TransactionSearchCriteriaDTO searchCriteria)
{
return(DataFactory.GetUserData().GetTransactions(searchCriteria));
}
public List <TransactionDTO> GetTransactions(TransactionSearchCriteriaDTO searchCriteria)
{
return(BusinessFactory.GetUserProcess().GetTransactions(searchCriteria));
}
