/// <summary> /// Get all accounts /// </summary> /// <returns></returns> public ObservableCollection<Account> GetAllAccounts() { try { aDBE = new AccountDatabaseEntities(); ObservableCollection<Account>converted = new ObservableCollection<Account>(); var accounts = from q in aDBE.Accounts select q; foreach (Accounts p in accounts) { Account acc = new Account(p.AccountNr, p.AccountName, p.AccountBank, p.AccountBalance); converted.Add(acc); } Console.WriteLine("Get accounts => " + converted.Count); return converted; } catch (Exception ex) { Console.WriteLine("Exception ADD => " + ex.Message); } finally { aDBE.Dispose(); } return null; }
/// <summary> /// Validate if AccountNr exist. /// </summary> /// <param name="accountNr">String accountNr</param> /// <returns>Boolean true if exist</returns> public Boolean AccountNrExist(String accountNr) { try { aDBE = new AccountDatabaseEntities(); var result = from b in aDBE.Accounts where b.AccountNr == accountNr select b; foreach (Accounts p in result) { if(p.AccountNr.Equals(accountNr)) return true; } } catch (Exception ex) { Console.WriteLine("Exception " + ex.Message); } finally { aDBE.Dispose(); } return false; }