public List <string> GetGroups() { using (var ctx = new BankAContext()) { return(ctx.BankTransactions.Select(o => o.TagGroup).Distinct().ToList()); } }
public void DeleteAccountAndTransactions(int accountID) { using (var ctx = new BankAContext()) { var transactions = ctx.BankTransactions.Where(q => q.AccountID == accountID); foreach (var item in transactions) { ctx.BankTransactions.Remove(item); } var account = ctx.BankAccounts.Find(accountID); ctx.BankAccounts.Remove(account); ctx.SaveChanges(); } }
public void AddTransactions(BankFile statementFile, List <BankTransaction> transactionLst) { using (var ctx = new BankAContext()) { ctx.BankFiles.Add(statementFile); foreach (var transaction in transactionLst.OrderBy(o => o.TransactionDate).ToList()) { var exists = ctx.BankTransactions.Any(q => q.TransactionDate == transaction.TransactionDate && q.AccountID == statementFile.AccountID && q.DebitAmount == transaction.DebitAmount && q.CreditAmount == transaction.CreditAmount); if (exists == false) { transaction.AccountID = statementFile.AccountID; transaction.FileID = statementFile.FileID; ctx.BankTransactions.Add(transaction); } } ctx.SaveChanges(); } }
public Repository() { ctx = new BankAContext(); }
public Repository(string currentUser) { this.currentUser = currentUser; ctx = new BankAContext(currentUser); }