/// <summary> /// Get all ISO 4217 currency codes /// </summary> /// <returns></returns> public List<string> GetCurrency() { using(AccountTransactionContext context = new AccountTransactionContext()) { return context.CurrencyCode.Select(x => x.CurrencyCode).ToList(); } }
/// <summary> /// Save Account data to DB /// </summary> /// <param name="account"></param> /// <param name="description"></param> /// <param name="currencyCode"></param> /// <param name="amount"></param> public void SaveAccountDetails(string account, string description, string currencyCode, string amount) { AccountTransaction acntTransn = new AccountTransaction(); acntTransn.Account = account; acntTransn.Description = description; acntTransn.CurrencyCode = currencyCode; acntTransn.Amount = Convert.ToDecimal(amount); using(AccountTransactionContext context = new AccountTransactionContext()) { context.Accounts.Add(acntTransn); context.SaveChanges(); } }