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