//выписка движение по счету public IEnumerable <TransactionData> Movement(int accountNo) { using (AccountEntities db = new AccountEntities()) { if (db.accounts.Any(a => a.account == accountNo)) { int accId = db.accounts.First(a => a.account == accountNo).id; var movement = db.transactions. Where(t => t.accId == accId). OrderBy(t => t.transDate).ToList(); List <TransactionData> result = new List <TransactionData>(); foreach (var t in movement) { result.Add(new TransactionData { transDate = t.transDate, transAmount = t.transAmount }); } return(result); } else { throw new ArgumentException(); } } }
//определение, существует ли в базе счет с данным номером public bool AccountExists(int accountNo) { using (AccountEntities db = new AccountEntities()) { return(db.accounts.Any(a => a.account == accountNo)); } }
//баналс по счету с данным номером public decimal Balance(int accountNo) { using (AccountEntities db = new AccountEntities()) { if (db.accounts.Any(a => a.account == accountNo)) { return(db.accounts.First(a => a.account == accountNo).balance); } else { throw new ArgumentException(); } } }
public void Delete(int accountNo) { using (AccountEntities db = new AccountEntities()) { if (db.accounts.Any(a => a.account == accountNo)) { accounts account = db.accounts.First(a => a.account == accountNo); db.accounts.Remove(account); db.SaveChanges(); } else { throw new ArgumentException(); } } }
public void Create(int accountNo) { using (AccountEntities db = new AccountEntities()) { if (!db.accounts.Any(a => a.account == accountNo)) { accounts account = new accounts { account = accountNo, balance = 0 }; db.accounts.Add(account); db.SaveChanges(); } else { throw new ArgumentException(); } } }
public void Change(int accountNo, decimal sum) { using (AccountEntities db = new AccountEntities()) { if (db.accounts.Any(a => a.account == accountNo)) { accounts account = db.accounts.First(a => a.account == accountNo); transactions transaction = new transactions { accounts = account, transAmount = sum, transDate = DateTime.Now }; db.transactions.Add(transaction); db.SaveChanges(); } else { throw new ArgumentException(); } } }