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