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