public int GetTotal(int walletId) { using (SpendingEntities context = new SpendingEntities()) { try { int total = context.Transactions.Where(x => x.WalletId == walletId).Count(); return(total); } catch (ArgumentNullException e) { return(0); } catch (Exception) { throw; } } }
public List <Transaction> Paginate(int currentPageIndex, int pageSize, int walletId) { List <Transaction> transactions = null; using (SpendingEntities context = new SpendingEntities()) { try { transactions = context.Transactions.Where(x => x.WalletId == walletId) .OrderByDescending(x => x.Date) .ThenByDescending(x => x.Time) .Skip(currentPageIndex * pageSize) .Take(pageSize) .ToList(); } catch (Exception) { throw; } } return(transactions); }